QuickBooks Online
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,000+ apps in minutes.


Enterprise-level security—connect mission-critical apps.

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

When this happens...
then do this!
New Payment

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

Create Customer

Adds a new customer.

New Vendor

Triggered when a new vendor is added.

Create Sales Receipt

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

New Estimate

Triggered when you add a new estimate.

Create Invoice

Adds a new invoice (with line item support).

New Customer

Triggered when you add a new customer.

Create Worksheet

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

New Account

Triggered when you add a new account.

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

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

Become a Zapier Integration Partner

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.

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

See Google Sheets Integrations