Sync All Squarespace Orders to Google Sheets

This n8n workflow efficiently retrieves all orders from Squarespace using the Commerce API, handling pagination to collect every order without missing data. It supports dynamic filtering by modification dates, fulfillment status (PENDING, FULFILLED, CANCELED), and cursor-based pagination. Data is then inserted into a Google Sheets spreadsheet, making it ideal for inventory tracking, sales reporting, and ERP integration.

Key benefits include time-saving automation that eliminates manual exports, real-time or scheduled syncing to keep sheets updated, and customizable parameters via a Global node for flexible querying. Users can set date ranges (modifiedAfter, modifiedBefore), limit pages, or fetch everything with maxPage=-1.

Use cases span e-commerce operations like monitoring order fulfillment, analyzing sales trends in Sheets, integrating with other tools for logistics or accounting, and scaling for high-volume stores. Requires Squarespace API key and Google Sheets credentials; perfect for businesses migrating data or building dashboards.

The workflow runs on-demand or scheduled, ensuring compliance with API limits while providing a robust foundation for advanced analytics.