Google Sheets + QuickBooks Online
Create QuickBooks Online journal entries from new or updated Google Sheets rows
Stay on top of your finances with this automation! Whenever there are new or updated rows in your Google Sheets, this workflow will produce a corresponding journal entry in QuickBooks Online. This process not only keeps your accounting precise, but also enables seamless management of finances, saving you precious time and effort.
Stay on top of your finances with this automation! Whenever there are new or updated rows in your Google Sheets, this workflow will produce a corresponding journal entry in QuickBooks Online. This process not only keeps your accounting precise, but also enables seamless management of finances, saving you precious time and effort.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Journal EntryCreates a new journal entry.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
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
Bottom-Up
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
Bottom-Up
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
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.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
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
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.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
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.InvoiceRequired
EmailRequired
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.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
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.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.Search FieldRequired
Search ValueRequired
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
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
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
No 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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Bottom-Up
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?
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
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
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.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
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
Expiration Date
Message displayed on estimate
Billing Address
Shipping Address
Shipping amount
Bill Email
Send later
Discount Value
Discount Percent
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.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
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
Memo
Line Linked Invoice
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.Sales ReceiptRequired
Email
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
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.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
ActionThis is an event a Zap performs.SearchFind existing data in your appFull 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.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsAbout QuickBooks Online
QuickBooks Online is the web version of the popular accounting packages QuickBooks. Use any Zapier integration to connect QuickBooks Online to hundreds of other apps.
Related categories
Similar apps
Xero
Accounting
FreeAgent
Accounting
Wave
AccountingRelated Zap Templates
- Add new QuickBooks Online invoices to Google Sheets spreadsheet rows
- Create Google Sheet rows for new QuickBooks Online expenses
- Create Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets
- Create Google Sheet rows for new QuickBooks Online customers
- Create Google Sheet rows for new payments in QuickBooks Online
- Create customers in QuickBooks Online from new or updated rows in Google Sheets
- Create Google Sheets spreadsheet rows from new QuickBooks Online invoices
- Add new QuickBooks Online bills to Google Sheets rows.
- Update spreadsheet rows in Google Sheets with new expenses from QuickBooks Online
- Update multiple Google Sheets rows whenever customers in QuickBooks Online are updated
- Create sales receipts in QuickBooks Online for new rows in Google Sheets
- Add new QuickBooks Online purchase orders to a Google Sheets spreadsheet as rows
- Add new QuickBooks Online bills to Google Sheets as multiple rows
- Create invoices in QuickBooks Online from new Google Sheets spreadsheet rows on team drive
- Create new QuickBooks Online bills from new Google Sheets rows
- Create Joblogic and QuickBooks Online customers from new Google Sheets rows
- Create a Google Sheets row for each new QuickBooks Online estimate
- Add new Google Sheets rows to create QuickBooks Online products/services
- Create QuickBooks Online vendors from new or updated Google Sheets 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
- 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
- Create QuickBooks Online payments from new Google Sheets rows in team drive
- Create QuickBooks Online credit memos from new or updated Google Sheets rows
- Create new QuickBooks Online refund receipts from new Google Sheets rows
- Update spreadsheet rows in Google Sheets with new invoices from QuickBooks Online
- Create spreadsheet rows in Google Sheets for new sales receipts in QuickBooks Online
- Create spreadsheets in Google Sheets for new accounts in QuickBooks Online
- Update Google Sheets rows with new QuickBooks Online invoices
- Manage new QuickBooks Online customers by copying worksheets in Google Sheets
- Create multiple spreadsheet rows in Google Sheets for new vendors in QuickBooks Online
- Update Google Sheets rows for new QuickBooks Online accounts
- Create spreadsheet rows in Google Sheets for new accounts in QuickBooks Online
- Create products/services in QuickBooks Online from new or updated rows in Google Sheets
- Create QuickBooks Online bills from new or updated rows in Google Sheets team drive
- Create payments in QuickBooks Online from new rows in Google Sheets
- Create new QuickBooks Online customers from new rows in Google Sheets team drive
- Update QuickBooks Online with api requests for every new or updated row in Google Sheets
- Create journal entries in QuickBooks Online for new or updated rows in Google Sheets team drive
- Update Google Sheets rows with new QuickBooks Online customers effortlessly
- Create new QuickBooks Online bills from new or updated Google Sheets rows
Related Zap Templates
- Add new QuickBooks Online invoices to Google Sheets spreadsheet rows
- Create Google Sheet rows for new QuickBooks Online customers
- Create Google Sheets spreadsheet rows from new QuickBooks Online invoices
- Update multiple Google Sheets rows whenever customers in QuickBooks Online are updated
- Add new QuickBooks Online bills to Google Sheets as multiple rows
- Create Joblogic and QuickBooks Online customers from new Google Sheets rows
- Create QuickBooks Online vendors from new or updated Google Sheets rows
- Create QuickBooks Online invoices from new or updated Google Sheets rows
- Create rows in Google Sheets for updated QuickBooks Online customers
- Create multiple Google Sheets rows for new QuickBooks Online invoices
- Create rows in Google Sheets for new QuickBooks Online estimates
- Create new estimates in QuickBooks Online from new rows in Google Sheets
- Create Google Sheets rows for new QuickBooks Online invoices
- Create QuickBooks Online payments from new Google Sheets rows in team drive
- Update spreadsheet rows in Google Sheets with new invoices from QuickBooks Online
- Update Google Sheets rows with new QuickBooks Online invoices
- Update Google Sheets rows for new QuickBooks Online accounts
- Create QuickBooks Online bills from new or updated rows in Google Sheets team drive
- Update QuickBooks Online with api requests for every new or updated row in Google Sheets
- Create new QuickBooks Online bills from new or updated Google Sheets rows
- Create Google Sheet rows for new QuickBooks Online expenses
- Create Google Sheet rows for new payments in QuickBooks Online
- Add new QuickBooks Online bills to Google Sheets rows.
- Create sales receipts in QuickBooks Online for new rows in Google Sheets
- Create invoices in QuickBooks Online from new Google Sheets spreadsheet rows on team drive
- Create a Google Sheets row for each new QuickBooks Online estimate
- Create QuickBooks Online expenses from new or updated Google Sheets spreadsheet rows
- Create journal entries in QuickBooks Online for new Google Sheets rows
- Create expenses in QuickBooks Online from new spreadsheet rows in Google Sheets
- Add new QuickBooks Online sales receipts to Google Sheets as rows
- Create multiple Google Sheets rows for new QuickBooks Online purchase orders
- Create Google Sheets spreadsheets from new QuickBooks Online estimates
- Track new QuickBooks Online expenses by creating spreadsheets in Google Sheets
- Create QuickBooks Online credit memos from new or updated Google Sheets rows
- Create spreadsheet rows in Google Sheets for new sales receipts in QuickBooks Online
- Manage new QuickBooks Online customers by copying worksheets in Google Sheets
- Create spreadsheet rows in Google Sheets for new accounts in QuickBooks Online
- Create payments in QuickBooks Online from new rows in Google Sheets
- Create journal entries in QuickBooks Online for new or updated rows in Google Sheets team drive
- Create Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets
- Create customers in QuickBooks Online from new or updated rows in Google Sheets
- Update spreadsheet rows in Google Sheets with new expenses from QuickBooks Online
- Add new QuickBooks Online purchase orders to a Google Sheets spreadsheet as rows
- Create new QuickBooks Online bills from new Google Sheets rows
- Add new Google Sheets rows to create QuickBooks Online products/services
- Add new QuickBooks Online payments to Google Sheets as multiple rows
- Add time activities in QuickBooks Online for new Google Sheets rows
- Log new QuickBooks Online expenses to Google Sheets as multiple rows
- Add new QuickBooks Online vendors to Google Sheets rows
- Create QuickBooks Online payments from new or updated Google Sheets spreadsheet rows
- Add new QuickBooks Online customers to Google Sheets as multiple spreadsheet rows
- Create new QuickBooks Online invoices from new Google Sheets rows
- Create new QuickBooks Online refund receipts from new Google Sheets rows
- Create spreadsheets in Google Sheets for new accounts in QuickBooks Online
- Create multiple spreadsheet rows in Google Sheets for new vendors in QuickBooks Online
- Create products/services in QuickBooks Online from new or updated rows in Google Sheets
- Create new QuickBooks Online customers from new rows in Google Sheets team drive
- Update Google Sheets rows with new QuickBooks Online customers effortlessly