Connect Shopify
OAuth connects to your Shopify store in seconds. No API keys, no developer credentials — airsource handles the secure handshake automatically.
Shopify + Google Sheets Integration
Real-time webhook sync. AI field mapping. Automated sales reports.
airsource connects Shopify to Google Sheets with one OAuth click. Claude AI maps your orders, customers, and products to the right columns. Your Sheet updates automatically.
How it works
OAuth connects to your Shopify store in seconds. No API keys, no developer credentials — airsource handles the secure handshake automatically.
Claude AI inspects your Shopify schema (orders, customers, products, inventory) and suggests optimal column mappings for your Google Sheet. Approve in one click.
Real-time webhooks push order updates instantly. 15-minute polling fills in the rest. Your sales report is always current without any manual work.
Use cases
See every order in Google Sheets as it comes in. Filter by product, SKU, customer region — without touching Shopify's reporting interface.
Sync multiple Shopify stores to separate Sheets. Share read-only links with clients for transparent real-time reporting.
Map Shopify inventory levels to a Google Sheet. Set up conditional formatting to flag low-stock products automatically.
Pull order and refund data into Sheets for monthly P&L reconciliation. No manual CSV exports — data flows in automatically.
Field mapping
Claude AI infers these mappings from your Shopify store schema. Review and adjust before the first sync.
| Shopify field | Google Sheets column | Format |
|---|---|---|
| order.name | Order ID | Plain text |
| order.email | Customer Email | Plain text |
| order.total_price | Total ($) | Number |
| order.financial_status | Payment Status | Plain text |
| order.fulfillment_status | Fulfillment | Plain text |
| order.created_at | Order Date | Date |
| line_item.title | Product Name | Plain text |
| line_item.quantity | Qty | Number |
| customer.first_name | First Name | Plain text |
| customer.last_name | Last Name | Plain text |
Real-time sync. AI mapping. $9/mo. Private beta — June 2026.