Get all orders in Squarespace to Google Sheets

This workflow retrieves all Squarespace Orders and saves them into a Google Sheets spreadsheet using the Squarespace Commerce API. It uses pagination to ensure all orders are collected efficiently.

How It Works

• The workflow queries your Squarespace Orders API.
• It fetches data in paginated batches and inserts them into Google Sheets.
• The Global node is used to configure API parameters dynamically, allowing users to set date filters, pagination, and fulfillment status.
• The workflow runs on demand or on a schedule, ensuring your data stays up to date.

Parameters

This workflow allows you to customize the API request using the Global node settings:

• api-version (string, required) – The current API version (see Squarespace Orders API documentation).
• modifiedAfter={a-datetime} (string, conditional) – Fetch orders modified after a specific date (ISO 8601 format).
• modifiedBefore={b-datetime} (string, conditional) – Fetch orders modified before a specific date (ISO 8601 format).
• cursor={c} (string, conditional) – Used for pagination, cannot be combined with other filters.
• fulfillmentStatus={status} (optional, enum) – Filter by fulfillment status: PENDING, FULFILLED, or CANCELED.
• maxPage – Set -1 to enables infinite pagination to fetch all available orders.

Requirements

Credentials

To use this workflow, you need:

• Squarespace API Key – Retrieve from your Squarespace settings.
• Google Sheets API credentials – Required to insert data into a spreadsheet.

Google Sheets Setup

• Use the Squarespace order export feature to create a reference sheet.
• Google Sheets template is available

Who Is This For?

This workflow is designed for:

• Squarespace store owners exporting orders for tax reports, analytics, or sales tracking.
• Businesses automating order data retrieval for external reporting.
• Anyone needing an efficient way to extract Squarespace order data without manual effort.

Explore More Templates

• Get all orders in Shopify to Google Sheets
• Sync Shopify customers to Google Sheets + Squarespace compatible csv

👉 Check out my other n8n templates