QuickBooks Online + Email Parser by Zapier + Google Sheets Integrations
How to connect QuickBooks Online + Email Parser by Zapier + Google Sheets
Zapier lets you send info between QuickBooks Online and Email Parser by Zapier and Google Sheets automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with QuickBooks Online + Email Parser by Zapier + 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 QuickBooks Online, Email Parser by Zapier, and Google Sheets. And don’t forget that you can add more apps and actions to create complex workflows.
New Account
Triggered when you add a new account.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Customer
Triggered when you add a new customer.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Expense
Triggers when a new expense is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice
Triggered when you add a new invoice (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Payment
Triggered when a payment is received (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Receipt
Triggered when a new sales receipt is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Vendor
Triggered when a new vendor is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planVendorRequired
Terms
Transaction Date
Due Date
Bill Number
Department
Currency
Only available if multicurrency is enabled.
Global Tax Calculation
Description
AmountRequired
Billable?
If a line item is billable, please use the Customer field to specify which customer.
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
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.CustomerRequired
Email
Send Later?
Billing Address
Credit Memo Date
Defaults to today's date if not specified.
Credit Memo Number
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
AmountRequired
Service Date
Product/Service
Description
Quantity
Rate
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed On Credit Memo
Memo
Apply Tax After Discount?
US versions of QuickBooks only.
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
Select a specific customer.
Number
Max of 21 characters. If empty, Quickbooks will generate one by incrementing the last number, but only if you have custom transaction numbers disabled. number automatically. Max of 21 characters.
Line AmountRequired
Should not include tax.
Line Description
Line Item/Product
Line Item Quantity
Line Item Tax Code
Line Item Service Date
Format: YYYY-MM-DD
Rate
When using this field, the Rate * Quantity must be equal to the line amount
Expiration Date
Message displayed on estimate
Billing Address
If the customer you enter in the "Customer" field has a default billing address, that address will be used if this field is left blank.
Shipping Address
If the customer you enter in the "Customer" field has a default shipping address, that address will be used if this field is left blank.
Shipping amount
Bill Email
Email address where estimate is sent. Separate emails with commas for multiple addresses
Send later
If set to true, the Bill Email field should also be provided
Discount Value
Discount values must be positive (e.g.
10for a 10 value discount)Discount Percent
Discount values must be positive (e.g.
10for a 10% discount)
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?
Only applicable to US companies.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Email
If not set, the customer's primary email will be used.
Cc
Bcc
Send Later?
Billing Address
If the customer you enter in the "Customer" field has a default billing address, that address will be used if this field is left blank.
Shipping Address
If the customer you enter in the "Customer" field has a default shipping address, that address will be used if this field is left blank.
Terms
Invoice Date
Defaults to today's date if not specified.
Due Date
Ship Via
Shipping Date
Tracking Number
Invoice Number
If empty, no Invoice number is added. Max of 21 characters or put AUTO_GENERATE to let QuickBooks increment this automatically.
Service Date
Product/Service
Description
Quantity
Rate
Should not include tax.
AmountRequired
Should not include tax.
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed on Invoice
Message Displayed on Statement
Accept Payment Via Bank Transfer
Accept Payment Via Credit Card
Tax Code
Total Tax
Requires choosing a Tax Code above.
Tax Calculation
Method in which tax is applied.
Apply Tax After Discount?
Discount Value
Discount values must be positive (e.g.
.10for a 10% discount)Discount Percent
Shipping Tax
Shipping
Deposit
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Department
Only available if your preferences allow tracking of department.
Location
Only available for France locales.
Currency
Only available if multicurrency is enabled. Defaults to your home currency if left blank.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Total AmountRequired
Unapplied Amount
The amount that has not been applied to pay amounts owed for sales transactions.
Transaction Date
Payment Method
Payment Reference Number
Deposit To Account
A.K.A. Income Account
Line Amount
Should not include tax.
Memo
Line Linked Invoice
Only choose an invoice if this payment is linked to one.
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
If the customer you enter in the "Customer" field has a default billing address, that address will be used if this field is left blank.
Refund Receipt Date
Defaults to today's date if not specified.
Refund Receipt Number
Transaction Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Payment Method
Check Number
Print Later?
Product/ServiceRequired
AmountRequired
Service Date
Description
Quantity
Rate
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed On Refund Receipt
Memo
Apply Tax After Discount?
US versions of QuickBooks only.
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.Sales ReceiptRequired
Email
Send to an explicit email address instead of the receipt billing one, and updates the one on the sales receipt to this.
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
Must be unique for every customer.
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
PhoneRequired
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.Api Docs Info
API docs for Quickbooks are located here https://developer.intuit.com/app/developer/qbo/docs/develop
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search FieldRequired
Search ValueRequired
Depending on which "Search Field" you selected, the search value must exactly match the "Display name as" field or "Email" field in Quickbooks.
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch FieldRequired
Search ValueRequired
Depending on which "Search Field" you selected, the search value must exactly match the "Display name as" field or "Email" field in Quickbooks.
Full NameRequired
Display Name
If not set, Full Name will be used here.
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
Only available if multicurrency is enabled.
Tax Registration Number
Tax Resale Number
Job/Parent Customer
Choose a Parent Customer if you're creating a Job/sub-customer.
Bill with Parent?
If no, this customer will be billed.
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 foundMailboxRequired
Only trigger on emails sent to this specific mailbox. Don't forget to set up your parser mailboxes at https://parser.zapier.com/.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
The column position (zero-based) to insert. If not set, append to the right by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
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
Create a duplicate of an existing spreadsheet.
Headers
These Headers are ignored if a "Spreadsheet to Copy" is selected.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
Use a search step before this to get the row to delete.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet?
Row Count
Number of rows to return. Max is 500.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
ColumnsRequired
Let us know which columns to return. e.g. A:Z
Row CountRequired
Number of rows to return. Max is 500.
First Row
Number of the first row to return (1 is the header)
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
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
New Bill
Triggers when a new bill is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Estimate
Triggered when you add a new estimate.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice
Triggered when you add a new invoice.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Receipt
Triggered when a new sales receipt is added (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Purchase Order
Triggers when a new purchase order is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Customer
Triggered when an existing customer is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planVendorRequired
Specifies the vendor for this bill.
Bill Number
Line Item
Line Description
AmountRequired
Amount of the line item.
Qty
Quantity of the line item.
Unit Price
Unit Price of the line item.
Line Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
AP Account
Customer
Specifies the customer associated with the bill.
Due Date
Transaction Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.VendorRequired
Specifies the vendor for this bill.
Terms
Transaction Date
Due Date
Bill Number
Department
Global Tax Calculation
Product/Service
Description
Qty
Rate
AmountRequired
Billable?
If a line item is billable, please use the Customer field to specify which customer.
Customer
Line Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Tax Code
AP Account
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
Display Name
If not set, Full Name will be used here.
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
Only available if multicurrency is enabled.
Tax Registration Number
Tax Resale Number
Job/Parent Customer
Choose a Parent Customer if you're creating a Job/sub-customer.
Bill with Parent?
If no, this customer will be billed.
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
Is the payee a Vendor, Customer, or Employee?
Payment TypeRequired
Bank/Credit AccountRequired
Payment Date
Defaults to today's date if not specified.
Payment Method
Reference Number
Will be used as check number if payment type is check.
Print Later?
Only applicable if payment type is check.
Account
Description
Amount
You must enter an amount here or in the "Amount" field under "Item Details."
Billable Status
Tax Code
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Product/Service
Description
Quantity
Rate
Amount
You must enter an amount here or in the "Amount" field under "Account Details."
Billable Status
Tax Code
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Journal Date
Defaults to today's date if not specified.
Journal Number
AccountRequired
Debit AmountRequired
Total amount of "Debits" line items must equal the total amount of "Credits" line items.
Description
Customer Name
Vendor Name
Employee Name
Department
Only available if your preferences allow tracking of department.
Class
AccountRequired
Credit AmountRequired
Total amount of "Credits" line items must equal the total amount of "Debits" line items.
Description
Customer Name
Vendor Name
Employee Name
Department
Only available if your preferences allow tracking of department.
Class
Memo
Currency
Only available if multicurrency is enabled. Defaults to your home currency if left blank.
Exchange Rate
Only available if multicurrency is enabled.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer
Select a specific customer, or, use the below field to look up a customer on demand.
Find Customer by Name/Email
If you just have access to the customer's name or email, use this.
Email
Send Later?
Note
Message
Line AmountRequired
Should not include tax.
Service Date
Line Description
Product/Service
Line Item Quantity
Line Item Unit Price
Should not include tax.
Line Item Tax Code
Line Item Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Transaction Date
Total Discount
Will be added as a Discount Line item. The company preference Sales Form Entry | Discounts must be enabled.
Payment Method
Payment Reference Number
Deposit To Account
A.K.A. Income Account
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
Only available if multicurrency is enabled.
Exchange Rate
The number of home currency units it takes to equal one unit of currency specified above. Only available if multicurrency is enabled.
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Tax Code
Total Tax
Requires choosing a Tax Code above.
Tax Calculation
Method in which tax is applied.
Shipping Tax
Shipping Cost
Department
Only available if your preferences allow tracking of 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
Address to which the payment should be sent.
Shipping Address
Address to which the vendor shipped or will ship goods associated with purchase.
Purchase Order Date
Ship Via
Purchase Order Number
Account
Description
Amount
You must enter an amount here or in the "Amount" field under "Item Details."
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Product/Service
Description
Quantity
Rate
Amount
You must enter an amount here or in the "Amount" field under "Account Details."
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Your Message to Vendor
Memo
For internal use. Will not appear on purchase order to vendor
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InvoiceRequired
EmailRequired
Send to an explicit email address instead of the invoice billing one, and updates the one on the invoice to this.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Activity TypeRequired
Is this for an Employee or Vendor?
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
Service Date
Product/Service
Description
Quantity
Rate
Should not include tax.
Amount
Should not include tax.
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed on Invoice
Message Displayed on Statement
Accept Payment Via Bank Transfer
Accept Payment Via Credit Card
Tax Code
Total Tax
Requires choosing a Tax Code above.
Tax Calculation
Method in which tax is applied.
Apply Tax After Discount?
Discount Value
Discount values must be positive (e.g.
.10for a 10% discount)Discount Percent
Shipping Tax
Shipping
Deposit
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Department
Only available if your preferences allow tracking of department.
Location
Only available for France locales.
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
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 appInvoice NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Enter the vendor's display name exactly as it appears in QuickBooks Online.
ActionThis is an event a Zap performs.SearchFind existing data in your appFull NameRequired
Enter the vendor's display name exactly as it appears in QuickBooks Online.
PhoneRequired
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 found
New Mailbox
Triggers when a new mailbox is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Background Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Bold
True if the text is bold.
Text Italic
True if the text is italicized.
Text Strikethrough
True if the text is strikethrough.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
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
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.
How QuickBooks Online + Email Parser by Zapier + Google Sheets Integrations Work
- Step 1: Authenticate QuickBooks Online, Email Parser by Zapier, 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.
About QuickBooks Online
Related categories
Similar apps
Xero
Accounting
FreeAgent
Accounting
Wave
Accounting
About Google Sheets
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
