Every morning at 7am
Daily Shopify orders in Airtable
Every morning Leta adds yesterday's paid Shopify orders to your Airtable Orders table, one record per order, without adding any order twice.
Airtable + Shopify integration
Combine Airtable + Shopify and move store data into your Airtable bases, or base records into Shopify. Just ask Letaido's AI agent and watch it do the work.
Best Airtable and Shopify integration jobs to start with
Use this Airtable Shopify integration for order logs, product copy, launch plans and partner codes.
When you ask
Approved product copy from Airtable to Shopify
Leta copies approved titles, descriptions, SEO fields and tags from your Airtable product copy table to Shopify, then marks each record Published.
Every Monday at 9am
New Shopify products in an Airtable launch tracker
Every Monday Leta adds the past week's new Shopify products to your Airtable launch tracker, marked To plan, so marketing can plan each launch.
When you ask
Partner discount codes from Airtable
Leta creates a Shopify discount code for each approved partner in Airtable that has none yet, then saves the code on the partner's record.
Every Monday at 8am
Weekly partner code results in Airtable
Every Monday Leta counts each partner code's Shopify orders and order value for the past 30 days and writes them on the partner's Airtable record.
Airtable Shopify integration options, compared
Sync apps mirror your store in Airtable. Letaido runs the jobs around it.
| Option | Shopify data into Airtable | Airtable edits back to Shopify | Reasons over the data | Starts when the store changes |
|---|---|---|---|---|
 Letaido AI agent | Yes | Yes | Yes | No |
| AirPower sync app for Shopify | Yes | Yes | No | Yes |
| SyncBase sync app for Shopify | Yes | Yes | No | Yes |
| Zapier | Yes | Yes | Partly | Partly |
| Make | Yes | Yes | Partly | Partly |
Read the full comparison
| Option | Which way | How it starts | Good for | Keep in mind |
|---|---|---|---|---|
| Letaido AI agent | Both ways, one job at a time | A schedule, or when you ask | Jobs with a judgement step: a daily orders table, approved copy published to products, new products in a launch tracker, partner codes and their results | Not a live mirror of your store. Neither connector has event triggers in Letaido, so jobs run on a schedule or when you ask |
| AirPower sync app for Shopify | Both ways | Store changes reach Airtable as they happen. Edits go back with Sync now or on a schedule | Running your catalog in Airtable: bulk edits to titles, prices, tags, SEO, metafields and stock, plus orders and customers for reports | A Shopify App Store app with its own monthly plan. It builds and links the tables for you |
| SyncBase sync app for Shopify | Both ways | Changes sync as they happen, in either direction | A full PIM, order or purchase order base, from a template or built by their Studio team | A Shopify App Store app with its own monthly plan. Lower plans cap products, orders and customers |
| Zapier | Both ways, one workflow for each | Shopify triggers like New Paid Order fire right away. Airtable record triggers check for new data on a timer | Fixed handoffs, such as a record for each paid order or a product from a new record | You build and maintain one workflow per job |
| Make | Both ways, one scenario for each | Watching for new Shopify orders, or Airtable's Watch records on a view | Visual workflows, such as Shopify orders into Airtable records | Watch records needs a Created Time or Last Modified Time field. You build and maintain each scenario |
Airtable and Shopify: the old way vs. Letaido
- 1Filter yesterday's paid orders in Shopify
- 2Export them as a CSV
- 3Open the Orders table in Airtable
- 4Import the CSV and map the fields
- 5Delete orders you already had
Every morning at 7am, add yesterday's paid Shopify orders to the Orders table in our Store base in Airtable, one record per order: order number, date, customer, email, total, fulfillment status and shipping country. If an order is already in the table, update it instead of adding it twice.
Orders, tab Grid view
#2307, Oct 29, Ana Silva
#2308, Oct 29, Tom Reyes
Showing 4 of the 38 records. Order #2308 was already in the table, so it was updated, not added again.
How Airtable and Shopify jobs start
On a schedule
Saved as an automation, like these jobs: every morning at 7am, every Monday at 9am or every Monday at 8am. Neither app sends events to Letaido.
When you ask
Type it once in chat.
How to set up the Airtable Shopify integration
-
1Paste an Airtable access token
-
2Create a Shopify store app and paste its keys
-
3Approve the first Shopify run
Allow all read operations once per app; approve each kind of write once.
-
4Watch the first run in chat
-
5Pick a schedule
Every Airtable and Shopify action the agent can take
Airtable
10 groups: 8 reads, 11 writes
- Update and upsert records
- Delete records
- Admin and advanced
- 7 more
Find table · Create or update record · Find base by ID · Create base
Shopify
14 groups: 136 reads, 227 writes
- Manage discounts
- Manage inventory and stock transfers
- Admin and advanced
- 11 more
List returnable fulfillments · Add products to collection · Set shipment tracking · Set metafields
Frequently asked
Does Shopify integrate with Airtable? +
Yes. Sync apps from the Shopify App Store, like AirPower and SyncBase, mirror your store in Airtable, and Zapier or Make can link the two. Letaido runs jobs both ways: Leta logs orders and new products in Airtable, and publishes approved copy and partner codes to Shopify.
How do I connect Airtable and Shopify to Letaido? +
Paste an Airtable access token, then create a Shopify store app and paste its keys. After that, describe the job in chat, or paste a prompt from a job on this page.
Can it send Shopify orders to Airtable? +
Yes. Every morning, Leta can add yesterday's paid Shopify orders to your Airtable Orders table, one record per order. Records are matched on Order, so an order is never added twice. Customer names and emails need customer data turned on for your Shopify app (Custom distribution).
Can I update Shopify products from Airtable? +
Yes. When you ask, Leta publishes approved titles, descriptions, SEO fields and tags from your Airtable Product copy table to Shopify, then marks each record Published. Prices, variants, stock and product status don't change.
Is it a live two way sync? +
No. Neither Airtable nor Shopify sends events to Letaido, so a change in either app can't start a job. Jobs run on a schedule, such as every morning at 7am, or when you ask.
How is Letaido different from a sync app like AirPower or SyncBase? +
Sync apps mirror your store in Airtable both ways and charge their own monthly plan. Letaido runs jobs with a judgement step, like creating partner discount codes from approved records and writing each partner code's orders and order value back every Monday.
Will it ask before it changes my store or my base? +
Yes. Allow all read operations once per app; approve each kind of write once.
Put Airtable and Shopify to work today
Connect Airtable and Shopify, then ask for a job like "Log yesterday's Shopify orders in Airtable every morning". Leta gets it done on your schedule, or the moment you ask.
Get Letaido