Invoice Ninja + Google Sheets + Streak Integrations

How to connect Invoice Ninja + Google Sheets + Streak

Zapier lets you send info between Invoice Ninja and Google Sheets and Streak automatically—no code required. With 6,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Do even more with Invoice Ninja + Google Sheets + Streak

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Invoice Ninja, Google Sheets, and Streak. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

New Client
Triggers when a new client is added.
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is added.
Trigger
Instant
Try It
New Project
Triggers when a new project is added.
Trigger
Instant
Try It
Sent Invoice
Triggers when an invoice is sent.
Trigger
Instant
Try It
Update Client
Triggers when a client is updated.
Trigger
Instant
Try It

Update Payment
Triggers when a payment is updated.
Trigger
Instant
Try It
- Client Name
- First Name
- Last Name
- Email
- Phone
- Language Code
- Currency Code
- Id Number
- VAT Number
- Phone
- Street Address
- Apt/Suite
- City
- State/Province
- Postal Code
- Country Code
- Shipping Street Address
- Shipping Apt/Suite
- Shipping City
- Shipping State/Province
- Shipping Postal Code
- Shipping Country Code
- Private Notes
- Public Notes
- Website
- Custom Value 1
- Custom Value 2
- Custom Value 3
- Custom Value 4
Action
Write

- Quote IDRequired
Action
Write
- ClientRequired
- Payment Date
- Invoice
- Amount
- Payment Type
- Transfer Reference
- Private Notes
Action
Write
- ClientRequired
- NameRequired
- Task Rate
- Private Notes
- Public Notes
- Task Rate
- Budgeted Hours
- Due Date
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
Action
Write
- Client IDRequired
- FrequencyRequired
- Due Date
- Start Date
- Remaining Cycles
- Mark Ready
- Auto-Bill
- Discount
- PO Number
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
- Custom Surcharge 1
- Custom Surcharge 2
- Custom Surcharge 3
- Custom Surcharge 4
- Is Amount Discount
- Partial/Deposit
- Partial Due Date
- Cost
- Quantity
- Product
- Discount
- Description
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
- Product Cost
- Public Notes
- Private Notes
- Terms
- footer
Action
Write
- Search FieldRequired
- Search ValueRequired
- Include Deleted
Action
Search
- Search FieldRequired
- Search ValueRequired
Action
Search
- Search FieldRequired
- Search ValueRequired
- Include PDF
Action
Search
- Search FieldRequired
- Search ValueRequired
- Download PDF
- Client IDRequired
- Send Email
- Email Template
- Auto-Bill Invoice
- Mark Sent
- Paid
- Amount Paid
- Number
- Discount
- PO Number
- Date
- Due Date
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
- Custom Surcharge 1
- Custom Surcharge 2
- Custom Surcharge 3
- Custom Surcharge 4
- Is Amount Discount
- Partial/Deposit
- Partial Due Date
- Cost
- Quantity
- Product
- Discount
- Description
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
- Product Cost
- Public Notes
- Private Notes
- Terms
- footer
Action
Search or write
- Search FieldRequired
- Search ValueRequired
- Include Deleted
- ClientRequired
- NameRequired
- Task Rate
- Private Notes
- Public Notes
- Budgeted Hours
- Due Date
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
Action
Search or write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search or write
- Stage
- PipelineRequired
Trigger
Instant
Try It
- PipelineRequired
Trigger
Instant
Try It
- Team KeyRequired
Trigger
Instant
Try It
- TeamRequired
Trigger
Instant
Try It
- PipelineRequired
Trigger
Instant
Try It
- Box KeyRequired
- Contact EmailRequired
- Contact First Name
- Title
- Contact Last Name
- Phone Number(s)
- Twitter
- Facebook
- LinkedIn
- Address
- Contact Notes
Action
Write
- PipelineRequired
- NameRequired
- Assigned To
- Notes
- GmailThreadID
- Create Tag and Dropdown Options
Action
Write
- Box Name or KeyRequired
- Pipeline
- TextRequired
- Due Date
- Assign To
Action
Write
- Assign To
- Box Key
- Task Text
- Task Key
- Completed
- Due Date
Action
Write
- Thread KeyRequired
Action
Write
- Box KeyRequired
- Meeting TypeRequired
- Start TimeRequired
- End Time
- Notes
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Contact or Box Key
- Search Query
- Teams
Action
Search
- Exact Search
- Search Query
- Pipelines
- PipelineRequired
- NameRequired
- Assigned To
- Notes
- GmailThreadID
Action
Search or write

New Credit
Triggers when a new credit is added.
Trigger
Instant
Try It
New Payment
Triggers when a new payment is added.
Trigger
Instant
Try It
New Quote
Triggers when a new quote is added.
Trigger
Instant
Try It
Sent Quote
Triggers when a quote is sent.
Trigger
Instant
Try It
Update Invoice
Triggers when an invoice is updated.
Trigger
Instant
Try It
Update Quote
Triggers when a quote is updated.
Trigger
Instant
Try It
- Invoice IDRequired
Action
Write
- Client IDRequired
- Send Email
- Email Template
- Auto-Bill Invoice
- Download PDF
- Mark Sent
- Paid
- Amount Paid
- Number
- Discount
- PO Number
- Date
- Due Date
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
- Custom Surcharge 1
- Custom Surcharge 2
- Custom Surcharge 3
- Custom Surcharge 4
- Is Amount Discount
- Partial/Deposit
- Partial Due Date
- Cost
- Quantity
- Product
- Discount
- Description
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
- Product Cost
- Public Notes
- Private Notes
- Terms
- footer
Action
Write
- Product Key
- Notes
- Price
- Quantity
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Value 1
- Custom Value 2
- Custom Value 3
- Custom Value 4
Action
Write
- Client IDRequired
- Send Email
- Email Template
- Download PDF
- Mark Sent
- Number
- Discount
- PO Number
- Date
- Valid Until
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
- Custom Surcharge 1
- Custom Surcharge 2
- Custom Surcharge 3
- Custom Surcharge 4
- Is Amount Discount
- Partial/Deposit
- Partial Due Date
- Cost
- Quantity
- Product
- Discount
- Description
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
- Product Cost
- Public Notes
- Private Notes
- Terms
- footer
Action
Write
- Client
- Project
- Description
- Rate
- Start Date/Time
- End Date/Time
- Duration (Hours)
- Duration (Minutes)
- Duration (Seconds)
- Custom Value 1
- Custom Value 2
- Custom Value 3
- Custom Value 4
Action
Write
- Search FieldRequired
- Search ValueRequired
- Include PDF
Action
Search
- Search FieldRequired
- Search ValueRequired
- Include Deleted
Action
Search
- Search FieldRequired
- Search ValueRequired
- Include Deleted
- Client Name
- First Name
- Last Name
- Email
- Phone
- Language Code
- Currency Code
- Id Number
- VAT Number
- Street Address
- Apt/Suite
- City
- State/Province
- Postal Code
- Country Code
- Shipping Street Address
- Shipping Apt/Suite
- Shipping City
- Shipping State/Province
- Shipping Postal Code
- Shipping Country Code
- Private Notes
- Public Notes
- Website
- Custom Value 1
- Custom Value 2
- Custom Value 3
- Custom Value 4
Action
Search or write
- Search FieldRequired
- Search ValueRequired
- Product Key
- Notes
- Price
- Quantity
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Value 1
- Custom Value 2
- Custom Value 3
- Custom Value 4
Action
Search or write
- Search FieldRequired
- Search ValueRequired
- Download PDF
- Client IDRequired
- Send Email
- Email Template
- Mark Sent
- Number
- Discount
- PO Number
- Date
- Valid Until
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
- Custom Surcharge 1
- Custom Surcharge 2
- Custom Surcharge 3
- Custom Surcharge 4
- Is Amount Discount
- Partial/Deposit
- Partial Due Date
- Cost
- Quantity
- Product
- Discount
- Description
- Tax Rate 1
- Tax Name 1
- Tax Rate 2
- Tax Name 2
- Tax Rate 3
- Tax Name 3
- Custom Field 1
- Custom Field 2
- Custom Field 3
- Custom Field 4
- Product Cost
- Public Notes
- Private Notes
- Terms
- footer
Action
Search or write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write
- PipelineRequired
Trigger
Instant
Try It
- Stage
- Field
- PipelineRequired
Trigger
Instant
Try It
- PipelineRequired
Trigger
Instant
Try It
- PipelineRequired
Trigger
Instant
Try It
- PipelineRequired
Trigger
Instant
Try It
- PipelineRequired
Trigger
Instant
Try It
- Box KeyRequired
- Organization NameRequired
- Website(s)Required
- Industry
- Phone Number(s)
- Address(es)
- Employee Count
- Logo URL
- Twitter Handle
- Facebook Handle
- LinkedIn Handle
Action
Write
- Box Name or KeyRequired
- Pipeline
- MessageRequired
Action
Write
- Box Name or KeyRequired
- Pipeline
- Name
- Note
- Assigned To
- Gmail Thread Id
- Create Tag and Dropdown Options
Action
Write
- File KeyRequired
Action
Write
- Pipeline
- Box Name or KeysRequired
- Box Names or KeysRequired
Action
Write
- Contact KeyRequired
- First Name
- Last Name
- Email Address(es)
- Title
- Twitter
- Facebook
- LinkedIn
- Photo (Url)
- Phone Numbers
- Address(es)
- Other
Action
Write
- Exact Search
- Search Query
- Pipelines
Action
Search
- Organization or Box Key
- Search Query
- Team
Action
Search
- Pipelines
- Search Query
- NameRequired
- PipelineRequired
- Assigned To
- Notes
- GmailThreadID
Action
Search or write

Top companies trust Zapier to automate work and free up time

Join millions worldwide who automate their work using Zapier

How Invoice Ninja + Google Sheets + Streak Integrations Work

Step 1: Authenticate Invoice Ninja, Google Sheets, and Streak.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect Invoice Ninja + Google Sheets + Streak

About Invoice Ninja

Create. Send. Get Paid. Invoice Ninja is a free, code-available suite of apps to invoice clients, accept payments, track expenses & time billable-tasks. Designed for freelancers and small to medium-sized businesses to increase efficiency, Invoice Ninja will help you get paid!

Learn more Help