Create rows in Google Sheets for new Invoice Ninja clients
Effortlessly manage your new clients in Invoice Ninja by creating a streamlined workflow to add them to Google Sheets. This automation instantly adds new client details from Invoice Ninja to a new row in your chosen spreadsheet, making it easier than ever to maintain an organized and up-to-date database. Save time and stay on top of your client information without lifting a finger.
- When this happens...

New ClientTriggers when a new client is added.TriggerInstant - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Invoice Ninja and Google Sheets
Discover other triggers and actions you can use with Invoice Ninja and Google Sheets
New ClientTriggers when a new client is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New InvoiceTriggers when a new invoice is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ProjectTriggers when a new project is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Sent InvoiceTriggers when an invoice is sent.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Update ClientTriggers when a client is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Update PaymentTriggers when a payment is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Client Name
- Group
- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Client IDRequired
- Design
- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Client IDRequired
- Design
- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search FieldRequired
- Search ValueRequired
- Include PDF
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search FieldRequired
- Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search FieldRequired
- Search ValueRequired
- Include PDF
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search FieldRequired
- Search ValueRequired
- Download PDF
- Client IDRequired
- Design
- Send Email
- Email Template
- Auto-Bill Credit
- 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Search FieldRequired
- Search ValueRequired
- Download PDF
- Client IDRequired
- Design
- 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column_nameRequired
- Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- TitleRequired
- Spreadsheet to Copy
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Overwrite All Columns
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Api_docs_info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- Spreadsheet NameRequired
- Search Type
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New CreditTriggers when a new credit is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New PaymentTriggers when a new payment is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New QuoteTriggers when a new quote is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Sent QuoteTriggers when a quote is sent.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Update InvoiceTriggers when an invoice is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Update QuoteTriggers when a quote is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Client IDRequired
- Design
- Send Email
- Email Template
- Auto-Bill Credit
- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ClientRequired
- Payment Date
- Invoice
- Amount
- Payment Type
- Transfer Reference
- Private Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Client IDRequired
- Design
- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search FieldRequired
- Search ValueRequired
- Include Deleted
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search FieldRequired
- Search ValueRequired
- Include PDF
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search FieldRequired
- Search ValueRequired
- Include Deleted
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search FieldRequired
- Search ValueRequired
- Include Deleted
- Client Name
- Group
- 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Search FieldRequired
- Search ValueRequired
- Download PDF
- Client IDRequired
- Design
- 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- First row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- Spreadsheet NameRequired
- Search Type
- Spreadsheet to Copy
- Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found







