Track new Stripe sales in Google Sheets
How this automation works
Create a matching Stripe customer to keep billing and payment records in sync. It runs whenever a new contact is added to the Xero organisation you select and uses the contact details to create the customer in Stripe. This is useful for finance and sales teams who want Xero contacts reflected in Stripe for invoices, subscriptions, and unified customer records across Xero and Stripe.
If
Trigger ingredients
ContactId
ContactName
FirstName
LastName
EmailAddress
IsCustomer
IsSupplier
PhoneNumber
ContactStatus
Then
Action fields
name
email
phone_number
address_line_1
address_line_2
city
state
country
zip
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.