Automate Squarespace Orders Export to Google Sheets with n8n

What This Workflow Does

This workflow gets all Squarespace orders and saves them to a Google Sheets spreadsheet automatically. It stops manual copying and pasting errors. You get updated order data in Google Sheets without extra work.

It fetches orders from Squarespace using the API, handles lots of pages if needed, breaks them into single orders, and then stores or updates each order in Google Sheets. You can run it by hand or set it to run on a schedule.

Who Should Use This Workflow

This workflow is for online stores on Squarespace that want to save time by automating order exports. It suits store owners who use Google Sheets to track sales but want to avoid errors and repetitiveness.

You don’t need to be a programmer. The workflow works well even if there are thousands of orders or updates.

Tools and Services Used

• Squarespace Commerce API: To get orders data like customer info, totals, and shipping.
• Google Sheets API: To save order details and update existing rows.
• n8n Platform: To run and automate the workflow with trigger nodes, HTTP request, and data nodes.

Workflow Inputs, Processing Steps, and Output

Inputs

• Squarespace API key with permissions to read Orders.
• Google Sheets OAuth credentials with edit rights on the target sheet.
• Optional filters: date range and fulfillment status to limit which orders to fetch.

Processing Steps

• Start by triggering the workflow manually or on a schedule.
• Load global variables like API version, date filters, and pagination cursor.
• Send HTTP requests to Squarespace API with API key and query filters.
• Automatically handle pagination to fetch all pages of orders.
• Split the received list of orders into single order entries.
• Match each order in Google Sheets by Order ID and append new or update existing rows.

Output

A Google Sheets document with a full, updated list of Squarespace orders. Each row contains detailed order data like customer email, addresses, totals, and shipping info.

Beginner Step-by-Step: How to Use This Workflow in n8n

1. Import the Workflow

1. Download the workflow file using the Download button on this page.
2. Open n8n editor and select “Import from File” from the menu.
3. Choose the downloaded file to add the workflow to n8n.

2. Configure Credentials

4. Go to the Squarespace API credentials section in n8n and enter your API key.
5. Confirm Google Sheets OAuth credentials are connected with editor rights for your spreadsheet.

3. Update Identifiers and Filters

6. Set your Google Sheet’s Document ID and Sheet GID in the Google Sheets node.
7. Adjust the Globals node with any date range or fulfillment status filters if needed.

4. Test the Workflow

8. Run the workflow manually by clicking the Manual Trigger node and pressing “Execute Workflow”.
9. Check your Google Sheet for correct new or updated orders.

5. Activate for Production

10. Enable the Schedule Trigger if you want automatic updating at set intervals.
11. Monitor executions in the n8n dashboard and fix any errors found.
12. You can export the workflow JSON for backup or version control if wanted.

Use self-host n8n options for more control or privacy of your data.

Customizations

• Change the modifiedAfter and modifiedBefore dates to control order date range.
• Add new fields to Google Sheets by expanding the mapped columns in the Google Sheets node.
• Set the fulfillment status filter to include only specific order states like “PENDING” or “FULFILLED”.
• Toggle triggers to switch between manual and scheduled runs as preferred.
• Use the maxPage variable to restrict the number of pages fetched during testing.

Troubleshooting

401 Unauthorized Error

Check if the Squarespace API key is set correctly in n8n credentials. Renew the key if revoked or missing.

No Orders in Google Sheets

Verify Google Sheets Document ID and Sheet GID. Confirm OAuth credentials have permission to edit the spreadsheet.

Pagination Stops Too Early

Make sure the cursor value is passed correctly and empties at start. Check pagination settings match Squarespace API format.

Pre-Production Checklist

• Confirm Squarespace API key is active and has proper rights.
• Verify Google Sheets OAuth credentials have editor access to the correct document and sheet.
• Run tests with small date filters to check order fetch and sheet updates.
• Match Google Sheet headers with node column mapping exactly.
• Backup existing Sheet data before importing large batches.
• Test pagination fetches all pages when maxPage is -1.

Summary of Benefits

✓ Saves hours of manual order entry weekly.
✓ Prevents errors like missing or duplicate orders.
✓ Keeps Google Sheets sales tracker current automatically.
✓ Handles thousands of orders with pagination.
✓ Allows flexible filtering by date and status.

→ Makes order data easy to analyze and report on.
→ Lets users choose manual or scheduled sync.
→ Improves accuracy and customer satisfaction by updating fulfillment records correctly.