How to connect Shopify + QuickBooks Online + Google Sheets
Zapier lets you send info between Shopify and QuickBooks Online and Google Sheets automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Shopify + QuickBooks Online + Google Sheets
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Shopify, QuickBooks Online, and Google Sheets. And don’t forget that you can add more apps and actions to create complex workflows.
New Blog
Triggers when a new blog is added to your Shopify store.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Customer
Triggers when a new customer is added to your Shopify account.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Cancelled Order
Triggers whenever an order is cancelled (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Fulfilled Order
Triggers when an order is fulfilled (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Paid Order
Triggers when an order is paid (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Refund
Triggers when a refund or partial refund occurs.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Customer
Triggers when a customer's information is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Order
Triggers when an order is updated (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order IDRequired
Type of Line Item to AddRequired
Reason for Edit
Notify the Customer?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BlogRequired
TitleRequired
Author NameRequired
ContentRequired
Featured Image URL
Excerpt/Summary
Tags
Is Published?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Add New Image - File
Add New Image - Alt Text
Choose Existing Image
Price
Compare-at Price
Charge Tax On This Variant?
Cost Per Item
SKU (Stock Keeping Unit)
Barcode (ISBN, UPC, GTIN, etc.)
Track Quantity?
Continue Selling When Out of Stock?
This Is a Physical Product
Weight
Weight Unit
Country/Region of Origin
Harmonized System (HS) code
Position
Requires Components
Tax Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Product
Product Variant
Product Quantity
Product Title
Product Price
Weight in Grams
Note
Discount - Type
Discount - Amount
Discount - Code
Additional Details
Tags
Shipping Address Instructions
Shipping Address - First name
Shipping Address - Last name
Shipping Address - Company
Shipping Address - Phone
Shipping Address - Address
Shipping Address - Address con't
Shipping Address - City
Shipping Address - Country
Shipping Address - State/Province/Region
Shipping Address - Postal/Zip code
Billing Address Instructions
Billing Address - First name
Billing Address - Last name
Billing Address - Company
Billing Address - Phone
Billing Address - Address
Billing Address - Address con't
Billing Address - City
Billing Address - Country
Billing Address - State/Province/Region
Billing Address - Postal/Zip code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Adjust or Set quantity?Required
The name of quantities to be changedRequired
The reason for the quantity changesRequired
LocationRequired
Product
Product VariantRequired
Quantity to Set or Adjust
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Product Type
Vendor
Product Status
Product Description
Tags
Collection ID
Handle
Note
First Product Option
Values for First Product Option
Second Product Option
Values for Second Product Option
Third Product Option
Values for Third Product Option
Category
Alt Text
Media Content Type
Original Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
TagsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
First Name
Last Name
Email Address
Company Name
Default Address
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Tags
Phone Number
Note
Tax Exempt
Tax Exemptions
Accepts Marketing
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Product VariantRequired
Title
Price
Compare at Price
SKU
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Query - Name
Query - Confirmation Number
Query - Email
Query - Customer ID
Query - Location ID
Query - SKU
Query - Order ID
Sort Key
Reverse?
Raw Query
ActionThis is an event a Zap performs.SearchFind existing data in your appOwner ResourceRequired
Owner IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appIdsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct Variant SKURequired
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Email AddressRequired
First Name
Last Name
Customer Phone
Company Name
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Address Phone
Tags
Note
Accepts Marketing
Tax Exempt
Tax Exemptions
Send E-Mail Invite
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProductRequired
TitleRequired
Exact MatchRequired
Price
Compare at Price
SKU
Inventory Policy
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Bill
Triggers when a new bill is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Estimate
Triggers when you add a new estimate.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Bill Payment
Triggers when a new bill paid.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Deposit
Triggers when a there is a new deposit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Journal Entry
Triggers when a new journal entry is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Refund Receipt
Triggers when there is a new refund receipt.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Project
Triggers when a new project is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Receipt
Triggers when a new sales receipt is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Credit Memo
Triggers when a credit memo is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Estimate
Triggers when an existed estimate is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Vendor
Triggers when a new vendor is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.VendorRequired
Terms
Transaction Date
Due Date
Bill Number
Department
Currency
Global Tax Calculation
Description
AmountRequired
Billable?
Customer
Class
AccountRequired
Tax Code
AP Account
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deposit To AccountRequired
Transaction Date
Private Note
Currency
Exchange Rate
Global Tax Calculation
Department
Transaction Source
Transaction Location Type
AmountRequired
AccountRequired
Payment Method
Description
Transaction Type
Entity
Class
Check Number
Tax Code
Tax Applicable On
Cash Back Account
Cash Back Amount
Cash Back Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Email
Send Later?
Billing Address
Credit Memo Date
Credit Memo Number
Auto Generate 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Number
Line AmountRequired
Line Description
Line Item/Product
Line Item Quantity
Line Item Tax Code
Line Item Service Date
Rate
Tax Calculation
Transaction Date
Expiration Date
Ship Date
Message displayed on estimate
Billing Address
Billing Address City
Billing Address Country
Billing Address Postal Code
Billing Address State/Province
Shipping Address
Shipping Address City
Shipping Address Country
Shipping Address Postal Code
Shipping Address State/Province
Shipping amount
Bill Email
Send later
Discount Value
Discount Percent
Class
Sales Terms
Shipping Method
Tracking Number
Private Note
Transaction Status
Apply Tax After Discount
Print Status
Department
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
NameRequired
Description On Sales Forms
Sales Price/Rate
Description On Purchase Forms
Cost
SKU
Category
Is Taxable?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
CustomerRequired
Email
Cc
Bcc
Send Later?
Billing Address
Shipping Address
Terms
Invoice Date
Due Date
Ship Via
Shipping Date
Tracking Number
Invoice Number
Auto Generate Invoice Number
Service Date
Product/Service
Description
Quantity
Rate
Helptext Line Amount
Amount
Tax
Class
Add Bundle Item to invoice?
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
Deposit To Account
Class
Department
Location
Currency
Exchange Rate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Total AmountRequired
Unapplied Amount
Transaction Date
Payment Method
Payment Reference Number
Deposit To Account
Line Amount
Line Linked Invoice
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
InvoiceRequired
Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Activity TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
Job/Parent Customer
Active
Customer Type
Preferred Payment Method
Taxable
Tax Code
Tax Registration Number
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InvoiceRequired
Customer
Email
Cc
Bcc
Send Later?
Billing Address
Shipping Address
Terms
Invoice Date
Due Date
Ship Via
Shipping Date
Tracking Number
Invoice Number
Auto Generate Invoice Number
Service Date
Product/Service
Description
Quantity
Rate
Amount
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sales Receipt IDRequired
Customer
Transaction Date
Shipping Date
Info
Detail Type
Amount
Description
Item
Unit Price
Quantity
Discount Percent
Total Amount
Print Status
Email Status
Payment Reference Number
Deposit To Account
Payment Method
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address State/Province
Shipping Address Postal Code
Shipping Address Country
Billing Address Line 1
Billing Address Line 2
Billing Address City
Billing Address State/Province
Billing Address Postal Code
Billing Address Country
Tracking Number
Class
Department
Private Note
Customer Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEstimate IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
ID
Display Name
ActionThis is an event a Zap performs.SearchFind existing data in your appIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
Product Name
SKU
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch FieldRequired
Search ValueRequired
Full NameRequired
Display Name
Title
First Name
Middle name
Last Name
Company
Email
Phone
Mobile
Fax
Other
Website
Active
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
Taxable
Tax Code
Tax Registration Number
Tax Resale Number
Job/Parent Customer
Bill with Parent?
Preferred Payment Method
Preferred Delivery Method
Terms
Customer Type
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundIDRequired
Info
Customer
Find Customer by Name/Email
Email
Send Later?
Note
Message
Line AmountRequired
Service Date
Line Description
Product/Service
Line Item Quantity
Line Item Unit Price
Line Item Tax Code
Line Item Class
Transaction Date
Total Discount
Payment Method
Payment Reference Number
Deposit To Account
Sales Receipt Number
Auto Generate Sales Receipt Number
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
Currency
Exchange Rate
Class
Tax Code
Total Tax
Tax Calculation
Shipping Tax
Shipping Cost
Department
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFull NameRequired
Phone
Email
Website
Address Line 1
Address Line 2
Address City
Address State Code
Address Zip Code
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
BlogRequired
Blog Entry Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCustomer Account Enabled
Triggers when a customer account is enabled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Abandoned Cart Age (Hours)Required
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Draft Order
Triggers when a new draft order is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Order
Triggers when an order is created (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Product
Triggers when a product is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Tag Added to Customer
Triggers when a new tag is added to a customer.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Product
Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.CustomerRequired
TagsRequired
Overwrite existing tags?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
External Id
A note about the company
Company Contact
Contact Email
Contact First Name
Contact Last Name
Contact Phone
Contact Title
Contact Locale
Location
Billing same as shipping address?
Company Shipping Address
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address Country Code
Shipping First Name
Shipping Last Name
Shipping Address Phone
Shipping Address Recipient
Shipping Address Zip
Shipping Address Zone Code
Location External ID
Location Locale
Location Name
Location Note
Location Phone
Tax Registration Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Email AddressRequired
Customer Phone
Company Name
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Address Phone
Tags
Note
Accepts Marketing
Tax Exempt
Tax Exemptions
Send E-Mail Invite
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Fulfillment Order IDRequired
Notify Customer
Address Line 1
Address Line 2
City
Country Code
Province Code
Zip Code
Tracking Company
Tracking Number
Tracking URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Product
Product Variant
SKU
Product Quantity
Product Title
Product Price
Weight in Grams
Price
Rate
Title
Note
Discount - Type
Discount - Amount
Discount - Code
Additional Details
Tags
Buyer Accepts Marketing?
Shipping Address Instructions
Shipping Address - First name
Shipping Address - Last name
Shipping Address - Company
Shipping Address - Phone
Shipping Address - Address
Shipping Address - Address con't
Shipping Address - City
Shipping Address - Country
Shipping Address - Country Code
Shipping Address - State/Province/Region
Shipping Address - State/Province/Region Code
Shipping Address - Postal/Zip code
Billing Address Instructions
Billing Address - First name
Billing Address - Last name
Billing Address - Company
Billing Address - Phone
Billing Address - Address
Billing Address - Address con't
Billing Address - City
Billing Address - Country
Billing Address - Country Code
Billing Address - State/Province/Region
Billing Address - State/Province/Region Code
Billing Address - Postal/Zip code
Send Receipt
Send Fulfillment Receipt
Location
Inventory Behaviour
Financial Status
Fulfillment Status
Code
Title
Price
Discounted Price
Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Channel IDRequired
Publish Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrderRequired
Amount
Currency
Type
Parent Transaction
Warning
Gateway
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Email
Notes
Phone
Buyer Accepts Marketing?
Remove Customer from Order?
Tags
Additional Details
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - City
Shipping Address - Company
Shipping Address - Country
Shipping Address - First Name
Shipping Address - Last Name
Shipping Address - Latitude
Shipping Address - Longitude
Shipping Address - Name
Shipping Address - Phone
Shipping Address - Province
Shipping Address - Province Code
Shipping Address - ZIP
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Title
Product Type
Vendor
Product Status
Product Description
Tags
Category
Collections to Join
Collections to Leave
Handle
Redirect Handle?
Alt Text
Media Content Type
Original Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct TitlesRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct Variant TitlesRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProductRequired
Product Variant TitleRequired
Exact MatchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct TitleRequired
Product TypeRequired
VendorRequired
Product Description
Tags
Published At
Price
Inventory Policy
Image URL
More Image URLs
SKU
Is Published?
Publish to Point of Sale
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Account
Triggers when you add a new account.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Customer
Triggers when you add a new customer.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Expense
Triggers when a new expense is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
Triggers when you add a new invoice.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Credit Memo
Triggers when a new credit memo is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice Paid
Triggers when an invoice is paid in full. (Balance changes to zero)
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Product
Triggers when a new product is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Payment
Triggers when a payment is received (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Purchase Order
Triggers when a new purchase order is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Bill
Triggers when a bill is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Customer
Triggers when an existing customer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Invoice
Triggers when an invoice is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.VendorRequired
Bill Number
Line Item
Line Description
AmountRequired
Qty
Unit Price
Line Class
AP Account
Customer
Due Date
Transaction Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.VendorRequired
Terms
Transaction Date
Due Date
Bill Number
Department
Global Tax Calculation
Product/Service
Description
Qty
Rate
AmountRequired
Billable?
Customer
Line Class
Tax Code
AP Account
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Primary Email Address
Given NameRequired
Family NameRequired
Middle Name
Employee Phone Number
Birth Date
Billable Time
Active
Release Date
Cost Rate
Employee Mobile
Gender
Hired Date
Organization
Address Line 1
Address Line 2
Address Line 3
Address Line 4
Address Line 5
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
Display Name
Title
First Name
Middle name
Last Name
Company
Email
Phone
Mobile
Fax
Other
Website
Active
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
Taxable
Tax Code
Tax Registration Number
Tax Resale Number
Job/Parent Customer
Bill with Parent?
Preferred Payment Method
Preferred Delivery Method
Terms
Customer Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Payee TypeRequired
Payment TypeRequired
Bank/Credit AccountRequired
Payment Date
Payment Method
Reference Number
Print Later?
Account
Description
Amount
Billable Status
Tax Code
Customer
Class
Product/Service
Description
Quantity
Rate
Amount
Billable Status
Tax Code
Customer
Class
Memo
Tax Code
Total Tax
Tax Calculation
Department
Location
Currency
Exchange Rate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Journal Date
Journal Number
AccountRequired
Debit AmountRequired
Description
Customer Name
Vendor Name
Employee Name
Department
Class
AccountRequired
Credit AmountRequired
Description
Customer Name
Vendor Name
Employee Name
Department
Class
Memo
Currency
Exchange Rate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Customer
Find Customer by Name/Email
Email
Send Later?
Note
Message
Line AmountRequired
Service Date
Line Description
Product/Service
Line Item Quantity
Line Item Unit Price
Line Item Tax Code
Line Item Class
Transaction Date
Total Discount
Payment Method
Payment Reference Number
Deposit To Account
Sales Receipt Number
Auto Generate Sales Receipt Number
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
Currency
Exchange Rate
Class
Tax Code
Total Tax
Tax Calculation
Shipping Tax
Shipping Cost
Department
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.VendorRequired
Purchase Order Status
Mailing Address
Shipping Address
Purchase Order Date
Ship Via
Purchase Order Number
Account
Description
Amount
Customer
Class
Product/Service
Description
Quantity
Rate
Amount
Customer
Class
Your Message to Vendor
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Estimate IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sales ReceiptRequired
Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Bill IDRequired
Vendor
AP Account
Transaction Date
Due Date
Line ID
Amount
Description
Account
Customer
Class
Tax Code
Billable Status
Currency
Exchange Rate
Private Note
Global Tax Calculation
Total Amount
Sales Terms
Department
Document Number
Include in Annual TPAR
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Estimate IDRequired
Customer
Transaction Date
Shipping Date
Detail Type
Amount
Description
Item
Unit Price
Quantity
Discount Percent
Print Status
Email Status
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address State/Province
Shipping Address Postal Code
Shipping Address Country
Billing Address Line 1
Billing Address Line 2
Billing Address City
Billing Address State/Province
Billing Address Postal Code
Billing Address Country
Class
Sales Terms
Shipping Method
Tracking Number
Document Number
Accepted By
Accepted Date
Exchange Rate
Department
Apply Tax After Discount
Private Note
Customer Memo
Expiration Date
Transaction Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ItemRequired
Name
Type
SKU
Sales Tax Included
Sales Tax Code
Class
Source
Purchase Tax Included
Description
Sub Item
Taxable
Purchase Description
Active
Purchase Cost
Unit Price
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
Phone
Email
Website
Address Line 1
Address Line 2
Address City
Address State Code
Address Zip Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Account NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch FieldRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
ID
Name
ActionThis is an event a Zap performs.SearchFind existing data in your appIdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
Invoice Number
Invoice ID
Invoice Date
Due Date
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
ID
Display Name
Primary Email Address
Given NameRequired
Family NameRequired
Middle Name
Employee Phone Number
Birth Date
Billable Time
Active
Release Date
Cost Rate
Employee Mobile
Gender
Hired Date
Organization
Address Line 1
Address Line 2
Address Line 3
Address Line 4
Address Line 5
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundInfo
Product NameRequired
SKU
TypeRequired
Description On Sales Forms
Sales Price/Rate
Description On Purchase Forms
Cost
Category
Is Taxable?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Shopify + QuickBooks Online + Google Sheets Integrations Work
- Step 1: Authenticate Shopify, QuickBooks Online, and Google Sheets.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Related categories
Related categories
Similar apps
Related categories
Other Shopify + QuickBooks Online Integrations
Other Shopify + Google Sheets Integrations
- activecampaign
- airtable
- trello
- schedule
- looping
- salesforce
- google-contacts
- clickfunnels
- asana
- xero
- sms
- klaviyo
- keap-max-classic
- stripe
- hubspot
- flodesk
- facebook-offline-conversions
- facebook-custom-audiences
- manychat
- typeform
- twilio
- sendinblue
- pipedrive
- kajabi
- google-calendar
- getresponse
- thinkific
- tactful-ucx
- square
- shipstation
- onfleet
- keap
- google-forms
- zendesk
- zapier-chrome-extension
- wordsmith
- webflow
- thrivecart
- storage
- sql-server
- patreon
- mysql
- leadpages
- leadconnector
- gravity-forms
- google-drive
- google-docs
- google-chat
- facebook-lead-ads
- copper
- zoom
- zoho-sign
- zoho-mail
- zoho-desk
- zoho-crm
- youtube
- woocommerce
- wodify
- wave
- untappd
- trustpilot
- touchsms
- tookan
- surveymonkey
- superphone
- squarespace
- sparkpost
- smtp
- smsadvertio
- smartsheet
- shippo
- recharge
- reamaze
- pushover
- proof-factor
- powr-form-builder
- postalytics
- popupsmart
- paypal
- ontraport
- neoncrm
- mondaycom
- monday
- moloni
- microsoft-teams
- microsoft-outlook
- messenger-platinum-mobile-wallet
- mdstools
- mailjet
- magento
- lob
- kartra
- kafkai
- judgeme
- jotform
- intercom
- help-scout
- handwrytten
- google-tasks
- google-analytics
- freshdesk
- facebook-pages
- facebook-lead-ads-beta
- facebook-conversions
- email-parser
- ecwid
- dropbox
- drip
- docusign
- docparser
- detrack
- delighted
- dear-inventory
- clickup
- clearbit
- bombbombcom
- bitly
- bigmarker
- bigcommerce
- beaconstac
- autopilot
- apify
- alegra
- 90-day-sales
Other QuickBooks Online + Google Sheets Integrations
- code
- stripe
- gravity-forms
- activecampaign
- airtable
- google-drive
- trello
- shipstation
- monday
- google-forms
- google-contacts
- square
- zapier-chrome-extension
- sms
- pipedrive
- jotform
- email-parser
- looping
- knack
- wufoo
- woocommerce
- twilio
- podio
- pandadoc
- mailchimp
- hubspot
- google-calendar
- eventbrite
- etapestry
- calendly
- acuity-scheduling
- zoho-campaigns
- zoho-books
- youcanbookme
- toggl
- todoist
- thrivecart
- sub-zap-by-zapier
- smartsheet
- signrequest
- signnow
- shortcut
- recurly
- pixifi
- parseur
- paperform
- ontraport
- office-365
- novo
- mysql
- mailparser
- keap-max-classic
- kajabi
- jira-software
- invoice-ninja
- iformbuilder
- hubstaff
- highrise
- guesty
- goformz
- gocanvas
- freshbooks
- formsite
- forms-for-slack
- formidable
- excel
- ecwid
- docusign
- docparser
- discord
- digest
- cyberimpact
- cognito-forms
- cobot
- clio
- clickup
- campaign-monitor
- braintree
- b1g1
- asana
- amocrm
- abacus
- onelocal-localreviews