Configuring Etsy Exports

Set up Etsy exports to send your shop data into Google Sheets or BigQuery. Use the data reference when you need every field spelled out.

Overview

After connecting your Etsy shop, use the Export Builder to create exports by data type. Tabs are grouped into Date range and Full snapshot (same pattern as Shopify). Each export writes to a single Google Sheets spreadsheet or BigQuery dataset.

Prerequisites

Create an export

  1. Go to Export Builder and create a new export.
  2. Select Etsy as the source and choose your connected shop.
  3. Select a destination (Google Sheets or BigQuery).
  4. Give the export a name.
  5. On the configuration page, choose a date range and select the data tabs and columns you want.
  6. Save the export and run it manually to validate the output.

Available data tabs

Each tab writes to its own sheet tab or BigQuery table.

  • Date range — Receipts (Orders): customer orders with buyer info, payment method, totals, and shipping address.
  • Date range — Transactions (Line Items): individual line items within orders.
  • Date range — Ledger Entries: Etsy Payments account ledger (credits, fees, refunds, disbursements) with running balance.
  • Date range — Payments: order-level gross, fees, and net (plus refund adjustments). Linked through ledger entries; payments typically appear after an order ships.
  • Date range — Reviews: buyer transaction reviews (rating, text, listing, timestamps).
  • Date range — Shipments: carrier and tracking rows from order receipts.
  • Date range — Refunds: refund amount, reason, and note from issuer from order receipts.
  • Full snapshot — Listings: current shop listings (all states).
  • Full snapshot — Inventory: current variation SKUs, quantities, and prices (one API call per listing).

Enable only the tabs you need. Each enabled tab is fetched and written independently.

Full column lists and descriptions: Etsy data reference.

Date presets

Etsy exports support the same date range presets available in other exporters:

  • Since last export — incremental; uses the timestamp of the last successful run as the start point. Recommended for scheduled date-range tabs.
  • Today, Yesterday, Last 7 days, Last 30 days, etc. — fixed windows recalculated at run time.
  • This month / Last month / This quarter — calendar-aligned windows.
  • Maximum (2 years) — fetches up to two years of historical data. Use for initial data loads.
  • Custom range: pick exact From and To dates (maximum 1 year). Exports that fixed window; scheduled runs are paused until you switch back to a preset. Use Run now. The Listings tab still fetches all current listings regardless of this setting.

Listings tab note: The Listings tab always fetches all current listings regardless of the date range setting, since Etsy's listings API does not support date filtering. Use replace mode (not append) for the Listings tab.

Column selection

For each tab, use the column picker to select only the fields you need. Selecting fewer columns keeps your destination leaner and exports faster.

Add the Date Exported column (exportDate) to any tab to record the timestamp when each export ran — useful for tracking data freshness in dashboards.

Include by created or updated date

On Receipts, Transactions, Shipments, Refunds, and Payments you can control which records are fetched for the export date range. This is separate from append vs replace.

  • Created date (default): only new orders / newly posted payments in the date range.
  • Updated date: records that changed in the window (cancellations, shipping, refunds, payment adjustments). With append mode, each run adds a new row so you keep a history of changes. For Payments this uses receipt updates to reload payment rows that changed (matching the Payments Last Updated field).

Use Updated date with Since last export when you need refunds and other changes on older records to appear in incremental exports.

Append vs replace

  • Replace: overwrites the tab output on every run. Best for Listings, Inventory, and other snapshot tabs.
  • Append: adds new rows to existing output without removing old rows. Best for date-range tabs when combined with Since last export.

Editing an export

You can change date preset, selected columns, and append settings from the export detail page at any time. Changes take effect on the next run.

Scheduling

After validating a manual run, set up a schedule from the export detail page. Choose a frequency (daily, weekly, etc.) and a time of day. SyncRange will run the export automatically.

See Setting Export Schedules for full details.

Related Documentation

Something missing on this page? Email [email protected]

Start syncing your ecommerce data in minutes Start free today. No credit card required.