Use Zoho Flow to integrate Zoho Books with Google Sheets, in atleast 902 different ways, without writing code. Automate any tasks that keep you away from what you do best.
Explore prebuilt integration flows to get started


Add updated purchase orders in Zoho Books to a Google Sheets spreadsheet
Use this flowDidn't find the integration you are looking for? Create one yourself.
All Triggers - A trigger kickstarts the flow
Account created
Triggers when an account is created in the selected organization
Bill updated
Triggers when an existing bill is updated
Expense created
Triggers when a new expense is created
Vendor payment updated
Triggers when the details of an existing vendor payment is updated
Credit note updated
Triggers when the details of an existing credit note are updated
Delivery challan created
Triggers when a new delivery challan is created
Purchase order created
Triggers when a new purchase order is created
Time entry updated
Triggers when an existing time entry is updated
Account updated
Triggers when the details of an account in the selected organization are updated
Retainer invoice created
Triggers when a retainer invoice is created
Project created
Triggers when a new project is created
Time entry created
Triggers when a new time entry is created
Custom module entry updated
Triggers when the details of an existing module entry are updated
Recurring invoice created
Triggers when a new recurring invoice is created
Project updated
Triggers when an existing project is updated
Vendor payment made
Triggers when a vendor payment is made
Estimate updated
Triggers when an existing estimate is updated
Vendor updated
Triggers when the details of an existing vendor is updated
Purchase order updated
Triggers when the details of an existing purchase order are updated
Vendor credit created
Triggers when a new vendor credit is created
Credit note created
Triggers when a new credit note is created in the selected organization
Sales order updated
Triggers when the details of an existing sales order are updated
Bill created
Triggers when a new bill is created
Account transaction added
Triggers when a new account transaction is added
Recurring invoice updated
Triggers when the details of an existing recurring invoice are updated
Customer updated
Triggers when the details of a customer are updated
Item created
Triggers when a new item is created
Invoice updated
Triggers when an existing invoice is updated
Retainer invoice updated
Triggers when the details of an existing retainer invoice are updated
Customer payment received
Triggers when a new payment is made by a customer
Item updated
Triggers when an existing item is updated
Delivery challan updated
Triggers when the details of an existing delivery challan are updated
Vendor credit updated
Triggers when the details of an existing vendor credit are updated
Expense updated
Triggers when an existing expense is updated
Recurring expense created
Triggers when a new recurring expense is created
Customer created
Triggers when a new customer is created
Recurring bill updated
Triggers when the details of an existing recurring bill is updated
Custom module entry created
Triggers when a new custom module entry is created
Recurring bill created
Triggers when a new recurring bill is created
Recurring expense updated
Triggers when the details of an existing recurring expense are updated
Vendor created
Triggers when a new vendor is created
Estimate created
Triggers when a new estimate is created
Funds transferred to another account
Triggers when funds are transferred from one account to another
Invoice created
Triggers when a new invoice is created
Customer payment updated
Triggers when a payment made by a customer is updated
Sales order created
Triggers when a sales order is created
Row added - Old version
Triggers when a new row is added to the bottom of the selected worksheet. (Will be deprecated soon)
Worksheet created
Triggers when a new worksheet is created in the selected spreadsheet
Row added - New version
Triggers when a new row is added to the bottom of the selected worksheet
Spreadsheet created
Triggers when a new spreadsheet is created
All Actions - Action are the automated tasks
Add comment to bill
Adds a comment to the specified bill
Create vendor
Creates a new vendor
Add comment to purchase order
Adds a comment to the specified purchase order
Mark as primary contact person
Marks the specified contact as the primary contact of the company
Create purchase order
Creates a new purchase order
Create item
Creates a new item
Create recurring bill
Creates a new recurring bill
Create account
Creates a new account in the selected organization
Create task
Creates a new task
Create journal
Creates a new journal
Send sales order
Sends an existing sales order by email
Create sales person
Creates a new sales person
Create sales order
Creates a new sales order
Assign user to project
Assigns the specified user to an existing project
Add comment to estimate
Adds a comment to the specified estimate
Create vendor credit
Creates a new vendor credit
Send estimate
Sends an existing estimate to the specified recipients
Send purchase order
Sends an existing purchase order by email
Create delivery challan
Creates a new delivery challan
Create custom module entry
Creates a new custom module entry
Send retainer invoice
Sends an existing retainer invoice by email
Send credit note
Sends the specified credit note to a recipient
Add comment to project
Adds a comment to the specified project
Create contact person
Creates a new contact person
Record customer payment
Records a payment for an existing customer invoice
Request payment information
Requests payment information from the specified contact
Add comment to invoice
Adds a comment to the specified invoice
Create retainer invoice
Creates a new retainer invoice
Add comment to customer
Adds a comment to the specified customer
Create bill
Creates a new bill
Invite user to project
Invites a new user to the selected project
Create customer
Creates a new customer
Create recurring expense
Creates a new recurring expense
Record retainer invoice payment
Records payment for an existing retainer invoice
Create time entry
Creates a new time entry
Create currency adjustment
Creates a currency adjustment for all open transactions on the specified date
Refund customer payment
Refunds the specified payment
Create public share link
Creates a public share link for the selected module
Add comment to vendor
Adds a comment to the specified vendor
Add address
Adds an address to a customer or vendor contact
Record vendor payment
Records a payment for an existing vendor invoice
Create expense
Creates a new expense
Create credit note
Creates a new credit note
Add comment to sales order
Adds a comment to the specified sales order
Create estimate
Creates a new estimate
Send invoice
Sends an existing invoice by email
Enable portal access
Enables portal access for the specified customer or vendor
Create payment link
Creates a new payment link
Create bank transaction
Creates a new bank transaction
Create recurring invoice
Creates a new recurring invoice
Create inventory adjustment
Creates a new inventory adjustment
Add comment to retainer invoice
Adds a comment to the specified retainer invoice
Add comment to vendor credit
Adds a comment to the specified vendor credit
Create project
Creates a new project
Create invoice
Creates a new invoice
Refund credit note
Refunds credit note by ID
Add user
Adds a new user
Add comment to credit note
Adds a comment to the specified credit note
Submit or approve sales order
Submits or approves an existing sales order
Update vendor credit
Updates the details of an existing vendor credit
Update address
Updates the details of an existing customer or vendor address
Update vendor
Updates the details of an existing vendor
Reject purchase order
Rejects an existing purchase order
Update sales order
Updates the details of an existing sales order
Submit or approve estimate
Submits or approves an existing estimate
Update time entry
Updates an existing time entry
Update user
Updates the details of an existing user
Submit or approve vendor credit
Submits or approves an existing vendor credit
Update journal
Updates the details of an existing journal
Update invoice status
Updates the status of an existing invoice
Reject estimate
Rejects an existing estimate
Submit or approve credit note
Submits or approves an existing credit note
Update payment link
Updates the details of an existing payment link
Update custom module entry
Updates the details of a existing custom module entry
Update bill status
Updates the status of an existing bill
Submit or approve purchase order
Submits or approves an existing purchase order
Reject retainer invoice
Rejects an existing retainer invoice
Reject vendor credit
Rejects an existing vendor credit
Lock transactions
Prevents transaction details prior to the selected date from being modified or deleted
Stop or resume recurring expense
Stops or resumes an existing recurring expense
Update purchase order status
Updates the status of an existing purchase order
Update item
Updates the details of an existing item
Update contact status
Updates the status of an existing customer or vendor
Update estimate status
Updates the status of an existing estimate
Apply retainer invoice to invoice
Adds a retainer invoice to the specified invoice
Update estimate
Updates the details of an existing estimate
Update vendor credit status
Updates the details of an existing credit status
Reject invoice
Rejects an existing invoice
Update user status
Updates the status of an existing user
Submit or approve retainer invoice
Submits or approves an existing retainer invoice
Update credit note status
Updates the status of an existing credit note
Submit or approve bill
Submits or approves an existing bill
Update sales order status
Updates the status of an existing sales order
Update invoice
Updates the details of an existing invoice
Update customer
Updates the details of an existing customer
Update expense
Updates the details of an existing expense
Update task
Updates the details of an existing task
Reject sales order
Rejects an existing sales order
Update purchase order
Updates the details of an existing purchase order
Update recurring invoice
Updates the details of an existing recurring invoice
Stop or resume recurring bill
Stops or resumes an existing recurring bill
Update credit note
Updates the details of an existing credit note
Stop or resume recurring invoice
Stops or resumes an existing recurring invoice
Update retainer invoice
Updates the details of an existing retainer invoice
Update bill
Updates the details of an existing bill
Update retainer invoice status
Updates the details of an existing retainer invoice
Reject credit note
Rejects an existing credit note
Update account
Updates the details of an account in the selected organization
Submit or approve invoice
Submits or approves an existing invoice
Reject bill
Rejects an existing bill
Update project status
Updates the status of an existing project
Unlock transaction
Unlocks the locked transactions to allow for modification or deletion
Apply credit to invoice
Adds a credit note to the specified invoice
Update contact person
Updates the details of an existing contact person
Update recurring bill
Updates the details of an existing recurring bill
Update delivery challan
Updates the details of an existing delivery challan
Update recurring expense
Updates the details of an existing recurring expense
Update project
Updates the details of an existing project
Fetch purchase order
Fetches the details of an existing purchase order by its number
Fetch invoice
Fetches the details of an existing invoice
Fetch vendor payment
Fetches the details of an existing vendor payment
Fetch sales order
Fetches the details of an existing sales order by number
Fetch payment link
Fetches the details of an existing payment link
Fetch estimate
Fetches the details of an existing estimate by its number
Fetch journal
Fetches the details of an existing journal
Fetch inventory adjustment
Fetches the details of an existing inventory adjustment
Fetch retainer invoice
Fetches the details of an existing retainer invoice by number
Fetch recurring expense
Fetches the details of an existing recurring expense by profile name
Convert sales order to invoice
Converts an existing sales order to an invoice
Fetch customer payment
Fetches the details of an existing customer payment
Fetch custom module entry
Fetches the details of an existing custom module entry
Fetch vendor credit
Fetches the details of an existing vendor credit
Fetch recurring invoice
Fetches the details of an existing recurring invoice by profile name
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 recurring bill
Fetches the details of an existing recurring bill
Fetch delivery challan
Fetches the details of an existing delivery challan
Fetch account
Fetches the details of an existing account by its ID
Fetch bank account
Fetches the details of an existing bank account
Fetch customer
Fetches the details of an existing customer
Fetch user
Fetches the details of an existing user by email address
Fetch vendor
Fetches the details of an existing vendor
Fetch bill
Fetches the details of an existing bill
Fetch project
Fetches the details of an existing project by name
Fetch item
Fetches the details of an existing item by its ID, number or name.
Fetch credit note
Fetches the details of an existing credit note by number
Create row - New version
Creates a new row in the selected worksheet
Create row - Old version
Creates a new row in the selected worksheet. (Will be deprecated soon)
Create spreadsheet
Creates a new spreadsheet
Update row - Old version
Updates the specified row in the selected worksheet. (Will be deprecated soon)
Update row - New version
Updates the specified row in the selected worksheet
Fetch row - Old version
Fetches an existing row by the given value. (Will be deprecated soon)
Fetch row - New version
Fetches an existing row by the given value
What is Zoho Flow?
Zoho Flow is an integration platform that helps you connect your apps without any code. Automate complex business workflows within minutes. Set a trigger, add actions, use Delays and Decisions to create your entire workflow on an easy to use builder.
Start your 15 day free trial
Testimonial

“Zoho Flow was the main reason we decided in favor of the Zoho platform. An ability to integrate the different parts of the platform is priceless, and we were able to set as many process triggers as we need. Currently, we have eight large flows. They integrate Zoho Books, Zoho Desk, Zoho CRM, and Zoho Cliq in various combinations.” Know more
Watch Zoho Flow in action
