Squarespace Collection Data Sync to Google Sheets - n8n Workflow

Squarespace site administrators and owners.
Digital marketers needing to track blog performance or event metadata.
Data analysts looking for clean, structured data exports from Squarespace.
Users seeking robust, scheduled n8n templates for data migration.

This specialized n8n workflow solves the common challenge of exporting large, paginated collections from a Squarespace website (such as blog posts or events) into a structured spreadsheet environment.

By leveraging the hidden JSON endpoint feature of Squarespace collections (?format=json), this powerful n8n workflow fetches all items, handles automatic pagination to retrieve thousands of records, and then meticulously formats and writes the data to a designated Google Sheet. This allows users to maintain a real-time backup, perform advanced filtering, or integrate their Squarespace data with other business intelligence tools without manual copy-pasting. Using this pre-built n8n template saves significant development time.

The process begins with an n8n trigger, which is configured either as a Schedule Trigger for recurrent operations or a Manual Trigger for immediate testing.

1. Initiate Collection Fetch: The workflow executes the Fetch Squarespace blog n8n node, which is a specialized HTTP Request node. This node targets the desired Squarespace collection URL (e.g., /blog) and appends the ?format=json query parameter. Crucially, this n8n node is configured to automatically handle pagination, continuously requesting subsequent pages using the nextPageOffset until all collection items are retrieved.


2. Isolate Items: Once all data is fetched, the Iterate the collection items n8n node (Split Out node) extracts the array of individual items found within the response's items field, preparing them for bulk insertion.


3. Data Synchronization: The final step uses the Squarespace collection Spreadsheet Google Sheets n8n node. This n8n node takes each individual collection item and performs an Append or Update operation, ensuring that new posts are added and existing ones (matched by id) are updated. It also formats date fields (addedOn, publishOn) into standard YYYY-MM-DD format before writing them to the spreadsheet.

To deploy this n8n workflow, follow these steps:

1. Import the JSON: Copy the provided JSON code and import it directly into your n8n instance using the 'Import from JSON' option.


2. Set up Credentials: You must configure two primary credentials:

1. Customize the Fetch Node: Locate the Fetch Squarespace blog n8n node (HTTP Request) and update the URL parameter to match your specific Squarespace site collection (e.g., https://yourdomain.com/events). Remember to keep the ?format=json configuration intact.


2. Configure Google Sheet: In the Squarespace collection Spreadsheet n8n node, select the target Google Sheet Document ID and the specific Sheet Name (tab) where the data will be written. It is highly recommended to clone the reference spreadsheet provided in the Sticky Note to ensure your column headers match the expected mapping.


3. Activate: Once credentials and node parameters are set, activate the n8n workflow and run a test execution using the Manual Trigger n8n node.

Schedule Trigger / When clicking ‘Test workflow’: These standard n8n trigger nodes initiate the execution flow. The Schedule Trigger allows for periodic updates (e.g., daily), making this a set-and-forget n8n workflow.
Fetch Squarespace blog (HTTP Request): This critical n8n node performs the data extraction. It is configured to use the format=json query parameter to access the hidden Squarespace API endpoint. It employs advanced pagination settings, using nextPageOffset to ensure all pages of the collection are fetched automatically before passing data to the next n8n node.
Iterate the collection items (Split Out): After fetching the complete collection response, this n8n node extracts the array contained within the items field, generating one output item for every blog post or event found, making the data ready for the Google Sheets n8n node.
Squarespace collection Spreadsheet (Google Sheets): This final n8n node handles data persistence. Its operation is set to Append or Update, using the collection id as the matching column. It maps key fields like title, tags, categories, fullUrl, and dates (using JavaScript expressions for proper formatting) to the spreadsheet columns.