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. With 5,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Discover your first Zap

Quickly automate Google Sheets and QuickBooks Online workflows with Zapier's templates

Our most popular Zap! arrow pointing down

Add new QuickBooks Online invoices to Google Sheets spreadsheet rows

Premium

Details

Try it

Create Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets

Premium

Details

Try it

Create Google Sheet rows for new QuickBooks Online expenses

Premium

Details

Try it

Create Google Sheet rows for new payments in QuickBooks Online

Premium

Details

Try it

Create Google Sheets spreadsheet rows from new QuickBooks Online invoices

Premium

Details

Try it

Create Google Sheet rows for new QuickBooks Online customers

Premium

Details

Try it

Add new QuickBooks Online invoices to Google Sheets spreadsheet rows

Premium

Details

Try it

Create Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets

Premium

Details

Try it

Create Google Sheet rows for new QuickBooks Online expenses

Premium

Details

Try it

Create Google Sheet rows for new payments in QuickBooks Online

Premium

Details

Try it

Create Google Sheets spreadsheet rows from new QuickBooks Online invoices

Premium

Details

Try it

Create Google Sheet rows for new QuickBooks Online customers

Premium

Details

Try it

Add new QuickBooks Online bills to Google Sheets rows.
Premium
Details
Try it
QuickBooks Online + Google Sheets
Create invoices in QuickBooks Online from new Google Sheets spreadsheet rows on team drive
Premium
Details
Try it
Google Sheets + QuickBooks Online
Create Joblogic and QuickBooks Online customers from new Google Sheets rows
Premium
Details
Try it
Google Sheets + Joblogic + QuickBooks Online
Create a Google Sheets row for each new QuickBooks Online estimate
Premium
Details
Try it
Google Sheets + QuickBooks Online
Create customers in QuickBooks Online from new or updated rows in Google Sheets
Premium
Details
Try it
Google Sheets + QuickBooks Online
Create new QuickBooks Online bills from new Google Sheets rows
Premium
Details
Try it
Google Sheets + QuickBooks Online
Add new Google Sheets rows to create QuickBooks Online products/services
Premium
Details
Try it
Google Sheets + QuickBooks Online
Create QuickBooks Online vendors from new or updated Google Sheets rows
Premium
Details
Try it
Google Sheets + QuickBooks Online
Add new QuickBooks Online purchase orders to a Google Sheets spreadsheet as rows
Premium
Details
Try it
QuickBooks Online + Google Sheets
Create QuickBooks Online expenses from new or updated Google Sheets spreadsheet rows
Premium
Details
Try it
Google Sheets + QuickBooks Online
Add new QuickBooks Online payments to Google Sheets as multiple rows
Premium
Details
Try it
QuickBooks Online + Google Sheets
Create QuickBooks Online invoices from new or updated Google Sheets rows
Premium
Details
Try it
Google Sheets + QuickBooks Online
Create journal entries in QuickBooks Online for new Google Sheets rows
Premium
Details
Try it
Google Sheets + QuickBooks Online
Add time activities in QuickBooks Online for new Google Sheets rows
Premium
Details
Try it
Google Sheets + QuickBooks Online
Create rows in Google Sheets for updated QuickBooks Online customers
Premium
Details
Try it
QuickBooks Online + Google Sheets
Create expenses in QuickBooks Online from new spreadsheet rows in Google Sheets
Premium
Details
Try it
Google Sheets + QuickBooks Online
Log new QuickBooks Online expenses to Google Sheets as multiple rows
Premium
Details
Try it
QuickBooks Online + Google Sheets
Create multiple Google Sheets rows for new QuickBooks Online invoices
Premium
Details
Try it
QuickBooks Online + Google Sheets
Add new QuickBooks Online sales receipts to Google Sheets as rows
Premium
Details
Try it
QuickBooks Online + Google Sheets
Add new QuickBooks Online vendors to Google Sheets rows
Premium
Details
Try it
QuickBooks Online + Google Sheets
Add new QuickBooks Online bills to Google Sheets as multiple rows
Premium
Details
Try it
QuickBooks Online + Google Sheets
Create rows in Google Sheets for new QuickBooks Online estimates
Premium
Details
Try it
QuickBooks Online + Google Sheets
Create multiple Google Sheets rows for new QuickBooks Online purchase orders
Premium
Details
Try it
QuickBooks Online + Google Sheets
Create QuickBooks Online payments from new or updated Google Sheets spreadsheet rows
Premium
Details
Try it
Google Sheets + QuickBooks Online

Add new QuickBooks Online bills to Google Sheets rows.

Premium

Details

Try it

QuickBooks Online + Google Sheets

Create invoices in QuickBooks Online from new Google Sheets spreadsheet rows on team drive

Premium

Details

Try it

Google Sheets + QuickBooks Online

Create Joblogic and QuickBooks Online customers from new Google Sheets rows

Premium

Details

Try it

Google Sheets + Joblogic + QuickBooks Online

Create a Google Sheets row for each new QuickBooks Online estimate

Premium

Details

Try it

Google Sheets + QuickBooks Online

Create customers in QuickBooks Online from new or updated rows in Google Sheets

Premium

Details

Try it

Google Sheets + QuickBooks Online

Create new QuickBooks Online bills from new Google Sheets rows

Premium

Details

Try it

Google Sheets + QuickBooks Online

Add new Google Sheets rows to create QuickBooks Online products/services

Premium

Details

Try it

Google Sheets + QuickBooks Online

Create QuickBooks Online vendors from new or updated Google Sheets rows

Premium

Details

Try it

Google Sheets + QuickBooks Online

Add new QuickBooks Online purchase orders to a Google Sheets spreadsheet as rows

Premium

Details

Try it

QuickBooks Online + Google Sheets

Create QuickBooks Online expenses from new or updated Google Sheets spreadsheet rows

Premium

Details

Try it

Google Sheets + QuickBooks Online

Add new QuickBooks Online payments to Google Sheets as multiple rows

Premium

Details

Try it

QuickBooks Online + Google Sheets

Create QuickBooks Online invoices from new or updated Google Sheets rows

Premium

Details

Try it

Google Sheets + QuickBooks Online

Create journal entries in QuickBooks Online for new Google Sheets rows

Premium

Details

Try it

Google Sheets + QuickBooks Online

Add time activities in QuickBooks Online for new Google Sheets rows

Premium

Details

Try it

Google Sheets + QuickBooks Online

Create rows in Google Sheets for updated QuickBooks Online customers

Premium

Details

Try it

QuickBooks Online + Google Sheets

Create expenses in QuickBooks Online from new spreadsheet rows in Google Sheets

Premium

Details

Try it

Google Sheets + QuickBooks Online

Log new QuickBooks Online expenses to Google Sheets as multiple rows

Premium

Details

Try it

QuickBooks Online + Google Sheets

Create multiple Google Sheets rows for new QuickBooks Online invoices

Premium

Details

Try it

QuickBooks Online + Google Sheets

Add new QuickBooks Online sales receipts to Google Sheets as rows

Premium

Details

Try it

QuickBooks Online + Google Sheets

Add new QuickBooks Online vendors to Google Sheets rows

Premium

Details

Try it

QuickBooks Online + Google Sheets

Add new QuickBooks Online bills to Google Sheets as multiple rows

Premium

Details

Try it

QuickBooks Online + Google Sheets

Create rows in Google Sheets for new QuickBooks Online estimates

Premium

Details

Try it

QuickBooks Online + Google Sheets

Create multiple Google Sheets rows for new QuickBooks Online purchase orders

Premium

Details

Try it

QuickBooks Online + Google Sheets

Create QuickBooks Online payments from new or updated Google Sheets spreadsheet rows

Premium

Details

Try it

Google Sheets + QuickBooks Online

Top companies trust Zapier to automate work and free up time

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.

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
Premium
Create Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets
Try it
Filter by Zapier + Google Sheets + QuickBooks Online
Zapier users love adding Joblogic to their workflows
Create Joblogic and QuickBooks Online customers from new Google Sheets rows
Premium
Create Joblogic and QuickBooks Online customers from new Google Sheets rows
Try it
Google Sheets + Joblogic + QuickBooks Online

Supported triggers and actions

What does this mean?

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Welcome
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write
New Account
Triggered when you add a new account.
Trigger
Scheduled
Try It
New Customer
Triggered when you add a new customer.
Trigger
Scheduled
Try It
New Expense
Triggers when a new expense is added.
Trigger
Scheduled
Try It
New Invoice
Triggered when you add a new invoice (with line item support).
Trigger
Scheduled
Try It
New Payment
Triggered when a payment is received (with line item support).
Trigger
Scheduled
Try It
New Sales Receipt
Triggered when a new sales receipt is added.
Trigger
Scheduled
Try It
New Vendor
Triggered when a new vendor is added.
Trigger
Scheduled
Try It
- VendorRequired
- Terms
- Transaction Date
- Due Date
- Bill Number
- Department
- Currency
- Global Tax Calculation
- Description
- AmountRequired
- Billable?
- Customer
- Class
- AccountRequired
- Tax Code
- AP Account
- Memo
Action
Write
- CustomerRequired
- Email
- Send Later?
- Billing Address
- Credit Memo Date
- Credit Memo Number
- Class
- AmountRequired
- Service Date
- Product/Service
- Description
- Quantity
- Rate
- Tax
- Class
- Message Displayed On Credit Memo
- Memo
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Sales Tax Rate
- Shipping Cost
Action
Write
- CustomerRequired
- Number
- Line AmountRequired
- Line Description
- Line Item/Product
- Line Item Quantity
- Line Item Tax Code
- Line Item Service Date
- Rate
- Expiration Date
- Message displayed on estimate
- Billing Address
- Shipping Address
- Shipping amount
- Bill Email
- Send later
- Discount Value
- Discount Percent
Action
Write
- TypeRequired
- NameRequired
- Description On Sales Forms
- Sales Price/Rate
- Description On Purchase Forms
- Cost
- SKU
- Category
- Is Taxable?
Action
Write
- CustomerRequired
- Email
- Cc
- Bcc
- Send Later?
- Billing Address
- Shipping Address
- Terms
- Invoice Date
- Due Date
- Ship Via
- Shipping Date
- Tracking Number
- Invoice Number
- Service Date
- Product/Service
- Description
- Quantity
- Rate
- AmountRequired
- Tax
- Class
- Message Displayed on Invoice
- Message Displayed on Statement
- Accept Payment Via Bank Transfer
- Accept Payment Via Credit Card
- Tax Code
- Total Tax
- Tax Calculation
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Shipping Tax
- Shipping
- Deposit
- Class
- Department
- Location
- Currency
Action
Write
- CustomerRequired
- Total AmountRequired
- Unapplied Amount
- Transaction Date
- Payment Method
- Payment Reference Number
- Deposit To Account
- Line Amount
- Memo
- Line Linked Invoice
Action
Write
- Refund FromRequired
- Customer
- Email
- Billing Address
- Refund Receipt Date
- Refund Receipt Number
- Transaction Class
- Payment Method
- Check Number
- Print Later?
- Product/ServiceRequired
- AmountRequired
- Service Date
- Description
- Quantity
- Rate
- Tax
- Class
- Message Displayed On Refund Receipt
- Memo
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Sales Tax Rate
- Shipping
Action
Write
- Sales ReceiptRequired
- Email
Action
Write
- CustomerRequired
- Company
- Email
- Title
- First name
- Middle name
- Last name
- Suffix
- Display name as
- Phone
- Mobile
- Fax
- Other
- Website
- Print On Check As
- Notes
- Billing Address - Street
- Billing Address - City/Town
- Billing Address - State/Province
- Billing Address - ZIP code
- Billing Address - Country
- Shipping Address - Street
- Shipping Address - City/Town
- Shipping Address - State/Province
- Shipping Address - ZIP code
- Shipping Address - Country
- Exemption Details
Action
Write
- Full NameRequired
- PhoneRequired
- Email
- Website
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Search FieldRequired
- Search ValueRequired
Action
Search
- Product NameRequired
Action
Search
- Search FieldRequired
- Search ValueRequired
- Full NameRequired
- Display Name
- Title
- First Name
- Last Name
- Company
- Email
- Phone
- Mobile
- Fax
- Website
- GST Registration Type
- GSTIN
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
- Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State Code
- Shipping Address Zip Code
- Shipping Address Country
- Notes
- Currency
- Tax Registration Number
- Tax Resale Number
- Job/Parent Customer
- Bill with Parent?
- Preferred Payment Method
- Preferred Delivery Method
- Terms
- Customer Type
Action
Search or write

Google Sheets + QuickBooks Online Integrations

How to connect Google Sheets + QuickBooks Online

Add new QuickBooks Online invoices to Google Sheets spreadsheet rows

Create Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets

Create Google Sheet rows for new QuickBooks Online expenses

Create Google Sheet rows for new payments in QuickBooks Online

Create Google Sheets spreadsheet rows from new QuickBooks Online invoices

Create Google Sheet rows for new QuickBooks Online customers

Add new QuickBooks Online invoices to Google Sheets spreadsheet rows

Create Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets

Create Google Sheet rows for new QuickBooks Online expenses

Create Google Sheet rows for new payments in QuickBooks Online

Create Google Sheets spreadsheet rows from new QuickBooks Online invoices

Create Google Sheet rows for new QuickBooks Online customers

Add new QuickBooks Online bills to Google Sheets rows.

Create invoices in QuickBooks Online from new Google Sheets spreadsheet rows on team drive

Create Joblogic and QuickBooks Online customers from new Google Sheets rows

Create a Google Sheets row for each new QuickBooks Online estimate

Create customers in QuickBooks Online from new or updated rows in Google Sheets

Create new QuickBooks Online bills from new Google Sheets rows

Add new Google Sheets rows to create QuickBooks Online products/services

Create QuickBooks Online vendors from new or updated Google Sheets rows

Add new QuickBooks Online purchase orders to a Google Sheets spreadsheet as rows

Create QuickBooks Online expenses from new or updated Google Sheets spreadsheet rows

Add new QuickBooks Online payments to Google Sheets as multiple rows

Create QuickBooks Online invoices from new or updated Google Sheets rows

Create journal entries in QuickBooks Online for new Google Sheets rows

Add time activities in QuickBooks Online for new Google Sheets rows

Create rows in Google Sheets for updated QuickBooks Online customers

Create expenses in QuickBooks Online from new spreadsheet rows in Google Sheets

Log new QuickBooks Online expenses to Google Sheets as multiple rows

Create multiple Google Sheets rows for new QuickBooks Online invoices

Add new QuickBooks Online sales receipts to Google Sheets as rows

Add new QuickBooks Online vendors to Google Sheets rows

Add new QuickBooks Online bills to Google Sheets as multiple rows

Create rows in Google Sheets for new QuickBooks Online estimates

Create multiple Google Sheets rows for new QuickBooks Online purchase orders

Create QuickBooks Online payments from new or updated Google Sheets spreadsheet rows

Add new QuickBooks Online bills to Google Sheets rows.

Create invoices in QuickBooks Online from new Google Sheets spreadsheet rows on team drive

Create Joblogic and QuickBooks Online customers from new Google Sheets rows

Create a Google Sheets row for each new QuickBooks Online estimate

Create customers in QuickBooks Online from new or updated rows in Google Sheets

Create new QuickBooks Online bills from new Google Sheets rows

Add new Google Sheets rows to create QuickBooks Online products/services

Create QuickBooks Online vendors from new or updated Google Sheets rows

Add new QuickBooks Online purchase orders to a Google Sheets spreadsheet as rows

Create QuickBooks Online expenses from new or updated Google Sheets spreadsheet rows

Add new QuickBooks Online payments to Google Sheets as multiple rows

Create QuickBooks Online invoices from new or updated Google Sheets rows

Create journal entries in QuickBooks Online for new Google Sheets rows

Add time activities in QuickBooks Online for new Google Sheets rows

Create rows in Google Sheets for updated QuickBooks Online customers

Create expenses in QuickBooks Online from new spreadsheet rows in Google Sheets

Log new QuickBooks Online expenses to Google Sheets as multiple rows

Create multiple Google Sheets rows for new QuickBooks Online invoices

Add new QuickBooks Online sales receipts to Google Sheets as rows

Add new QuickBooks Online vendors to Google Sheets rows

Add new QuickBooks Online bills to Google Sheets as multiple rows

Create rows in Google Sheets for new QuickBooks Online estimates

Create multiple Google Sheets rows for new QuickBooks Online purchase orders

Create QuickBooks Online payments from new or updated Google Sheets spreadsheet rows

Connect your apps and automate workflows

Do Even More with Google Sheets + QuickBooks Online

Create Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets

Create Joblogic and QuickBooks Online customers from new Google Sheets rows

New Spreadsheet Row (Team Drive)

Drive

SpreadsheetRequired

WorksheetRequired

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

SpreadsheetRequired

WorksheetRequired

Trigger Column

Create Spreadsheet Column

Drive

SpreadsheetRequired