Google Sheets + Zoho Invoice
Create Google Sheets rows for new Zoho Invoice expenses
When a new expense is logged in Zoho Invoice, this workflow promptly inserts a corresponding row in your Google Sheets spreadsheet. Avoid the hassle of manual data transfer and ensure real-time financial tracking with this efficient automation. It's an excellent solution for maintaining organized and up-to-date expense records.
When a new expense is logged in Zoho Invoice, this workflow promptly inserts a corresponding row in your Google Sheets spreadsheet. Avoid the hassle of manual data transfer and ensure real-time financial tracking with this efficient automation. It's an excellent solution for maintaining organized and up-to-date expense records.
- When this happens...
New ExpenseTriggers when an expense is created.
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 ZapPollingZapier 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.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.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 ZapPollingZapier 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.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.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
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.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
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
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
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
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
About Google Sheets
Related categories
About Zoho Invoice
Related categories
Related Zap Templates
- 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 new spreadsheet rows in Google Sheets for each new invoice in Zoho Invoice
- Create new Zoho Invoice invoices from new or updated rows in Google Sheets