The usual Square Airtable integration is a Zapier zap. It starts when Square has a new payment, order, invoice or customer, and it makes or updates a record in your Airtable table. For past sales, you download a CSV file from Square and bring it in with Airtable's CSV import extension. Where it stops: refunds don't start a zap, the zap checks Square every 15 minutes on Zapier's Free plan, payments can be missed with no error, and each record the zap writes counts against Airtable's monthly limit. Nobody checks the table against Square. AI agents do that work.
What a Square Airtable integration has to do
Square holds the sales. Airtable is where many small teams keep the rest: client notes, orders to fill, a member list, or a report the owner reads on Monday. When the two don't match, someone opens Square, finds the sale and types it into the base by hand.
So connected has to mean more than new rows showing up. Each sale lands once, not twice. Refunds come across too. And when a sale doesn't arrive, someone finds out that day, not at month end when the totals don't add up.
Three ways to connect Square and Airtable
Most teams use a zap for new sales and a CSV file for the past.
A Zapier zap
- How it works
- Zapier's Square triggers are New Payment, New Order, New Invoice and New Customer. The Airtable step can create a record or update one you already have. You map each Square detail, like the amount or the customer's email, to a field in your table.
- Good for
- A team that wants each new sale or new customer in Airtable without typing it.
- Where it breaks
- Square has no refund trigger in Zapier, so a refund in Square doesn't change the record. Zapier says it checks Square every 15 minutes on its Free plan. In Zapier's Community, a person found half a weekend's payments never reached their table, with no error shown. Each record the zap writes also counts as an Airtable API call.
A CSV file from Square, imported into Airtable
- How it works
- In Square Dashboard you can download your transactions as a CSV file. In Airtable, the CSV import extension adds the rows to a table, or merges them with records you already have, using a field you set, like a payment ID.
- Good for
- Loading past sales once, or a monthly catch-up when a few sales a day don't need a zap.
- Where it breaks
- The file is a copy of the day you download it. Airtable says the extension takes up to 25,000 rows and 5MB per file. If two rows share the merge value, only the first is used. A row with a blank merge field makes a new record, so repeat imports can make duplicates.
Arkeo agents
- How it works
- Agents read sales, refunds and customers in Square, keep the matching records in Airtable current, and compare the two each day. They find sales that never came across, refunds the base doesn't show and records that appear twice.
- Good for
- Teams who run their week from an Airtable base and sell through Square at the counter, online or by invoice.
- Where it breaks
- Anything your rules keep for a person, like deleting a record or changing an amount, goes to the owner in one message.
How to set up the Square Airtable integration
These follow Zapier's, Square's and Airtable's own pages. Open them for the screens.
- 1Set up the table first
In Airtable, make a table with a field for each detail you want from Square. Add one field for the Square payment or order ID. You will use it to match records later and to spot repeats.
- 2Start a zap from Square
In Zapier, start a zap with Square and set the trigger, like New Payment or New Order. Sign in to Square when Zapier asks. If you have more than one location, check the Location field on this step.
- 3Send it to Airtable
Add an Airtable step. Use Create Record for each new sale, or Update Record if the record should already exist. Map the Square ID, the amount, the date and the customer to your fields, then test it with a real sale.
- 4Bring in past sales with a CSV file
In Square Dashboard, download your transactions for the dates you need as a CSV file. Square notes that if you rename an item, its sales show as a separate item in reports, so check item names before you import.
- 5Import and merge on the Square ID
Open the CSV import extension in your base, add the file and turn on merging. Set the Square ID field as the field to merge on, so a sale that is already there is updated, not added again.
- 6Check your Airtable API use
In your workspace settings, look at how many API calls you have used this month. Zaps and other apps that write to your base count toward the same limit as your own calls.
Where the Square Airtable integration stops
The zap copies new sales into a table. Keeping that table true to Square after the sale is still a person's job.
Refunds don't come across. Zapier's Square triggers are new payments, orders, invoices and customers. Refund Payment is only an action, so a refund in Square starts nothing. The record still shows the full sale until someone finds it and edits it by hand.
A missed sale makes no noise. In a Zapier Community thread, a seller found that half of one weekend's Square payments never reached their table, and Zapier showed no error. The best answer in the thread was to check the Location field and the zap's history. Until someone looks, the table is short and nobody knows it.
Customers can show up twice. In an older Zapier Community thread, a seller said the zap made duplicate customers and they had to merge them by hand in Square. The CSV route has its own version: Airtable says a row with a blank merge field becomes a new record.
The base has a monthly limit. Airtable's Free plan allows 1,000 API calls a month per workspace and the Team plan 100,000. Calls from connected apps count too. On the Free plan, a busy store can use that up before the month ends.
None of it checks the totals. Nobody is told that the base says one thing and Square says another until the owner asks why the numbers are off.
The agents that do it
Each agent does one job from start to finish, in your own Square and Airtable. Your team talks to them in Slack or Teams.
Your base stays current without anyone typing it in.
- Reads new clients, orders and jobs from your other softwareas they come
- Adds and updates the records in Airtablesame day
- Flags records missing a fieldevery day
A base your team can trust.
- Finds duplicate and blank recordsevery day
- Fixes what your rules allowsame day
- Sends the rest to the record ownerright away
Know what sold without building the report.
- Pulls sales, refunds and top itemsevery Monday
- Compares it to last weekevery Monday
- Sends it to your teamMonday morning
Questions
Is my customers' information safe?
Yes. Agents work in your own Square and Airtable and see only what their job needs. Customer details never go into public AI. Agents connect to AI through business-grade connections audited under SOC 2.
Can Square connect to Airtable without Zapier?
Yes, with a CSV file. Download your transactions from Square Dashboard, then add them to a table with Airtable's CSV import extension. It is a one-time copy, so you repeat it each time you want new sales.
Do Square refunds show up in Airtable?
Not with a zap on its own. Zapier's Square triggers cover new payments, orders, invoices and customers, not refunds. Someone has to edit the record by hand, or build a check that finds refunds.
How do I stop duplicate records from Square?
Keep the Square payment or order ID in its own field. In the zap, use Update Record when the record should already exist. When you import a CSV file, merge on that ID field.
What does it cost?
You get the price on the call, along with the hours it saves your team.
Sources
- zapier.com: square
- squareup.com: summaries and reports from the online dashboard
- support.airtable.com: csv import extension
- support.airtable.com: import csv data into an existing base
- support.airtable.com: managing api call limits in airtable
- community.zapier.com: data present in square but not polled by zapier 48040
- community.zapier.com: missing invoice paid trigger for new square integration 12490