Integrate Excel with Zoho Books
Send information between Excel and Zoho Books automatically, without writing any code, using Zoho Flow.
Build your own integrations between Excel and Zoho Books
Connect Excel and Zoho Books with over 750+ apps and build your own integrations using our no-code drag and drop builder and comprehensive workflow elements
Supported triggers and actions
Integrate Excel and Zoho Books using the below triggers and actions
All Triggers - A trigger kickstarts the flow
New worksheet
Triggers when a new worksheet is added to the selected workbook
New row
Triggers when a new row is added at the bottom of the selected worksheet
New row in table
Triggers when a new row is added at the bottom of the selected table
Customer created
Triggers when a new customer is created
Recurring expense created
Triggers when a new recurring expense is created
Customer payment received
Triggers when a new payment is made by a customer
Estimate created
Triggers when a new estimate is created
Recurring expense updated
Triggers when the details of an existing recurring expense are updated
Bill updated
Triggers when an existing bill is updated
Vendor credit created
Triggers when a new vendor credit is created
Custom module entry created
Triggers when a new custom module entry is created
Customer updated
Triggers when the details of a customer are updated
Credit note updated
Triggers when the details of an existing credit note are updated
Item updated
Triggers when an existing item is updated
Invoice updated
Triggers when an existing invoice is updated
Purchase order created
Triggers when a new purchase order is created
Account updated
Triggers when the details of an account in the selected organization are updated
Sales receipt created
Triggers when a new sales receipt is created
Vendor created
Triggers when a new vendor is created
Vendor payment made
Triggers when a vendor payment is made
Estimate updated
Triggers when an existing estimate is updated
Recurring bill created
Triggers when a new recurring bill is created
Item created
Triggers when a new item is created
Recurring invoice updated
Triggers when the details of an existing recurring invoice are updated
Customer payment updated
Triggers when a payment made by a customer is updated
Funds transferred to another account
Triggers when funds are transferred from one account to another
Sales order updated
Triggers when the details of an existing sales order are updated
Recurring bill updated
Triggers when the details of an existing recurring bill is updated
Retainer invoice updated
Triggers when the details of an existing retainer invoice are updated
Sales receipt updated
Triggers when the details of an existing sales receipt is updated
Expense updated
Triggers when an existing expense is updated
Account transaction added
Triggers when a new account transaction is added
Sales order created
Triggers when a sales order is created
Project updated
Triggers when an existing project is updated
Recurring invoice created
Triggers when a new recurring invoice is created
Credit note created
Triggers when a new credit note is created in the selected organization
Invoice created
Triggers when a new invoice is created
Time entry created
Triggers when a new time entry is created
Time entry updated
Triggers when an existing time entry is updated
Purchase order updated
Triggers when the details of an existing purchase order are updated
Vendor updated
Triggers when the details of an existing vendor is updated
Account created
Triggers when an account is created in the selected organization
Expense created
Triggers when a new expense is created
Delivery challan updated
Triggers when the details of an existing delivery challan are updated
Retainer invoice created
Triggers when a retainer invoice is created
Custom module entry updated
Triggers when the details of an existing module entry are updated
Delivery challan created
Triggers when a new delivery challan is created
Vendor credit updated
Triggers when the details of an existing vendor credit are updated
Vendor payment updated
Triggers when the details of an existing vendor payment is updated
Bill created
Triggers when a new bill is created
Project created
Triggers when a new project is created
All Actions - Actions are the automated tasks
Add row to table
Adds a new row to the bottom of the selected table
Add row
Adds a new row to the bottom of the selected worksheet
Update row
Updates the details of an existing row
Find row
Finds a row based on a column value
Create recurring invoice
Creates a new recurring invoice
Add user
Adds a new user
Create time entry
Creates a new time entry
Create invoice
Creates a new invoice
Create inventory adjustment
Creates a new inventory adjustment
Record retainer invoice payment
Records payment for an existing retainer invoice
Add comment to bill
Adds a comment to the specified bill
Send retainer invoice
Sends an existing retainer invoice by email
Assign user to project
Assigns the specified user to an existing project
Record vendor payment
Records a payment for an existing vendor invoice
Add comment to purchase order
Adds a comment to the specified purchase order
Enable portal access
Enables portal access for the specified customer or vendor
Create sales order
Creates a new sales order
Create delivery challan
Creates a new delivery challan
Send sales order
Sends an existing sales order by email
Create recurring bill
Creates a new recurring bill
Request payment information
Requests payment information from the specified contact
Create journal
Creates a new journal
Create account
Creates a new account in the selected organization
Create item
Creates a new item
Add comment to retainer invoice
Adds a comment to the specified retainer invoice
Add comment to invoice
Adds a comment to the specified invoice
Record customer payment
Records a payment for an existing customer invoice
Create project
Creates a new project
Send estimate
Sends an existing estimate to the specified recipients
Add address
Adds an address to a customer or vendor contact
Create sales receipt
Creates a new sales receipt
Send purchase order
Sends an existing purchase order by email
Create vendor credit
Creates a new vendor credit
Create bill
Creates a new bill
Add comment to credit note
Adds a comment to the specified credit note
Create task
Creates a new task
Create custom module entry
Creates a new custom module entry
Add comment to vendor
Adds a comment to the specified vendor
Mark as primary contact person
Marks the specified contact as the primary contact of the company
Create vendor
Creates a new vendor
Create retainer invoice
Creates a new retainer invoice
Create contact person
Creates a new contact person
Create payment link
Creates a new payment link
Refund customer payment
Refunds the specified payment
Create customer
Creates a new customer
Send invoice
Sends an existing invoice by email
Add comment to customer
Adds a comment to the specified customer
Create estimate
Creates a new estimate
Add comment to sales order
Adds a comment to the specified sales order
Create recurring expense
Creates a new recurring expense
Refund credit note
Refunds credit note by ID
Add comment to vendor credit
Adds a comment to the specified vendor credit
Add comment to project
Adds a comment to the specified project
Invite user to project
Invites a new user to the selected project
Create purchase order
Creates a new purchase order
Create public share link
Creates a public share link for the selected module
Create currency adjustment
Creates a currency adjustment for all open transactions on the specified date
Create expense
Creates a new expense
Create bank transaction
Creates a new bank transaction
Add comment to estimate
Adds a comment to the specified estimate
Create sales person
Creates a new sales person
Create credit note
Creates a new credit note
Send credit note
Sends the specified credit note to a recipient
Update time entry
Updates an existing time entry
Update sales order
Updates the details of an existing sales order
Stop or resume recurring expense
Stops or resumes an existing recurring expense
Update delivery challan
Updates the details of an existing delivery challan
Update custom module entry
Updates the details of a existing custom module entry
Update contact person
Updates the details of an existing contact person
Reject credit note
Rejects an existing credit note
Submit or approve credit note
Submits or approves an existing credit note
Reject sales order
Rejects an existing sales order
Update retainer invoice
Updates the details of an existing retainer invoice
Reject invoice
Rejects an existing invoice
Update recurring expense
Updates the details of an existing recurring expense
Update project status
Updates the status of an existing project
Update journal
Updates the details of an existing journal
Update payment link
Updates the details of an existing payment link
Update task
Updates the details of an existing task
Unlock transaction
Unlocks the locked transactions to allow for modification or deletion
Submit or approve sales order
Submits or approves an existing sales order
Update account
Updates the details of an account in the selected organization
Update purchase order status
Updates the status of an existing purchase order
Update contact status
Updates the status of an existing customer or vendor
Update vendor
Updates the details of an existing vendor
Apply retainer invoice to invoice
Adds a retainer invoice to the specified invoice
Update vendor credit status
Updates the details of an existing credit status
Update sales order status
Updates the status of an existing sales order
Apply credit to invoice
Adds a credit note to the specified invoice
Reject vendor credit
Rejects an existing vendor credit
Submit or approve estimate
Submits or approves an existing estimate
Submit or approve invoice
Submits or approves an existing invoice
Update estimate
Updates the details of an existing estimate
Update credit note
Updates the details of an existing credit note
Update credit note status
Updates the status of an existing credit note
Lock transactions
Prevents transaction details prior to the selected date from being modified or deleted
Update retainer invoice status
Updates the details of an existing retainer invoice
Update user status
Updates the status of an existing user
Reject estimate
Rejects an existing estimate
Update purchase order
Updates the details of an existing purchase order
Submit or approve retainer invoice
Submits or approves an existing retainer invoice
Stop or resume recurring invoice
Stops or resumes an existing recurring invoice
Update vendor credit
Updates the details of an existing vendor credit
Update expense
Updates the details of an existing expense
Update customer
Updates the details of an existing customer
Reject retainer invoice
Rejects an existing retainer invoice
Reject bill
Rejects an existing bill
Update bill status
Updates the status of an existing bill
Update item
Updates the details of an existing item
Reject purchase order
Rejects an existing purchase order
Update invoice status
Updates the status of an existing invoice
Submit or approve bill
Submits or approves an existing bill
Update bill
Updates the details of an existing bill
Submit or approve vendor credit
Submits or approves an existing vendor credit
Update estimate status
Updates the status of an existing estimate
Submit or approve purchase order
Submits or approves an existing purchase order
Link customer to vendor
Links the customer to an existing vendor
Update recurring invoice
Updates the details of an existing recurring invoice
Update project
Updates the details of an existing project
Update recurring bill
Updates the details of an existing recurring bill
Update invoice
Updates the details of an existing invoice
Update address
Updates the details of an existing customer or vendor address
Update user
Updates the details of an existing user
Stop or resume recurring bill
Stops or resumes an existing recurring bill
Fetch recurring bill
Fetches the details of an existing recurring bill
Fetch delivery challan
Fetches the details of an existing delivery challan
Fetch vendor credit
Fetches the details of an existing vendor credit
Fetch recurring expense
Fetches the details of an existing recurring expense by profile name
Fetch account
Fetches the details of an existing account by its ID
Fetch customer payment
Fetches the details of an existing customer payment
Fetch sales order
Fetches the details of an existing sales order by number
Fetch item
Fetches the details of an existing item by its ID, number or name.
Fetch estimate
Fetches the details of an existing estimate by its number
Fetch sales receipt
Fetches the details of an existing sales receipt by number
Fetch bank account
Fetches the details of an existing bank account
Fetch invoice
Fetches the details of an existing invoice
Fetch retainer invoice
Fetches the details of an existing retainer invoice by number
Convert sales order to invoice
Converts an existing sales order to an invoice
Fetch vendor
Fetches the details of an existing vendor
Fetch user
Fetches the details of an existing user by email address
Fetch payment link
Fetches the details of an existing payment link
Fetch purchase order
Fetches the details of an existing purchase order by its number
Fetch recurring invoice
Fetches the details of an existing recurring invoice by profile name
Fetch project
Fetches the details of an existing project by name
Fetch inventory adjustment
Fetches the details of an existing inventory adjustment
Fetch custom module entry
Fetches the details of an existing custom module entry
Fetch expense
Fetches an existing expense by ID or reference number. If the expense does not exist, you can choose to create a new one.
Fetch journal
Fetches the details of an existing journal
Fetch customer
Fetches the details of an existing customer
Fetch credit note
Fetches the details of an existing credit note by number
Fetch vendor payment
Fetches the details of an existing vendor payment
Fetch bill
Fetches the details of an existing bill
What is Excel?
Excel is spreadsheet software that lets you create sheets from templates, collaborate on projects, and view trends with charts or graphs.
Similar apps
What is Zoho Books?
Zoho Books is online accounting software to manage your accounting, inventory and to file your GST returns. You can manage your contacts, set up rules to categorize banking transactions, make informed decisions based on accurate reports, and keep track of every expense.
Build comprehensive workflows using
Webhook triggers
Receive your data from a wider range of services in multiple formats, like JSON, form data, and plain text.
Learn more >
Logic
Create customized business workflows by including advanced logic elements like if-then branches, time delays, and more.
Learn more >
Custom functions
Write simple scripting functions to format data, call web APIs, send emails, and more.
Learn more >First and the foremost benefit is that Zoho Flow connects the apps that cannot be connected in other ways. With the proper flows, we have all the processes standardized, and the interactions between the different roles in the company are standardized, too. Learn more
Louis Castellano
CEO, Lakeside CNC Group
We chose Zoho Flow for its ability to connect various apps in a simple way. It helped us provide our clients with an automated billing process that saves them over 50 hours of manual work per year. The platform is intuitive and easy to use even for non-developers like me.
Julien Granjean
CEO, iDAYit
Zoho Flow has automated our entire "Security Operations" process, saving us a lot of manual work and admin overhead, in turn enabling us to focus our efforts on providing clients with accurate and quality services.
Neville Mader
Director, Perth Security Services
