Integrate Google Sheets with QuickBooks
Send information between Google Sheets and QuickBooks automatically, without writing any code, using Zoho Flow.
Build your own integrations between Google Sheets and QuickBooks
Connect Google Sheets and QuickBooks 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 Google Sheets and QuickBooks using the below triggers and actions
All Triggers - A trigger kickstarts the flow
Worksheet created
Triggers when a new worksheet is created in the selected spreadsheet
Row added - Old version
Triggers when a new row is added to the bottom of the selected worksheet. (Will be deprecated soon)
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
Customer updated
Triggers when any detail of an existing customer is updated
Invoice updated
Triggers when the details of an existing invoice are updated
Estimate updated
Triggers when an estimate is updated
Non-inventory item created
Triggers when a non-inventory item is created
Non-inventory item updated
Triggers when any detail of an existing non-inventory item is updated
Account created
Triggers when a new account is created
Sales receipt created
Triggers when a new sales receipt is created
Credit memo created
Triggers when a credit memo is created
Purchase order created
Triggers when a new purchase order is created
Payment received
Triggers when a payment is received
Account updated
Triggers when an account is updated
Vendor created
Triggers when a new vendor is created
Bill created
Triggers when a bill is created
Inventory item updated
Triggers when any detail of an existing inventory item is updated
Vendor updated
Triggers when the details of an existing vendor are updated
Estimate created
Triggers when a new estimate is created
Sales receipt updated
Triggers when the details of an existing sales receipt are updated
Service item created
Triggers when a new service item is created
Credit memo updated
Triggers when the details of an existing credit memo are updated
Invoice created
Triggers when a new invoice is created
Inventory item created
Triggers when an inventory item is created
Service item updated
Triggers when any detail of an existing service item is updated
Customer created
Triggers when a new customer is created
Deposit added
Triggers when a new deposit is added
All Actions - Actions are the automated tasks
Create row - Old version
Creates a new row in the selected worksheet. (Will be deprecated soon)
Create spreadsheet
Creates a new spreadsheet
Create row - New version
Creates a new row in the selected worksheet
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 - New version
Fetches an existing row by the given value
Fetch row - Old version
Fetches an existing row by the given value. (Will be deprecated soon)
Create deposit
Creates a new deposit
Create service item
Creates a new service item
Create credit memo
Creates a new credit memo
Create non-inventory item
Creates a new non-inventory item
Create estimate
Creates a new estimate
Create inventory item
Creates a new inventory item
Create payment record
Creates a new payment record
Create bill - Item based
Creates a new item-based bill
Create customer
Creates a new customer
Create account
Creates a new account
Create vendor
Creates a new vendor
Create invoice
Creates a new invoice
Create transfer
Creates a new transfer
Create bill - Account based
Creates a new account-based bill
Create sales receipt
Creates a new sales receipt
Update item status
Updates the status of the specified item
Update estimate
Updates the estimate by ID
Update account
Updates the details of an existing account using account ID
Update invoice
Updates the details of an invoice by ID
Update customer
Updates the details of an existing customer
Fetch transfer
Fetches the details of a transfer based on its ID
Fetch payment method
Fetches a payment method based on its name
Fetch customer by ID
Fetches the details of an existing customer by ID
Fetch customer by name or email
Fetches the details of an existing customer by name or email address
Fetch vendor by ID
Fetches the details of an existing vendor by ID
Fetch invoice
Fetches the details of an existing invoice by number
Send sales receipt
Sends an existing sales receipt to the specified email address
Fetch location
Fetches the details of an existing location by name
Fetch deposit
Fetches the details of an existing deposit by its ID
Fetch customer type
Fetches the details of a customer type by its name
Fetch sales term
Fetches the details of a sales term based on its name
Fetch item by SKU
Fetches the details of an existing item using SKU
Fetch account
Fetches an account by name
Send invoice
Sends an invoice to the specified email address
Fetch vendor by name
Fetches the details of an existing vendor by name
Send estimate
Sends an existing estimate
Fetch item
Fetches the details of an existing item by name
Fetch category
Fetches the details of an existing category by name
What is Google Sheets?
Google Sheets lets you create and edit spreadsheets online. You can collaborate with others, define formulas, and create graphs and charts easily.
Similar apps
What is QuickBooks?
Quickbooks is an accounting software package that lets you manage expenses, create invoices, and track inventory.
Similar apps
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 >