Add new QuickBooks Online invoices to Google Sheets
How this automation works
Automatically create new customers in QuickBooks Online when someone submits a form in Gravity Forms. This Applet runs each time a new form submission arrives, transferring key details like name, email, and phone into QuickBooks Online. Ideal for service providers or small businesses that want to save time and reduce data entry between their website and accounting system.
If
Trigger ingredients
FormId
FormTitle
DateCreated
FirstName
LastName
Email
Question1Title
Question1Answer
Question2Title
Question2Answer
Question3Title
Question3Answer
Question4Title
Question4Answer
Question5Title
Question5Answer
Then
Action fields
display_name
company
customer_type
email
phone
address_line_1
address_line_2
city
state
zip
website
notes
fax
bill_with_parent
job_parent_customer
Services used in this Applet
You might also like...
View more Applets
Related services
Create your own QuickBooks Online and Gravity Forms workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
8 triggers, queries, and actions
New customer
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when there is a new customer.
New form submission
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new form is submitted.
New invoice
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new invoice is created.
New payment
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new payment is created.
Find customer
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns Quickbooks Online customers.
Create customer
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a customer.
Create invoice
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a Quickbooks Online invoice.
Create sales receipt
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a sales receipt.
Create customer
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a customer.
Create invoice
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a Quickbooks Online invoice.
Create sales receipt
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a sales receipt.
Find customer
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns Quickbooks Online customers.
New customer
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when there is a new customer.
New form submission
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new form is submitted.
New invoice
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new invoice is created.
New payment
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new payment is created.
Build an automation in seconds!
If
Select a trigger the automation will use
Then
Select an action the automation will perform
You can add delays, queries, and more actions in the next step!
More on QuickBooks Online and Gravity Forms
About QuickBooks Online
Take control of your business by saving time on bookkeeping and paperwork with QuickBooks Online.
QuickBooks Online is designed to help you manage your business finances with ease. Grow your business effortlessly with our all-in-one online business software.
Take control of your business by saving time on bookkeeping and paperwork with QuickBooks Online.
QuickBooks Online is designed to help you manage your business finances with ease. Grow your business effortlessly with our all-in-one online business software.
About Gravity Forms
Gravity Forms is a powerful and flexible form builder that helps WordPress users create custom contact forms, surveys, quizzes, and more without any coding. Easily capture leads, collect payments, and manage user submissions with its intuitive drag-and-drop interface and powerful conditional logic. Connect Gravity Forms to IFTTT to automate actions based on new form submissions, sync collected data with other services, and streamline your entire workflow. Optimize your website and unlock new automation possibilities with a robust forms integration.
Gravity Forms is a powerful and flexible form builder that helps WordPress users create custom contact forms, surveys, quizzes, and more without any coding. Easily capture leads, collect payments, and manage user submissions with its intuitive drag-and-drop interface and powerful conditional logic. Connect Gravity Forms to IFTTT to automate actions based on new form submissions, sync collected data with other services, and streamline your entire workflow. Optimize your website and unlock new automation possibilities with a robust forms integration.