Google Sheets + Zoho Books

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.

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.

  1. When this happens...
    Zoho BooksZoho Books
    New Customer

    Triggers when a new customer is created.

    TriggerInstant
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • OrganizationRequired

    Trigger
    Instant
    Try It
    • OrganizationRequired

    Trigger
    Instant
    Try It
    • OrganizationRequired

    Trigger
    Instant
    Try It
    • Organization NameRequired

    • Customer NameRequired

    • Estimate Number

    • Date

    • Expiry Date

    • NameRequired

    • RateRequired

    • QuantityRequired

    • Discount

    • Description

    • Exchange Rate

    • Estimate Notes

    • Send

    • Estimate Terms

    • Shipping Charge

    Action
    Write
    • OrganizationRequired

    Trigger
    Instant
    Try It
    • Status

    • OrganizationRequired

    Trigger
    Instant
    Try It
    • 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

    Action
    Write
    • 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

    Action
    Write
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
zoho-books logo
zoho-books logo

About Zoho Books

Zoho Books is cloud-based accounting software in which you can record, audit and analyze all financial transactions easily. With secure data storage, easy navigation and customizable features, Zoho Books provide a head start in accounting for small businesses.

Related categories

  • Accounting
  • Zoho