Configuring Seal Subscriptions Exports

Set up Seal exports to send subscription data into Google Sheets, BigQuery, or Excel.

Overview

After connecting Seal, use the Export Builder to create exports by data type. Each export can include one or more tabs — Subscriptions, Subscription Items, Billing Attempts, Invoices, Fulfillment Orders, or Subscription Rules — and writes to a single Google Sheets spreadsheet, BigQuery dataset, or Excel file.

Prerequisites

Seal Subscriptions connected (see Connecting Seal Subscriptions)
A Google Sheets, BigQuery, or Microsoft Excel destination configured

Create an export

Go to Export Builder and create a new export.
Select Seal Subscriptions as the source and choose your connected shop.
Select a destination (Google Sheets, BigQuery, or Excel).
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, Excel worksheet, or BigQuery table.

Subscriptions: subscription records with customer, shipping, billing address, payment metadata, delivery method, status, and intervals.
Subscription Items: line items on each subscription — product, variant, quantity, pricing, discounts, and selling plan.
Billing Attempts: scheduled and completed billing attempts, including status and error details.
Invoices: recurring-invoice rows nested under each subscription (flattened; includes a full JSON payload column).
Fulfillment Orders: prepaid fulfillment orders nested under each subscription (flattened; includes a full JSON payload column).
Subscription Rules: Seal subscription rules / selling plans linked to products and variants.

Enable only the tabs you need. Subscription-derived tabs are fetched together from Seal in one pass, then written separately for each enabled tab.

Available export fields

Use column selection in each tab to choose from the fields below.

Subscriptions

id internal_id status subscription_type email first_name last_name customer_id order_id order_placed currency total_value delivery_interval billing_interval billing_min_cycles billing_max_cycles cancelled_on paused_on shopify_graphql_subscription_contract_id card_brand card_expiry_month card_expiry_year card_last_digits delivery_method_title delivery_method_presentment_title delivery_method_code delivery_price delivery_price_discounted delivery_discount_id delivery_discount_title s_first_name s_last_name s_address1 s_address2 s_phone s_city s_zip s_province s_country s_company s_country_code s_province_code b_first_name b_last_name b_address1 b_address2 b_phone b_city b_zip b_province b_country b_company b_country_code b_province_code note admin_note note_attributes tags items_count billing_attempts_count invoices fulfillment_orders exportDate

Subscription Items

subscription_id subscription_status subscription_email item_id product_id variant_id title variant_sku quantity price original_price original_amount final_price final_amount total_discount discount_per_item discount_value discount_amount taxable requires_shipping is_one_time_item selling_plan_id selling_plan_name properties discount_codes cycle_discounts exportDate

Billing Attempts

subscription_id subscription_status subscription_email billing_attempt_id date completed_at status order_id error_code error_message triggered_manually customer_authentication_challenge_url exportDate

Invoices

subscription_id subscription_status subscription_email invoice_id date status order_id draft_order_id amount total currency url payload exportDate

Fulfillment Orders

subscription_id subscription_status subscription_email fulfillment_order_id date time timezone status order_id payload exportDate

Subscription Rules

id name options payment_type product_variants selling_plans exportDate

Date presets

Seal 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.
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 — wide historical window for initial loads.

Filter subscriptions by

Order placed date (default) — scans subscriptions and keeps those whose order_placed falls in the range.
Billing date — uses Seal’s subscriptions-by-billing-date API to return subscriptions that have at least one billing attempt in the range. Prefer this for large shops or upcoming-charge reporting.

Date range note: The filter applies to Subscriptions, Items, Billing Attempts, Invoices, and Fulfillment Orders. Subscription Rules always export in full (they are not date-filtered).

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 Subscriptions and Subscription Rules snapshot-style tabs.
Append: adds new rows to existing output without removing old rows. Useful for Billing Attempts 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.