• Google Sheets logoGoogle Sheets logo
  • QuickBooks Online logoQuickBooks Online logo

Google Sheets + QuickBooks Online Integrations

How to connect Google Sheets + QuickBooks Online

Zapier lets you send info between Google Sheets and QuickBooks Online automatically—no code required.

When this happens...
automatically do this!

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.

By signing up, you agree to Zapier’s Terms of Service and Privacy Policy
By signing up, you agree to Zapier’s Terms of Service and Privacy Policy
Google Sheets logo
QuickBooks Online logo

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.

  • Google Sheets triggers, actions, and search
    New Spreadsheet Row (Team Drive)
    Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
    Trigger
    Scheduled
  • Google Sheets triggers, actions, and search
    New Spreadsheet Row
    Triggered when a new row is added to the bottom of a spreadsheet.
    Trigger
    Instant
  • Google Sheets triggers, actions, and search
    New Spreadsheet
    Triggered when you create a new spreadsheet.
    Trigger
    Scheduled
  • Google Sheets triggers, actions, and search
    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
    Scheduled
  • Google Sheets triggers, actions, and search
    New or Updated Spreadsheet Row
    Triggered when a new row is added or modified in a spreadsheet.
    Trigger
    Instant
  • Google Sheets triggers, actions, and search
    New Worksheet
    Triggered when you create a new worksheet in a spreadsheet.
    Trigger
    Scheduled
  • Google Sheets triggers, actions, and search
    Create Spreadsheet Column
    Create a new column in a specific spreadsheet.
    Action
    Write
  • Google Sheets triggers, actions, and search
    Create Spreadsheet Row
    Create a new row in a specific spreadsheet.
    Action
    Write
  • 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

  1. Step 1: Authenticate Google Sheets and QuickBooks Online.
    30 seconds
  2. Step 2: Pick one of the apps as a trigger, which will kick off your automation.
    15 seconds
  3. Step 3: Choose a resulting action from the other app.
    15 seconds
  4. Step 4: Select the data you want to send from one app to the other.
    2 minutes
  5. That’s it! More time to work on other things.

Google Sheets Tutorials

google-sheets logo
google-sheets logo

About Google Sheets

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

Related categories

Similar apps

Zoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrations

Smartsheet

Spreadsheets
Quip integrations

Quip

Documents
quickbooks logo
quickbooks logo

About QuickBooks Online

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.
Learn more

Related categories

Similar apps

Harvest integrations

Harvest

Time Tracking Software
Xero integrations

Xero

Accounting
FreeAgent integrations

FreeAgent

Accounting

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

Or
By signing up, you agree to Zapier’s Terms of Service and Privacy Policy