How to connect Google Sheets + QuickBooks Online
Zapier lets you send info between Google Sheets and QuickBooks Online automatically—no code required.
Popular Google Sheets + QuickBooks Online workflows
Add new QuickBooks Online invoices to Google Sheets spreadsheet rows
Add new QuickBooks Online invoices to Google Sheets spreadsheet rowsPremiumCreate Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets
Create Sales Receipts and customers in QuickBooks Online for updated rows in Google SheetsPremiumCreate Google Sheet rows for new payments in QuickBooks Online
Create Google Sheet rows for new payments in QuickBooks OnlinePremiumCreate Google Sheet rows for new QuickBooks Online expenses
Create Google Sheet rows for new QuickBooks Online expensesPremiumCreate Google Sheet rows for new QuickBooks Online customers
Create Google Sheet rows for new QuickBooks Online customersPremiumCreate Google Sheets spreadsheet rows from new QuickBooks Online invoices
Create Google Sheets spreadsheet rows from new QuickBooks Online invoicesPremium
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.


Do Even More with Google Sheets + QuickBooks Online
With Zapier, you can do more than just connect 2 apps—you can automate entire processes from beginning to end! Here are some popular ways users make their Google Sheets + QuickBooks Online workflows do more for them.
Zapier users love adding Filter by Zapier to their workflows
Create Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets
Create Sales Receipts and customers in QuickBooks Online for updated rows in Google SheetsPremium
- New Spreadsheet Row (Team Drive)Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.Trigger
- New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.Trigger
- New SpreadsheetTriggered when you create a new spreadsheet.Trigger
- New or Updated Spreadsheet Row (Team Drive)Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.Trigger
- New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.Trigger
- New WorksheetTriggered when you create a new worksheet in a spreadsheet.Trigger
- Create Spreadsheet ColumnCreate a new column in a specific spreadsheet.Action
- Create Spreadsheet RowCreate a new row in a specific spreadsheet.Action
- Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
- Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
- Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
- Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
- Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
- Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
- Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action
- QuickBooks Online
Triggered when you add a new account.
Scheduled
Trigger
- QuickBooks Online
Triggers when a new bill is added.
Scheduled
Trigger
- QuickBooks Online
Triggered when you add a new customer.
Scheduled
Trigger
- QuickBooks Online
Triggered when you add a new estimate.
Scheduled
Trigger
- QuickBooks Online
Triggers when a new expense is added.
Scheduled
Trigger
- QuickBooks Online
Triggered when you add a new invoice.
Scheduled
Trigger
- QuickBooks Online
Triggered when you add a new invoice (with line item support).
Scheduled
Trigger
- QuickBooks Online
Triggered when a new sales receipt is added (with line item support).
Scheduled
Trigger
- QuickBooks Online
Triggered when a payment is received (with line item support).
Scheduled
Trigger
- QuickBooks Online
Triggers when a new purchase order is added.
Scheduled
Trigger
- QuickBooks Online
Triggered when a new sales receipt is added.
Scheduled
Trigger
- QuickBooks Online
Triggered when an existing customer is updated.
Scheduled
Trigger
- QuickBooks Online
Triggered when a new vendor is added.
Scheduled
Trigger
- QuickBooks Online
Create a new bill, optionally tied to a customer.
Scheduled
Action
- QuickBooks Online
Create a new bill, optionally tied to a customer (with line item support).
Scheduled
Action
- QuickBooks Online
Create a new bill, optionally tied to a customer (with line item support).
Scheduled
Action
- QuickBooks Online
Creates a new credit memo.
Scheduled
Action
- QuickBooks Online
Adds a new customer.
Scheduled
Action
- QuickBooks Online
Create a new estimate (with line item support).
Scheduled
Action
- QuickBooks Online
Creates a new expense using check, cash, or credit card.
Scheduled
Action
- QuickBooks Online
Creates a new product or service.
Scheduled
Action
- QuickBooks Online
Creates a new journal entry.
Scheduled
Action
- QuickBooks Online
Adds a new invoice (with line item support).
Scheduled
Action
- QuickBooks Online
Adds a new sales receipt (with line item support).
Scheduled
Action
- QuickBooks Online
Creates a new payment, optionally linked to an invoice.
Scheduled
Action
- QuickBooks Online
Creates a new purchase order.
Scheduled
Action
- QuickBooks Online
Creates a new refund receipt.
Scheduled
Action
- QuickBooks Online
Send an existing invoice.
Scheduled
Action
- QuickBooks Online
Send an existing sales receipt.
Scheduled
Action
- QuickBooks Online
Creates a new single time activity.
Scheduled
Action
- QuickBooks Online
Updates an existing customer.
Scheduled
Action
- QuickBooks Online
Updates an existing invoice (with line item support).
Scheduled
Action
- QuickBooks Online
Adds a new vendor.
Scheduled
Action
- QuickBooks Online
Find an account by name.
Scheduled
Action
- QuickBooks Online
Find a customer by name or email address.
Scheduled
Action
- QuickBooks Online
Find an invoice by number.
Scheduled
Action
- QuickBooks Online
Find a product by name (with line item support)
Scheduled
Action
- QuickBooks Online
Find a vendor by name.
Scheduled
Action
- QuickBooks Online
Finds or creates a specific customer v2.
Scheduled
Action
- QuickBooks Online
Finds or creates a specific vendor.
Scheduled
Action
How Google Sheets + QuickBooks Online Integrations Work
- Step 1: Authenticate Google Sheets and QuickBooks Online.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Google Sheets Tutorials
Related categories
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.