Do everything in one place
Customize your Google Sheets and QuickBooks Online integration with the following
triggers and actions.
Triggers
When this happens…
Google Sheets
- New row in sheet in My DriveNew row in a sheet in Google Sheets
- New row in sheet in My Drive Real-timeNew row in a sheet in Google Sheets
- New row in sheet in Team DriveNew row in a sheet in Google Sheets
- New/updated row in sheet in Team DriveNew/updated row in a sheet in Google Sheets
- New/updated row in sheet in My DriveNew/updated row in a sheet in Google Sheets
- New/updated row in sheet in My Drive Real-timeNew/updated row in a sheet in Google Sheets
Any other trigger you can think up
QuickBooks Online
- Deleted billDeleted bill in QuickBooks
- Deleted itemDeleted item in QuickBooks
- New accountNew account in QuickBooks
- New bank depositNew deposit in QuickBooks
- New billNew bill in QuickBooks
- New bill paymentNew bill payment in QuickBooks
- New credit notesNew credit memo in QuickBooks
- New customerNew customer in QuickBooks
- New employeeNew employee in QuickBooks
- New estimateNew estimate in QuickBooks
- New invoiceNew invoice in QuickBooks
- New itemNew item in QuickBooks
- New paymentNew payment in QuickBooks
- New purchaseNew purchase in QuickBooks
- New sales receiptNew sales receipt in QuickBooks
- New/updated accountNew or updated account in QuickBooks
- New/updated billNew or updated bill in QuickBooks
- New/updated tax codeNew or updated tax code in QuickBooks
- New/updated tax rateNew or updated tax rate in QuickBooks
- New vendorNew vendor in QuickBooks
- Updated billUpdated bill in QuickBooks
- Updated credit notesUpdated credit memo in QuickBooks
- Updated customerUpdated customer in QuickBooks
- Updated employeeUpdated employee in QuickBooks
- Updated estimateUpdated estimate in QuickBooks
- Updated invoiceUpdated invoice in QuickBooks
- Updated itemUpdated item in QuickBooks
- Updated purchaseUpdated purchase in QuickBooks
- Updated vendorUpdated vendor in QuickBooks
Any other trigger you can think up
Actions
Do this…
Google Sheets
- Custom actionCustom action in Google Sheets (Custom)
- Add rows in bulk BatchAdd multiple rows in a sheet in Google Sheets
- Add rowAdd a new row in a sheet in Google Sheets
- Get rows BatchGet rows from sheet in Google Sheets
- Search rows BatchSearch rows in a sheet in Google Sheets
- Update rows in bulk BatchUpdate multiple rows in a sheet in Google Sheets
- Update rowUpdate a row in a sheet in Google Sheets
- Update row using row ID (Deprecated)Update a row using row ID in a sheet in Google Sheets
Any other action you can think up
QuickBooks Online
- Custom actionCustom action in QuickBooks Online (Custom)
- Add line to credit memoAdd line item to credit memo in QuickBooks
- Add line to estimateAdd line item to estimate in QuickBooks
- Add line to invoiceAdd line item to invoice in QuickBooks
- Add line to sales receiptAdd line item to sales receipt in QuickBooks
- Create G/L accountCreate G/L account in QuickBooks
- Create bill paymentCreate bill payment with a multi linked transaction in QuickBooks
- Create billCreate bill with a multi line item in QuickBooks
- Create check / chequeCreate check / cheque with a multi line item in QuickBooks
- Create classCreate class in QuickBooks
- Create credit card creditCreate credit card credit with a multi line item in QuickBooks
- Create credit memoCreate credit memo with a multi line item in QuickBooks
- Create customerCreate customer in QuickBooks
- Create bank depositCreate bank deposit with a multi linked transaction in QuickBooks
- Create employeeCreate employee in QuickBooks
- Create estimateCreate estimate with a multi line item in QuickBooks
- Create expenseCreate expense with a multi line item in QuickBooks
- Create invoiceCreate invoice with a multi line item in QuickBooks
- Create item (product or service)Create item in QuickBooks
- Create journal entryCreate journal entry in QuickBooks
- Create journal entry with line itemsCreate journal entry with line items in QuickBooks
- Create paymentCreate payment with a multi linked transaction in QuickBooks
- Create purchase orderCreate purchase order with a multi line item in QuickBooks
- Create refund receiptCreate refund receipt with a multi line item in QuickBooks
- Create sales receiptCreate sales receipt with a multi line item in QuickBooks
- Create timesheet with 1 line itemCreate timesheet with a single line item in QuickBooks
- Create transferCreate transfer with a multi linked transaction in QuickBooks
- Create vendorCreate vendor in QuickBooks
- Create vendor / supplier creditCreate vendor / supplier credit with a multi line item in QuickBooks
- Get attachments BatchGet attachments from QuickBooks
- Get customer sales reportsGet customer sales reports from QuickBooks
- Get estimate detailsGet estimate details in QuickBooks
- Get exchange rateGet exchange rate details from QuickBooks
- Get invoice detailsGet invoice details from QuickBooks
- Get item (product or service) detailsGet item in QuickBooks
- Get profit and lossGet profit and loss in QuickBooks
- Get sales receipt detailsGet sales receipt details by ID from QuickBooks
- Get timesheet detailsGet timesheet details in QuickBooks
- Search G/L accounts BatchSearch G/L accounts in QuickBooks
- Get customer detailsGet customer details by ID in QuickBooks
- Search employees BatchSearch employees in QuickBooks
- Get employee detailsGet employee details in QuickBooks
- Get payment method detailsGet payment method details in QuickBooks
- Get sales term detailsGet sales term details in QuickBooks
- Get vendor detailsGet vendor details in QuickBooks
- Search vendor bills BatchSearch vendor bills in QuickBooks
- Search budgets BatchSearch budgets in QuickBooks
- Search checks BatchSearch checks in QuickBooks
- Search classes BatchSearch classes in QuickBooks
- Search customers BatchSearch customers in QuickBooks
- Search departments BatchSearch departments in QuickBooks
- Search bank deposits BatchSearch bank deposits in QuickBooks
- Search estimates BatchSearch estimates in QuickBooks
- Search invoices BatchSearch invoices in QuickBooks
- Search items (products or services) BatchSearch items in QuickBooks
- Search journal entries BatchSearch journal entries in QuickBooks
- Search payment methods BatchSearch payment methods in QuickBooks
- Search purchases BatchSearch purchases in QuickBooks
- Search sales receipts BatchSearch sales receipts in QuickBooks
- Search tax codes BatchSearch tax codes in QuickBooks
- Search terms BatchSearch terms in QuickBooks
- Search timesheets BatchSearch timesheets in QuickBooks
- Search vendors BatchSearch vendors in QuickBooks
- Send invoice via emailSend invoice through email in QuickBooks
- Update a bill paymentUpdate bill payment with a multi linked transaction in QuickBooks
- Update billUpdate bill with a multi line item in QuickBooks
- Update check / chequeUpdate check / cheque with a multi line item in QuickBooks
- Update credit card creditUpdate credit card credit with a multi line item in QuickBooks
- Update credit memoUpdate credit memo with a multi line item in QuickBooks
- Update customerUpdate a customer in QuickBooks
- Update a bank depositUpdate bank deposit with a multi linked transaction in QuickBooks
- Update employeeUpdate employee in QuickBooks
- Update estimateUpdate estimate with a multi line item in QuickBooks
- Update expenseUpdate expense with a multi line item in QuickBooks
- Update invoiceUpdate invoice with a multi line item in QuickBooks
- Update item (product or service)Update item in QuickBooks
- Update a paymentUpdate payment with a multi linked transaction in QuickBooks
- Update purchase orderUpdate purchase order with a multi line item in QuickBooks
- Update refund receiptUpdate refund receipt with a multi line item in QuickBooks
- Update sales receiptUpdate sales receipt with a multi line item in QuickBooks
- Update timesheetUpdate timesheet in QuickBooks
- Update a transferUpdate transfer with a multi linked transaction in QuickBooks
- Update vendorUpdate vendor in QuickBooks
- Update vendor / supplier creditUpdate vendor / supplier credit with a multi line item in QuickBooks
Any other action you can think up
The wonders of Workato
Easily set up as many intelligent automations you need.
- 1000s of ready-to-use templates
- Accelerate work with intelligent automation
- Do it yourself, faster
- Build bots. Put them to work