Google Sheets + Zoho Books
Update Google Sheets rows for new Zoho Books sales invoices
Keep your sales data organized and up-to-date with this efficient workflow. When a new sales invoice is created in Zoho Books, it will update the corresponding row in your Google Sheets spreadsheet. This automation helps you maintain accurate records without the hassle of manual data entry, saving you time and reducing the risk of errors.
Keep your sales data organized and up-to-date with this efficient workflow. When a new sales invoice is created in Zoho Books, it will update the corresponding row in your Google Sheets spreadsheet. This automation helps you maintain accurate records without the hassle of manual data entry, saving you time and reducing the risk of errors.
- When this happens...New Sales Invoice
Triggers when a new sales invoice is created.
- automatically do this!Update Spreadsheet Row(s)
Update one or more rows in a specific spreadsheet (with line item support).
- Free forever for core features
- 14 day trial for premium features & apps
OrganizationRequired
Try ItOrganizationRequired
Try ItOrganizationRequired
Try ItOrganization NameRequired
Customer NameRequired
Estimate Number
Date
Expiry Date
NameRequired
RateRequired
QuantityRequired
Discount
Description
Exchange Rate
Estimate Notes
Send
Estimate Terms
Shipping Charge
OrganizationRequired
Try ItStatus
OrganizationRequired
Try ItOrganizationRequired
PAN Number
GSTIN or UIN
GST Treatment
Place of Contact
Contact NameRequired
Company Name
First Name
Last Name
Email
Website
Phone
Mobile
Billing Address Address
Billing Address City
Billing Address Zip
Billing Address State
Billing Address Country
Billing Address Fax
Shipping Address Address
Shipping Address City
Shipping Address State
Shipping Address Country
Shipping Address Fax
Shipping Address Zip
Payment Terms
Notes
Vat Treatment
Tax Treatment
TRN Number
Place of Supply
OrganizationRequired
Customer NameRequired
Invoice Number
Invoice Date
Due Date
Payment Terms
Discount
Exchange Rate
Item NameRequired
Description
QuantityRequired
RateRequired
Discount ($)
Payment Options
Shipping Charge
Adjustment
Allow Partial Payment
Notes
Send
VAT Treatment
Tax Treatment
Reference Number
