Zoho Books + Zoho Sheet

Zoho Books + Zoho Sheet integrations

Create new Zoho Books customers from new or updated rows in Zoho Sheet

Create a seamless connection between your Zoho Sheets and Zoho Books applications with this smart workflow. Every time a new row, or an update to an existing row, occurs in your Zoho Sheets, a customer is instantaneously created in your Zoho Books app. This integration enhances the efficiency of your data management, saving valuable time by eliminating the need for manual data input. Streamline your business processes with this smooth, automated link between Zoho Sheets and Zoho Books.

When this happens...
New or Updated RowTriggers when a new row is added or an existing row is modified in a specified worksheet.
TriggerInstant
automatically do this!
Create CustomerCreates a new customer.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Zoho Sheet and Zoho Books

Discover other triggers and actions you can use with Zoho Sheet and Zoho Books

- Workbook
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Workbook
  Required
Trigger
Instant
Try It
- Workbook
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
Trigger
Instant
Try It
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Instant
Try It

- Workbook
  Required
- Worksheet
  Required
Action
Write
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Operator
  Required
- Lookup Data
  Required
- Additional Lookup Column
- Additional Lookup Operator
- Additional Lookup Data
- First Match Only
Action
Write

- Workbook
  Required
- Worksheet
  Required
- Row Index
  Required
Action
Write
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row Index
  Required
Action
Write
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Operator
  Required
- Lookup Data
  Required
- Additional Lookup Column
- Additional Lookup Operator
- Additional Lookup Data
- First Match Only
Action
Write
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row Index
  Required
Action
Write
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Operator
  Required
- Lookup Data
  Required
- Additional Lookup Column
- Additional Lookup Operator
- Additional Lookup Data
- Search From End
Action
Search
- Organization
  Required
Trigger
Instant
Try It
- Organization
  Required
Trigger
Instant
Try It
- Organization
  Required
Trigger
Instant
Try It
- Organization Name
  Required
- Customer Name
  Required
- Estimate Number
- Date
- Expiry Date
- Name
  Required
- Rate
  Required
- Quantity
  Required
- Discount
- Description
- Exchange Rate
- Estimate Notes
- Send
- Estimate Terms
- Shipping Charge
Action
Write
- Organization
  Required
- Item Name
  Required
- Description
- Rate
- Tax Percentage
- Inventory Tracking Enabled in Organization
Action
Write
- Organization
  Required
- Invoice Number
  Required
Action
Search

New Workbook
Triggers when a new workbook is created.
Trigger
Instant
Try It
- Workbook
  Required
- Worksheet
  Required
- Column
  Required
Trigger
Instant
Try It
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
- Worksheet
  Required
- Column
  Required
Trigger
Instant
Try It
- Workbook
  Required
- Worksheet
  Required
- Row Index
  Required
Action
Write
- Workbook
  Required
- Worksheet Name
Action
Write
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Operator
  Required
- Lookup Data
  Required
- Additional Lookup Column
- Additional Lookup Operator
- Additional Lookup Data
- First Match Only
Action
Write
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
- Worksheet Name
Action
Write
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Operator
  Required
- Lookup Data
  Required
- Additional Lookup Column
- Additional Lookup Operator
- Additional Lookup Data
- First Match Only
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Team
- Team Folder
  Required
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Operator
  Required
- Lookup Data
  Required
- Additional Lookup Column
- Additional Lookup Operator
- Additional Lookup Data
- Search From End
Action
Search
- Organization
  Required
Trigger
Instant
Try It
- Status
- Organization
  Required
Trigger
Instant
Try It
- Organization
  Required
- PAN Number
- GSTIN or UIN
- GST Treatment
- Place of Contact
- Contact Name
  Required
- 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
- Organization
  Required
- Customer Name
  Required
- Invoice Number
- Invoice Date
- Due Date
- Payment Terms
- Discount
- Exchange Rate
- Item Name
  Required
- Description
- Quantity
  Required
- Rate
  Required
- Discount ($)
- Payment Options
- Shipping Charge
- Adjustment
- Allow Partial Payment
- Notes
- Send
- VAT Treatment
- Tax Treatment
- Reference Number
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write

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.

HelpHelp

Related categories

Accounting

Zoho

About Zoho Sheet

Zoho Sheet is a cloud-based spreadsheet software that allows you to create, edit, share and collaborate on spreadsheets in real time.

Learn moreLearn moreHelpHelp

Related categories

Spreadsheets

Zoho

Zoho Books + Zoho Sheet

Zoho Books + Zoho Sheet

Create new Zoho Books customers from new or updated rows in Zoho Sheet

More things you can do with Zoho Sheet and Zoho Books

Related Zap Templates

Related Zap Templates