Zoho Books + Zoho Sheet

Zoho Books + Zoho Sheet integrations

Create rows in Zoho Sheet for new items in Zoho Books

Streamline your record-keeping with this efficient Zoho Books to Zoho Sheets workflow. When a new item is added in Zoho Books, a row is immediately created on Zoho Sheets, allowing easy and up-to-date record management. This workflow ensures consistency between your accounting and spreadsheet data, saving you from manual transfer and potential inaccuracies.

When this happens...
New ItemTriggers when a new item is created.
TriggerInstant
automatically do this!
Create RowTriggers when a new row is created in a specified worksheet.
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 Books and Zoho Sheet

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

- 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
- 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

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 rows in Zoho Sheet for new items in Zoho Books

More things you can do with Zoho Books and Zoho Sheet

Related Zap Templates

Related Zap Templates