Sync Squarespace Orders to Google Sheets Spreadsheet - n8n Workflow

• E-commerce store owners using Squarespace who need centralized data reporting.


• Data analysts requiring real-time order data synchronized in Google Sheets.


• Users looking for reliable, scheduled data replication using a robust n8n workflow.


• Developers or automators seeking practical n8n templates for API pagination.

Managing e-commerce data across different platforms can be challenging. This robust n8n workflow template solves the problem of manual data exports by establishing a direct, automated link between Squarespace and Google Sheets.

It utilizes the Squarespace API to fetch orders, handling complex requirements like dynamic pagination to ensure all historical and recent orders are captured. By using the 'append or update' functionality of the Google Sheets n8n node, the automation guarantees data integrity—it updates existing orders (matched by Order ID) and adds new ones. This specific n8n workflow is designed for maximum efficiency, whether you run it manually via the n8n trigger or on a regular schedule.

This automation follows a precise data retrieval and synchronization path:

1. Trigger: The n8n workflow is initiated either manually (by clicking 'Execute') or automatically via the scheduled n8n trigger.


2. Configuration (Globals): The Globals n8n node sets the API version and critical filtering parameters, such as modifiedAfter, modifiedBefore, and maxPage (allowing infinite pagination).


3. API Query: The Query Orders n8n node sends a paginated request to the Squarespace Commerce API. It iteratively fetches pages of orders, using the cursor from the previous response until all data is retrieved.


4. Item Separation: The Split Out Order n8n node takes the consolidated array of orders and separates them, ensuring each individual order becomes a single item for subsequent processing.


5. Data Synchronization: Finally, the Squarespace Orders Spreadsheet n8n node connects to Google Sheets. It performs an appendOrUpdate operation, using the 'Order ID' as the unique key to prevent duplication while ensuring the spreadsheet always reflects the latest order details, including billing/shipping addresses and fulfillment status. This highly effective n8n workflow keeps your data current.

To deploy this powerful n8n workflow template, follow these steps:

1. Import: Copy the provided JSON and import it into your n8n instance.


2. Credentials Setup:

1. Configure Globals: Open the Globals Set n8n node. Adjust the following parameters based on your requirements:

1. Target Spreadsheet: In the Squarespace Orders Spreadsheet n8n node, select the desired Google Sheet Document ID and the Sheet Name where the order data will be stored. Ensure the column headers in your sheet match the defined mapping in this n8n node (e.g., 'Order ID', 'Email', 'Total').


2. Activation: Set the n8n workflow to 'Active' to enable scheduled runs via the n8n trigger, or run it manually for testing.

On clicking 'execute' (n8n trigger): A manual execution n8n trigger used for development and ad-hoc runs.
Schedule Trigger (n8n trigger): Allows the n8n workflow to run automatically on a defined schedule (e.g., daily or hourly).
Globals (Set n8n node): Centralized configuration point. It injects variables like api-version, date filters (modifiedAfter/modifiedBefore), and maxPage into the workflow stream, controlling the behavior of the subsequent HTTP request.
Query Orders (HTTP Request n8n node): The core extraction component. It performs a GET request to the Squarespace Orders endpoint. Crucially, it handles automatic pagination, iterating through pages using the nextPageCursor until all data matching the filters defined in the Globals n8n node is fetched.
Split Out Order (Split Out n8n node): Prepares the data for bulk insertion. It splits the array of orders (result) into individual n8n items, ensuring each row is processed separately.
Squarespace Orders Spreadsheet (Google Sheets n8n node): The destination n8n node. Configured to appendOrUpdate data, using complex expressions to map deep JSON fields (like billing address components and totals) from the Squarespace payload directly into the corresponding Google Sheets columns, matching on 'Order ID'.