Microsoft Excel + Zoho Books

Create sales invoices in Zoho Books from new rows in Microsoft Excel

Keep your sales processes seamless and efficient with this workflow. Whenever you add a new row in your Microsoft Excel, it prompts the creation of a sales invoice in your Zoho Books. This automation removes the burden of manual data entry, ensuring your invoices are always up-to-date with your latest Excel data. Save time, reduce errors, and enhance your bookkeeping with this streamlined process.

When this happens...
New Row
Triggers when a new row is added to a worksheet in a spreadsheet.
TriggerScheduled
automatically do this!
Create Sales Invoice
Creates a new sales invoice.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

What does this mean?

- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

- 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
- Item NameRequired
- Description
- Rate
- Tax Percentage
Action
Write
- OrganizationRequired
- Invoice NumberRequired
Action
Search

- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or 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
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Help

Related categories

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

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.

Help

PRODUCTS

CAPABILITIES

By team

Microsoft Excel + Zoho Books

Create sales invoices in Zoho Books from new rows in Microsoft Excel

New Row

Storage Source

SpreadsheetRequired

WorksheetRequired

New Worksheet

Storage Source

Folder

SpreadsheetRequired

Add Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

Storage Source

Folder

TitleRequired

Column Headers

Zap Step Id

Find Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

New Customer

OrganizationRequired

New Expense

OrganizationRequired

New Item

OrganizationRequired

Create Estimate

Organization NameRequired

Customer NameRequired

Estimate Number

Date

Expiry Date

NameRequired

RateRequired

QuantityRequired

Discount

Description

Exchange Rate

Estimate Notes

Send

Estimate Terms

Shipping Charge

Create Item

OrganizationRequired

Item NameRequired

Description

Rate

Tax Percentage

Find Invoice

OrganizationRequired

Invoice NumberRequired

New Row in Table

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

TableRequired

Updated Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Trigger Column

Add Row to Table

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

TableRequired