Refound your company for the AI era at ZapConnect 2026. Save your spot →
Google Sheets + Zoho Books integrations
Add new Zoho Books customers to new rows on Google Sheets
A spreadsheet with your customer information gives you a great deal of filtering and sorting power. Activate this integration and we'll make sure it's always updated. Whenever you add a new entry to your customer database on Zoho Books, the automation will capture it, adding the details to a new row on Google Sheets so you have all the latest names within reach at all times.
How this Zoho Books-Google Sheets integration works
- A new customer is added in Zoho Books
- Zapier adds a new row to Google Sheets
Apps Involved
- Zoho Books
- Google Sheets
- When this happens...New CustomerTriggers when a new customer is created.
- automatically do this!Create Spreadsheet RowCreate a new row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Zoho Books and Google Sheets
Discover other triggers and actions you can use with Zoho Books and Google Sheets
- OrganizationRequired
Try ItTriggerInstant- OrganizationRequired
Try ItTriggerInstant- OrganizationRequired
Try ItTriggerInstant- Organization NameRequired
- Customer NameRequired
- Estimate Number
- Date
- Expiry Date
- NameRequired
- RateRequired
- QuantityRequired
- Discount
- Description
- Exchange Rate
- Estimate Notes
- Send
- Estimate Terms
- Shipping Charge
ActionWrite
- OrganizationRequired
Try ItTriggerInstant- Status
- OrganizationRequired
Try ItTriggerInstant- OrganizationRequired
- 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
ActionWrite- 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
ActionWrite
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related categories
Related Zap Templates
- Create Google Sheet rows for new Zoho Books sales invoices
- Create Zoho Books sales invoices from new or updated Google Sheets rows
- Create rows in Google Sheets for new Zoho Books expenses
- Create spreadsheets from new sales invoices in Google Sheets for Zoho Books
- Update Google Sheets rows for new Zoho Books sales invoices






