Google Sheets + Zoho Invoice
Create Google Sheets rows for updated invoice status changes in Zoho Invoice
Keep your financial records organized and updated with this workflow. When an invoice status changes in Zoho Invoice, a new row will be immediately added in Google Sheets, allowing you to track and monitor your invoicing process with ease. This simplifies your accounting tasks and keeps your data accurately recorded in real time.
Keep your financial records organized and updated with this workflow. When an invoice status changes in Zoho Invoice, a new row will be immediately added in Google Sheets, allowing you to track and monitor your invoicing process with ease. This simplifies your accounting tasks and keeps your data accurately recorded in real time.
- When this happens...
Invoice Status ChangeTriggers when an invoice status is changed.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Organization
ContactRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planOrganization
ContactRequired
Salutation
First Name
Last Name
Email
Phone
Mobile
Skype
Designation
Department
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organization
Credit Note Number
Customer NameRequired
Reason
Credit Note DateRequired
NameRequired
RateRequired
QuantityRequired
Discount
Description
Discount Type
Discount
Exchange Rate
Notes
Terms
Shipping Charge
Invoice Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Estimate Number
Customer NameRequired
Estimate Date
Expiry Date
NameRequired
RateRequired
QuantityRequired
Discount
Description
Discount Type
Discount
Exchange Rate
Estimate Notes
Estimate Terms
Shipping Charge
Send Invoice Only to Primary Contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organization
Item NameRequired
RateRequired
Item Description
SKU
Unit
Is Taxable
Tax Exemption
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Customer IDRequired
Contact Name
Contact Type
Company Name
Website
Payment Terms
Notes
Language
Billing Address
Billing Address Street
Billing Address City
Billing Address State
Billing Address ZIP
Billing Address Country
Billing Address Fax
Billing Address Phone
Shipping Address
Shipping Address Street
Shipping Address City
Shipping Address State
Shipping Address ZIP
Shipping Country
Shipping Address Fax
Shipping Address Phone
Contact Person Phone Number
Salutation
First Name
Last Name
EmailID
Mobile
Phone
Primary Contact
Currency
GST Treatment
GSTIN or UIN
Place of Contact
Tax Preference
Vat Treatment
TRN Number
Tax Treatment
Tax Exempt Code
Tax Authority Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organization
Invoice Number
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
OrganizationsRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrganizationsRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrganizationsRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrganizationRequired
Status
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrganizationsRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrganizationsRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrganizationRequired
Customer NameRequired
Invoice NumberRequired
Payment ModeRequired
AmountRequired
Description
Reference Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Contact NameRequired
Contact Type
Company Name
Website
Payment Terms
Notes
Language
Billing Address
Billing Address Street
Billing Address City
Billing Address State
Billing Address ZIP
Billing Address Country
Billing Address Fax
Billing Address Phone
Shipping Address
Shipping Address Street
Shipping Address City
Shipping Address State
Shipping Address ZIP
Shipping Country
Shipping Address Fax
Shipping Address Phone
Salutation
First Name
Last Name
EmailID
Mobile
Phone
Primary Contact
Currency
GST Treatment
GSTIN or UIN
Place of Contact
Tax Preference
Vat Treatment
TRN Number
Tax Treatment
Tax Exempt Code
Tax Authority Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Customer Name
Customer ID
Invoice Number
Invoice Date
Due Date
Order Number
Payment Terms
Line Item NameRequired
Line Item RateRequired
Line Item QuantityRequired
Line Item Description
Line Item Discount
Tax Rate
Exchange Rate
Discount
Discount Before Tax
Discount Type
Notes
Terms
Allow Partial Payments
Shipping Charge
Adjustments
Adjustment Description
Salesperson Name
Tax Inclusive
Payment Gateway
Paypal Payment Method
Send Invoice Only to Primary Contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organization
Retainer Invoice Number
Customer NameRequired
Retainer Invoice DateRequired
DescriptionRequired
RateRequired
Retainer Invoice Notes
Retainer Invoice Terms
Send Retainer Invoice Only to Primary Contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Customer NameRequired
Invoice NumberRequired
Invoice Date
Due Date
Order Number
Payment Terms
Line Item NameRequired
Line Item RateRequired
Line Item QuantityRequired
Line Item Description
Line Item Discount
Tax Rate
HSN or SAC
Exchange Rate
Discount
Discount Before Tax
Discount Type
Notes
ReasonRequired
Terms
Allow Partial Payments
Shipping Charge
Adjustments
Adjustment Description
Salesperson Name
Tax Inclusive
Send Invoice Only to Primary Contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organization
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appOrganization NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text Strikethrough
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
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
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
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About Zoho Invoice
Zoho Invoice is an easy invoice software meant for small businesses and freelancers. Accept payments online, automate payment reminders and recurring billing.
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new invoices in Zoho Invoice
- Create Zoho Invoice contacts from new Google Sheets rows
- Create new Zoho Invoice estimates from new Google Sheets rows
- Create Zoho Invoice contacts from new or updated Google Sheets rows
- Create new Zoho Invoice invoices from new Google Sheets rows
- Create Zoho Invoice invoices from new or updated Google Sheets rows
- Create spreadsheet rows in Google Sheets for new contacts from Zoho Invoice
- Create new Zoho Invoice estimates from new Google Sheets rows
- Create rows in Google Sheets for new customer payments in Zoho Invoice
- Create spreadsheet rows in Google Sheets for new estimates in Zoho Invoice
- Update Google Sheets rows with new Zoho Invoice contacts
- Update Google Sheets rows when new customer payments occur in Zoho Invoice
- Update Google Sheets rows with new Zoho Invoice invoices instantly
- Create Google Sheets rows for new Zoho Invoice invoices
- Create spreadsheet rows in Google Sheets for new contacts in Zoho Invoice
- Create new Zoho Invoice invoices from new rows in Google Sheets
- Create Google Sheets rows for new Zoho Invoice expenses
- Create new spreadsheet rows in Google Sheets for each new invoice in Zoho Invoice
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new invoices in Zoho Invoice
- Create Zoho Invoice contacts from new or updated Google Sheets rows
- Create spreadsheet rows in Google Sheets for new contacts from Zoho Invoice
- Create spreadsheet rows in Google Sheets for new estimates in Zoho Invoice
- Update Google Sheets rows with new Zoho Invoice invoices instantly
- Create new Zoho Invoice estimates from new Google Sheets rows
- Create Zoho Invoice invoices from new or updated Google Sheets rows
- Create rows in Google Sheets for new customer payments in Zoho Invoice
- Update Google Sheets rows when new customer payments occur in Zoho Invoice
- Create spreadsheet rows in Google Sheets for new contacts in Zoho Invoice