Get all orders in Squarespace to Google Sheets

Description

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