QuickBooks Online + Google Sheets Integrations

How to connect QuickBooks Online + Google Sheets

Zapier lets you send info between QuickBooks Online and Google Sheets automatically—no code required. With 6,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 QuickBooks Online and Google Sheets 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
Create new estimates in QuickBooks Online from new rows in Google Sheets
Premium
Details
Try it
Google Sheets + QuickBooks Online
Create Google Sheets spreadsheets from new QuickBooks Online estimates
Premium
Details
Try it
QuickBooks Online + Google Sheets
Add new QuickBooks Online customers to Google Sheets as multiple spreadsheet rows
Premium
Details
Try it
QuickBooks Online + Google Sheets
Create Google Sheets rows for new QuickBooks Online invoices
Premium
Details
Try it
QuickBooks Online + Google Sheets
Track new QuickBooks Online expenses by creating spreadsheets in Google Sheets
Premium
Details
Try it
QuickBooks Online + Google Sheets
Create new QuickBooks Online invoices from new Google Sheets 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

Create new estimates in QuickBooks Online from new rows in Google Sheets

Premium

Details

Try it

Google Sheets + QuickBooks Online

Create Google Sheets spreadsheets from new QuickBooks Online estimates

Premium

Details

Try it

QuickBooks Online + Google Sheets

Add new QuickBooks Online customers to Google Sheets as multiple spreadsheet rows

Premium

Details

Try it

QuickBooks Online + Google Sheets

Create Google Sheets rows for new QuickBooks Online invoices

Premium

Details

Try it

QuickBooks Online + Google Sheets

Track new QuickBooks Online expenses by creating spreadsheets in Google Sheets

Premium

Details

Try it

QuickBooks Online + Google Sheets

Create new QuickBooks Online invoices from new Google Sheets 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 QuickBooks Online + Google Sheets

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 QuickBooks Online + Google Sheets 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?

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
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It

QuickBooks Online + Google Sheets Integrations

How to connect QuickBooks Online + Google Sheets

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

Create new estimates in QuickBooks Online from new rows in Google Sheets

Create Google Sheets spreadsheets from new QuickBooks Online estimates

Add new QuickBooks Online customers to Google Sheets as multiple spreadsheet rows

Create Google Sheets rows for new QuickBooks Online invoices

Track new QuickBooks Online expenses by creating spreadsheets in Google Sheets

Create new QuickBooks Online invoices from new Google Sheets 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

Create new estimates in QuickBooks Online from new rows in Google Sheets

Create Google Sheets spreadsheets from new QuickBooks Online estimates

Add new QuickBooks Online customers to Google Sheets as multiple spreadsheet rows

Create Google Sheets rows for new QuickBooks Online invoices

Track new QuickBooks Online expenses by creating spreadsheets in Google Sheets

Create new QuickBooks Online invoices from new Google Sheets rows

Connect your apps and automate workflows

Do Even More with QuickBooks Online + Google Sheets

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 Account

New Customer