Keep Squarespace order data synced to Google Sheets on a schedule or on demand. Ideal for operations teams that need quick reports, fulfillment views, and daily snapshots without exporting files. Save time and reduce mistakes.

Runs by schedule or manual start, loads options from a Globals node, then calls the Squarespace Commerce Orders API. Filters like modifiedAfter, modifiedBefore, fulfillmentStatus, and cursor help pull only the data you need while paging through large histories. The Split Out Order node breaks the API result array into single records. Each record is written to a selected Google Sheet with append or update, mapping columns for Order ID, Email, Currency, Subtotal, Total, item counts, and timestamps.

Set api-version and filters in Globals, connect your Squarespace header token and Google Sheets account, and pick the sheet tab. Start with a short date range and confirm rows appear, then set maxPage to -1 and enable the scheduler for daily sync. Expect faster reporting, fewer copy paste errors, and one source of truth your team can trust.

• Manual and schedule triggers let you run on demand or at set times.
• Globals node controls api-version, date filters, fulfillmentStatus, and maxPage settings.
• HTTP Request pulls orders from the Squarespace Commerce Orders API with header authentication.
• Built in pagination follows nextPageCursor to fetch all pages when maxPage is -1.
• Split Out Order converts the API array into one order per item for clean row writing.
• Google Sheets append or update writes mapped fields like Order ID, Email, Currency, Subtotal, and Total.

• Reduce manual exports from 60 minutes to 5 minutes
• Cut spreadsheet prep time by 80% with direct sync
• Improve data accuracy by removing copy paste errors by up to 90%
• Handle 10 times more orders with automatic pagination
• Connect Squarespace and Google Sheets in one reliable flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Squarespace and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. Open the Google Sheets node and in the Credential to connect with dropdown click Create new credential. Follow the on screen steps to connect your Google account.
4. Open the Query Orders HTTP Request node and in the Credential to connect with dropdown click Create new credential. Choose HTTP Header Auth and follow the on screen steps to add your Squarespace API token from the official API page.
5. Open the Globals node. Set api-version to 1.0. Add optional filters: modifiedAfter, modifiedBefore, and fulfillmentStatus as needed. Set maxPage to -1 to fetch all pages or a positive number to limit requests.
6. In the Query Orders node, confirm the URL uses your api-version and that Send Query is enabled. Verify query parameters reference Globals fields for modifiedAfter, modifiedBefore, and cursor.
7. Open the Google Sheets node and select your spreadsheet and sheet tab. Make sure the document and sheet names match your target file.
8. Review column mappings. Ensure headers exist in your sheet for Order ID, Email, Currency, Subtotal, Total, and any other fields you mapped.
9. Configure the Schedule Trigger. Set the interval to the cadence you want, such as every 24 hours for a daily sync.
10. Test the flow. Run with the manual trigger and set a short date range in Globals to fetch a small sample. Check that new rows appear in your sheet with correct values.
11. Troubleshoot common issues: 401 or 403 usually means a bad or missing API token. Empty results often mean filters exclude data or a query parameter name is wrong. If you hit rate limits, reduce run frequency or lower maxPage.
12. Go live. Set the desired filters, keep maxPage at -1 if you want a full backfill, enable the scheduler, and monitor the first few runs in the n8n executions list.