Google Sheets
When this happens...
QuickBooks OnlineNew Invoice
Then do this...
Google SheetsCreate Spreadsheet Row

If you use Google Sheets to track or report on your invoicing you can use Zapier to automatically start adding new QuickBooks Online invoices to a Google Sheets spreadsheet. In setting up this Quickbooks Online Google Sheets integration, once you have selected your worksheet you will be able to send QuickBooks Online invoice data to specific columns in your spreadsheet.

Note: This Zapier integration doesn't import existing QuickBooks Online invoices into Google Sheets, only new invoices after you've set it up.

How It Works

  1. A new QuickBooks Online invoice is created.
  2. Zapier adds that invoice to Google Sheets as a new row in a spreadsheet.

What You Need

  • QuickBooks Online account
  • Google Sheets account

Why Zapier?


Get started for free—14 day trial of premium features and apps.


No coding required—automate any of 1,500+ apps in minutes.


Enterprise-level security—connect mission-critical apps.

It's easy to connect Google Sheets + QuickBooks Online and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

New Payment

Triggered when a payment is received (with line item support).

Update Spreadsheet Row

Update a row in a specific spreadsheet.

New Vendor

Triggered when a new vendor is added.

Create Customer

Adds a new customer.

New Estimate

Triggered when you add a new estimate.

Create Sales Receipt

Adds a new sales receipt (with line item support).

Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.

Become a Zapier Integration Partner

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn More

QuickBooks Online is the web version of the popular accounting packages QuickBooks. Use any Zapier integration to connect QuickBooks Online to hundreds of other apps.

See QuickBooks Online Integrations