Send Square Sales to Airtable
Square's dashboard shows your counter sales, but if your team plans, reports or reconciles in Airtable, those sales have to be exported and imported by hand. This workflow watches Square for orders that reach the Completed state, checks Airtable so no sale is logged twice, and adds one record per sale with the order ID, date, location, customer, items, tax, tip and total.
How it works
5 steps to log every completed Square sale in Airtable
Square reports a changed order
Square reports a changed order
Keep only completed, fully paid orders
Keep only completed, fully paid orders
Airtable checks if this sale is already logged
Airtable checks if this sale is already logged
Skip sales that already have a record
Skip sales that already have a record
Airtable adds a record for the sale
Airtable adds a record for the sale
Ready to log every completed Square sale in Airtable
Get setup in 5 minutes.
FAQs
Why does this use Order Updated instead of Order Created?
A Square order can be created before it is paid. Watching for updates and keeping only orders in the COMPLETED state means only finished, fully paid sales reach Airtable.
Will a sale ever be logged twice?
No. Before adding a record, the workflow searches Airtable for the Square order ID and stops if a record already has it.
Can I log one record per item instead of one per sale?
Yes. Add a Loop step over the order's line items before the Add Record step and write one record per item, with the Square order ID on each so they can be grouped.
Personalize this template
Customize this workflow even further:
You're in good company
"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."
"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."
"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"
log every completed Square sale in Airtable
5 min setup • Fully supported if you need help