Add new QuickBooks Online invoices to Google Sheets
How this automation works
Automatically generate a QuickBooks Online invoice every time a PandaDoc document is marked as completed. This helps you keep your accounting records up to date without manual data entry. Ideal for closing deals faster and ensuring all signed contracts instantly reflect in your financial system.
If
Trigger ingredients
Name
ID
Status
TemplateName
CreatedByFirstName
CreatedByLastName
SentByFirstName
SentByLastName
CreatedByEmail
SentByEmail
DocumentUrl
DateCompleted
DateCreated
DateSent
RefNumber
ExpirationDate
Version
Then
Action fields
customer_id
customer_memo
bill_email
send_email_later
due_date
txn_date
product_service
description
quantity
unit_price
amount
sales_term
private_note
Services used in this Applet
You might also like...
View more Applets
Related services
Create your own PandaDoc and QuickBooks Online 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.
10 triggers, queries, and actions
Document completed
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 document is completed.
Document sent
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 document is sent.
Document status changed
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 document status changes to the selected state.
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 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.
Document completed
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 document is completed.
Document sent
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 document is sent.
Document status changed
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 document status changes to the selected state.
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 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 PandaDoc and QuickBooks Online
About PandaDoc
PandaDoc is an all-in-one document automation and e-signature platform that simplifies the creation, management, and signing of business documents. Connect PandaDoc to IFTTT to automate document tracking, trigger follow-ups based on recipient activity, or sync signed documents with your other business tools.
PandaDoc is an all-in-one document automation and e-signature platform that simplifies the creation, management, and signing of business documents. Connect PandaDoc to IFTTT to automate document tracking, trigger follow-ups based on recipient activity, or sync signed documents with your other business tools.
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.