Sync orders to Google Sheets or Airtable

Choose the destination

Use Google Sheets when you want a familiar live order table, selectable columns, and the derived Product Summary and Order Items tabs. Use Airtable when you want a structured one-way export with separate managed tables for forms, orders, items, payments, products, options, coupons, and shipping options.

EZFormz remains the source of truth for both integrations. Editing a row in Google Sheets or Airtable does not edit the order, payment, product, inventory, coupon, or form in EZFormz. Correct the source in EZFormz, then reconcile or sync again.

Both destinations can contain buyer details, order history, payment references, proof keys, addresses, and seller notes. Use a dedicated spreadsheet or base, grant access only to people who need it, and review destination sharing, automations, backups, and downstream exports.

Connect Google Sheets

1. As the form owner, create a dedicated spreadsheet and share it as Editor with ezformz-sheets@ezformz-integrations.iam.gserviceaccount.com. Google grants that role across the entire spreadsheet, not one tab or range.
2. Open the form in Dashboard, then open Settings → Integrations → Google Sheets.
3. Save the Sheet URL. EZFormz automatically makes hidden backup copies of the existing order tabs and updates an eligible connected workbook from saved orders. Other tabs are not directly edited, but formulas linked to order tabs may recalculate. No manual mode switch is needed.
4. EZFormz updates and checks the complete Orders, Product Summary, and Order Items data in the background, including orders placed before connection. Use saved orders for authoritative counts. Check access is only a read-only reachability check.

Saved changes request a new full mirror generation automatically. For variant totals, refresh, and older legacy connections, see Sync and reconcile orders with Google Sheets.

Connect Airtable

1. As the form owner, open Settings → Integrations → Airtable, choose Connect Airtable, and approve the requested Airtable access.
2. Select an authorized base, choose the managed tables, and select the automatic order and catalogue sync options.
3. Choose Create/repair & sync.

Setup creates missing EZFormz-managed tables and fields and starts the first bounded export slice. A large export can remain pending after that request; saved progress continues in later scheduled slices. Sync now requests a full managed-row repair and resumable backfill, including rows accidentally edited or deleted in Airtable.

EZFormz does not delete unrelated Airtable tables or fields. Deleted EZFormz records are retained in managed Airtable rows with Deleted At so the destination keeps an audit trail. See Export orders and catalogue data to Airtable for the exact managed schema and repair behavior.

Choose the correct P&L output

The optional P&L Product Cost, P&L Estimated Profit, and P&L Missing Cost Items columns in the standard order Sheet are compatibility columns and are off by default. They are not the same as dedicated P&L Sheets.

Dedicated P&L Sheets publish a validated financial report generation into separate P&L … tabs for one P&L-enabled form. Configure them from Profit & Loss → Reports after the form has a connected Google Sheet. See Export, preserve, schedule, or sync P&L.

Troubleshoot a destination

For managed Sheets, confirm the service account is an Editor, use Check access, then Refresh from orders if needed. An access check alone is not a data check. If the Sheet disagrees with saved orders, contact support; background delivery diagnostics are not shown as a verification banner.

For Airtable, confirm the base still appears under the connected authorization, the intended auto-sync switch is on, and the export is not disconnected. Choose Sync now to repair selected managed fields and rows. Temporary provider failures preserve completed checkpoints, so a later slice resumes instead of starting the whole export over.