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
Premium
QuickBooks Online is a Premium integration on Zapier.

Why Zapier?

Free

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

Easy

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

Secure

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 Spreadsheet Row

Create a new row in a specific spreadsheet.

New or Updated Spreadsheet Row

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

Update Spreadsheet Row

Update a row in a specific spreadsheet.

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).

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

Become a Zapier Integration Partner

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

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