Configuring Etsy Exports

Set up Etsy exports to send your shop data into Google Sheets or BigQuery.

Overview

After connecting your Etsy shop, use the Export Builder to create exports by data type. Each export can include one or more tabs — Listings, Receipts, or Transactions — and writes to a single Google Sheets spreadsheet or BigQuery dataset.

Prerequisites

Etsy shop connected (see Connecting Your Etsy Shop)
A Google Sheets or BigQuery destination configured

Create an export

Go to Export Builder and create a new export.
Select Etsy as the source and choose your connected shop.
Select a destination (Google Sheets or BigQuery).
Give the export a name.
On the configuration page, choose a date range and select the data tabs and columns you want.
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.

Listings: your shop's product listings — title, price, quantity, state, URL, tags, and more.
Receipts (Orders): customer orders with buyer info, payment method, totals, and shipping address.
Transactions (Line Items): individual line items within orders — listing, quantity, price per item.

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

Available export fields

Listings

listing_id, title, description, price, currency_code, quantity, state, url, tags, materials, shipping_profile_id, shop_section_id, featured_rank, is_customizable, is_personalizable, is_digital, has_variations, should_auto_renew, language, views, creation_timestamp, last_modified_timestamp, exportDate

Receipts (Orders)

receipt_id, order_id, buyer_user_id, buyer_email, name, message_from_buyer, status, payment_method, currency_code, subtotal, total_shipping_cost, total_tax_cost, total_vat_cost, discount_amt, total_price, is_paid, is_shipped, gift_message, gift_wrap_price, shipping_name, first_line, second_line, city, state, zip, country_iso, create_timestamp, update_timestamp, exportDate

Transactions (Line Items)

transaction_id, receipt_id, listing_id, title, description, quantity, price, currency_code, seller_user_id, buyer_user_id, is_digital, create_timestamp, paid_timestamp, shipped_timestamp, exportDate

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 Receipts and Transactions exports.
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.

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.

Append vs replace

Replace: overwrites the tab output on every run. Best for Listings and snapshot-style tabs.
Append: adds new rows to existing output without removing old rows. Best for Receipts and Transactions 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.