Keep a live content log without copy and paste. This setup pulls blog posts from a Squarespace site and stores them in a Google Sheet on a schedule. It helps marketing teams track titles, tags, URLs, and publish dates for planning and reporting.

The flow starts with a schedule or a manual test. An HTTP Request reads the Squarespace blog feed with a JSON format and follows pagination to fetch every post. A Split Out node loops through the items. The Google Sheets step writes each post as a row and updates existing entries, using the post id and mapped fields like title, tags, urlId, and a clean date. The result is a searchable content list that stays current.

You need a Google Sheets account and a public Squarespace blog feed. Point the HTTP node to your blog URL with the format query. Map the sheet columns to the data fields. Expect faster reporting, fewer errors, and a single place for content reviews. Use it for content audits, tag cleanups, and editorial planning with less manual work.

• Schedule Trigger runs the sync at set times for hands free updates.
• Manual Trigger lets you test and verify the flow before going live.
• HTTP Request pulls the Squarespace blog feed with format set to JSON and uses next page offsets.
• Split Out iterates each post item so rows are created one by one.
• Google Sheets append or update writes rows and updates existing posts using the post id.
• Column mapping includes id, title, tags, urlId, and a clean ISO date for addedOn.
• Pagination options include a request interval to avoid rate issues.

• Reduce manual blog logging from 2 hours to 5 minutes each week
• Automate 90 percent of repetitive content tracking work
• Improve data accuracy by 95 percent with direct JSON reads
• Connect Squarespace and Google Sheets without custom code
• Handle large archives by following pagination across pages
• Keep reports current with scheduled syncs

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 Google Sheets and Squarespace. See the Tools Required section above for links to create accounts with these services.
3. Open the Google Sheets node in n8n. In the Credential to connect with dropdown, click Create new credential, choose Google Sheets OAuth2, and follow the on screen steps in n8n Cloud to grant access. Give the credential a clear name like Google Sheets Marketing.
4. In the same node, set the Document ID to your target spreadsheet and set the Sheet name. Create a sheet with headers id, title, tags, urlId, addedOn or copy a template with the same columns.
5. In the Google Sheets node, select the operation Append or Update. Set the key field to id so existing posts are updated and new ones are added.
6. Open the HTTP Request node. Replace the URL with your Squarespace blog URL, for example https://yourdomain.com/blog. Keep the query parameter format set to json.
7. Confirm the blog feed is public by visiting your blog URL with ?format=json in a browser. You should see JSON, not an HTML page.
8. Leave pagination enabled so the node uses the nextPageOffset value to fetch all posts. Keep the request interval as configured to avoid rate limits.
9. Review the Split Out node and make sure it splits the items field, which is where Squarespace returns the posts.
10. Map each Google Sheets column to the correct fields: id to post id, title to title, tags to a joined list, urlId to urlId, and addedOn to a formatted date as shown.
11. Set the Schedule Trigger to your preferred frequency such as hourly or daily. Save the workflow.
12. Run a test using the Manual Trigger. Check the spreadsheet for new rows and verify updates when you run it again. If you see 404 or HTML output, fix the blog URL or ensure the site feed is public. If rows do not update, recheck the key field and header names.