Google Forms + QuickBooks Online

Create invoices in QuickBooks Online for new or updated responses in Google Forms spreadsheets

Create invoices instantly in QuickBooks Online when new or updated responses are added to a Google Forms spreadsheet. This seamless workflow saves time by eliminating manual data entry, allowing you to focus on managing your finances and boosting your business efficiency. Stay organized and streamline your invoicing process with this simple, yet effective automation.

When this happens...
New or Updated Form Response
Triggers when a form response is added or modified.
TriggerInstant
automatically do this!
Create Invoice
Adds a new invoice (with line item support).
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

What does this mean?

- FormRequired
Trigger
Instant
Try It
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
New Bill
Triggers when a new bill is added.
Trigger
Scheduled
Try It
New Estimate
Triggered when you add a new estimate.
Trigger
Scheduled
Try It
New Invoice
Triggered when you add a new invoice.
Trigger
Scheduled
Try It

New Sales Receipt
Triggered when a new sales receipt is added (with line item support).
Trigger
Scheduled
Try It
New Purchase Order
Triggers when a new purchase order is added.
Trigger
Scheduled
Try It

Updated Customer
Triggered when an existing customer is updated.
Trigger
Scheduled
Try It
- VendorRequired
- Bill Number
- Line Item
- Line Description
- AmountRequired
- Qty
- Unit Price
- Line Class
- AP Account
- Customer
- Due Date
- Transaction Date
Action
Write
- 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
Action
Write
- Full NameRequired
- Display Name
- Title
- First Name
- Last Name
- Company
- Email
- Phone
- Mobile
- Fax
- Website
- GST Registration Type
- GSTIN
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
- Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State Code
- Shipping Address Zip Code
- Shipping Address Country
- Notes
- Currency
- Tax Registration Number
- Tax Resale Number
- Job/Parent Customer
- Bill with Parent?
- Preferred Payment Method
- Preferred Delivery Method
- Terms
- Customer Type
Action
Write
- 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
Action
Write
- 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
Action
Write
- 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
Action
Write
- 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
Action
Write
- InvoiceRequired
- EmailRequired
Action
Write
- Time Activity TypeRequired
Action
Write
- 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
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Search FieldRequired
- Search ValueRequired
Action
Search
- Product NameRequired
Action
Search
- Search FieldRequired
- Search ValueRequired
- Full NameRequired
- Display Name
- Title
- First Name
- Last Name
- Company
- Email
- Phone
- Mobile
- Fax
- Website
- GST Registration Type
- GSTIN
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
- Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State Code
- Shipping Address Zip Code
- Shipping Address Country
- Notes
- Currency
- Tax Registration Number
- Tax Resale Number
- Job/Parent Customer
- Bill with Parent?
- Preferred Payment Method
- Preferred Delivery Method
- Terms
- Customer Type
Action
Search or write

- FormRequired
Trigger
Instant
Try It
New Account
Triggered when you add a new account.
Trigger
Scheduled
Try It
New Customer
Triggered when you add a new customer.
Trigger
Scheduled
Try It
New Expense
Triggers when a new expense is added.
Trigger
Scheduled
Try It
New Invoice
Triggered when you add a new invoice (with line item support).
Trigger
Scheduled
Try It
New Payment
Triggered when a payment is received (with line item support).
Trigger
Scheduled
Try It
New Sales Receipt
Triggered when a new sales receipt is added.
Trigger
Scheduled
Try It
New Vendor
Triggered when a new vendor is added.
Trigger
Scheduled
Try It
- VendorRequired
- Terms
- Transaction Date
- Due Date
- Bill Number
- Department
- Currency
- Global Tax Calculation
- Description
- AmountRequired
- Billable?
- Customer
- Class
- AccountRequired
- Tax Code
- AP Account
- Memo
Action
Write
- CustomerRequired
- Email
- Send Later?
- Billing Address
- Credit Memo Date
- Credit Memo Number
- Class
- AmountRequired
- Service Date
- Product/Service
- Description
- Quantity
- Rate
- Tax
- Class
- Message Displayed On Credit Memo
- Memo
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Sales Tax Rate
- Shipping Cost
Action
Write
- CustomerRequired
- Number
- Line AmountRequired
- Line Description
- Line Item/Product
- Line Item Quantity
- Line Item Tax Code
- Line Item Service Date
- Rate
- Expiration Date
- Message displayed on estimate
- Billing Address
- Shipping Address
- Shipping amount
- Bill Email
- Send later
- Discount Value
- Discount Percent
Action
Write
- TypeRequired
- NameRequired
- Description On Sales Forms
- Sales Price/Rate
- Description On Purchase Forms
- Cost
- SKU
- Category
- Is Taxable?
Action
Write
- CustomerRequired
- Email
- Cc
- Bcc
- Send Later?
- Billing Address
- Shipping Address
- Terms
- Invoice Date
- Due Date
- Ship Via
- Shipping Date
- Tracking Number
- Invoice Number
- Service Date
- Product/Service
- Description
- Quantity
- Rate
- AmountRequired
- Tax
- Class
- Message Displayed on Invoice
- Message Displayed on Statement
- Accept Payment Via Bank Transfer
- Accept Payment Via Credit Card
- Tax Code
- Total Tax
- Tax Calculation
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Shipping Tax
- Shipping
- Deposit
- Class
- Department
- Location
- Currency
Action
Write
- CustomerRequired
- Total AmountRequired
- Unapplied Amount
- Transaction Date
- Payment Method
- Payment Reference Number
- Deposit To Account
- Line Amount
- Memo
- Line Linked Invoice
Action
Write
- Refund FromRequired
- Customer
- Email
- Billing Address
- Refund Receipt Date
- Refund Receipt Number
- Transaction Class
- Payment Method
- Check Number
- Print Later?
- Product/ServiceRequired
- AmountRequired
- Service Date
- Description
- Quantity
- Rate
- Tax
- Class
- Message Displayed On Refund Receipt
- Memo
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Sales Tax Rate
- Shipping
Action
Write
- Sales ReceiptRequired
- Email
Action
Write
- CustomerRequired
- Company
- Email
- Title
- First name
- Middle name
- Last name
- Suffix
- Display name as
- Phone
- Mobile
- Fax
- Other
- Website
- Print On Check As
- Notes
- Billing Address - Street
- Billing Address - City/Town
- Billing Address - State/Province
- Billing Address - ZIP code
- Billing Address - Country
- Shipping Address - Street
- Shipping Address - City/Town
- Shipping Address - State/Province
- Shipping Address - ZIP code
- Shipping Address - Country
- Exemption Details
Action
Write
- Full NameRequired
- PhoneRequired
- Email
- Website
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
Action
Write
- Account NameRequired
Action
Search
- Invoice NumberRequired
Action
Search
- NameRequired
Action
Search
- Full NameRequired
- PhoneRequired
- Email
- Website
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
Action
Search or write

About Google Forms

Google Forms is an easy way to collect data from the web with a simple UI and powerful editor. Works hand-in-hand with Google Sheets!

Learn more Help

Related categories

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

About 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.

Learn more Help

Related categories

Accounting

Similar apps

Xero

Accounting

FreeAgent

Accounting

Wave

Accounting

PRODUCTS

CAPABILITIES

By team

Google Forms + QuickBooks Online

Create invoices in QuickBooks Online for new or updated responses in Google Forms spreadsheets

New Form Response

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

New Bill

New Estimate

New Invoice

New Sales Receipt

New Purchase Order

Updated Customer

Create Bill (Item Based)

VendorRequired

Bill Number

Line Item

Line Description

AmountRequired

Qty

Unit Price

Line Class

AP Account

Customer

Due Date

Transaction Date

Create Bill (Item Based)

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

Create Customer

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