Track new Stripe sales in Google Sheets
How this automation works
Create a sales invoice in Xero automatically when Stripe records a new payment. When the Stripe "New payment received" trigger fires, this Applet creates a sales invoice in the Xero organisation you select and will create the contact if it doesn't already exist. Useful for small businesses and accountants who want Stripe payments reflected in Xero without manual entry.
If
Trigger ingredients
CustomerName
CustomerEmail
Description
Url
CustomerId
InvoiceId
AmountFormatted
Amount
Currency
Status
Id
PaymentMethodId
ChargeId
SourceId
Livemode
Created
Then
Action fields
organisation
customer_name
line_item_description
quantity
unit_amount
account_code
due_date
status
You might also like...
View more Applets
Related services
Create your own Stripe and Xero 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.
18 triggers, queries, and actions
Bill due soon
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 bill is due within the number of days you specify in the organisation you select.
Failed 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 payment attempt fails.
Invoice overdue
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 sales invoice becomes overdue in the organisation you select.
Invoice paid
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 sales invoice is fully paid in the organisation you select.
New contact
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 contact is created in the organisation you select.
New customer created
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 customer is created.
New invoice created
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 received
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 received.
New sales 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 sales invoice is created in the organisation you select.
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 a customer based on email or id.
Get cash balance
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 the current balance of the bank account you select in the organisation you select.
Look up an invoice
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 the details of the sales invoice whose number you specify.
Create a bill
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 bill payable to the contact you specify in the organisation you select. The contact is created in Xero if it doesn't already exist.
Create a sales 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 sales invoice for the contact you specify in the organisation you select. The contact is created in Xero if it doesn't already exist.
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 new customer.
Create or update a contact
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 contact, or update the matching contact, in the organisation you select. The contact name is the match key for updates.
Create payment link
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 payment link.
Create subscription
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 new subscription for a customer.
Bill due soon
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 bill is due within the number of days you specify in the organisation you select.
Create a bill
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 bill payable to the contact you specify in the organisation you select. The contact is created in Xero if it doesn't already exist.
Create a sales 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 sales invoice for the contact you specify in the organisation you select. The contact is created in Xero if it doesn't already exist.
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 new customer.
Create or update a contact
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 contact, or update the matching contact, in the organisation you select. The contact name is the match key for updates.
Create payment link
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 payment link.
Create subscription
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 new subscription for a customer.
Failed 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 payment attempt fails.
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 a customer based on email or id.
Get cash balance
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 the current balance of the bank account you select in the organisation you select.
Invoice overdue
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 sales invoice becomes overdue in the organisation you select.
Invoice paid
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 sales invoice is fully paid in the organisation you select.
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 Stripe and Xero
About Stripe
We bring together everything that’s required to build websites and apps that accept payments and send payouts globally. Stripe’s products power payments for online and in-person retailers, subscriptions businesses, software platforms and marketplaces, and everything in between.
We bring together everything that’s required to build websites and apps that accept payments and send payouts globally. Stripe’s products power payments for online and in-person retailers, subscriptions businesses, software platforms and marketplaces, and everything in between.
About Xero
Xero is cloud accounting software for small businesses, bookkeepers, and accountants. It handles invoicing, bills, bank reconciliation, contacts, and financial reporting, keeping your books in sync across the tools you use.
Xero is cloud accounting software for small businesses, bookkeepers, and accountants. It handles invoicing, bills, bank reconciliation, contacts, and financial reporting, keeping your books in sync across the tools you use.