When I create an invoice in Quickbooks, add invoice information to Google Sheets
How this automation works
Create an invoice for new Shippo customers
If
Trigger ingredients
OrderNumber
OrderStatus
SubtotalPrice
TotalPrice
TotalTax
Currency
Weight
WeightUnit
ShippingCost
ShippingCostCurrency
ShippingMethod
Notes
PlacedAt
ShopApp
OrderObjectId
LineItemTitle
LineItemDescription
LineItemSku
LineItemPrice
LineItemPriceCurrency
LineItemWeight
LineItemWeightUnit
LineItemObjectId
ToAddressName
ToAddressEmail
ToAddressCompany
ToAddressPhone
ToAddressStreet1
ToAddressStreet2
ToAddressStreet3
ToAddressCity
ToAddressState
ToAddressCountry
ToAddressZip
ToAddressObjectId
FromAddressName
FromAddressEmail
FromAddressCompany
FromAddressPhone
FromAddressStreet1
FromAddressStreet2
FromAddressStreet3
FromAddressCity
FromAddressState
FromAddressCountry
FromAddressZip
FromAddressObjectId
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...
-
7
-
-
When I receive a payment in Quickbooks, post to a Slack Channel
5
-
-
If a new deal is created, then create a customer
4
-
Related services
Create your own Shippo 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.
12 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 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 order
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 order 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.
New shipping label
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 shipping label 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.
Find order
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 an order.
Find shipping label
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 a shipping label.
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 order
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 an order
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 order
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 an order
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.
Find order
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 an order.
Find shipping label
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 a shipping label.
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 order
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 order 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.
New shipping label
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 shipping label 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 Shippo and QuickBooks Online
About Shippo
Shippo is the leading shipping platform for modern e-commerce. With Shippo’s platform, businesses of all sizes can access 60+ global carriers, get real-time shipping rates, print labels, automate international paperwork, track packages, facilitate returns, and more.
Shippo is the leading shipping platform for modern e-commerce. With Shippo’s platform, businesses of all sizes can access 60+ global carriers, get real-time shipping rates, print labels, automate international paperwork, track packages, facilitate returns, and more.
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.