How to Connect Shopify to Airtable
Learn how to import and sync data from Shopify into Airtable without writing code. Supports automated pagination, field auto-type inference, deduplicated upserts, and scheduled syncs.
Prerequisites
- An active Shopify account.
- Credentials / API Key:
Admin API Access Token. - DataSyncly installed in your Airtable Base.
Step-by-Step Setup Guide
1. Connect & Authenticate
- Open the DataSyncly extension in your Airtable Base.
- Search for Shopify and select your preset.
- Provide your
Admin API Access Tokenand click Test Connection.
2. Field Auto-Type Inference
- DataSyncly inspects incoming sample records and automatically detects Airtable field types (Dates, Numbers, URLs, Attachments, Checkboxes).
- Adjust or confirm mapped columns.
3. Pagination & Upsert Configuration
- Pagination: Handled automatically via
cursor. - Write Mode: Choose
Upsert (Update & Insert). - Unique Key: Set to
idto prevent duplicate entries and keep records updated.
4. Run & Schedule
- Click Run Sync to import records.
- Optionally toggle Automated Background Sync (e.g. Every 15 mins) or copy the unique Webhook URL.