Developer & DevOps
Export blog and event collections to Google Sheets automatically
7 nodes
288
167
Scheduled trigger
Workflow Description
A scheduled automation template that retrieves blog and event collections from external sources and loads them into Google Sheets. It processes and organizes data, splitting entries by type, enabling continuous updates of content and event records for reporting and analytics purposes.
How it works
- 1.Trigger automation on schedule or manually
- 2.Call external API to fetch blog posts and events data
- 3.Parse and process the retrieved data
- 4.Split data by collection type (blog/events)
- 5.Append organized data to separate Google Sheets tabs
Use cases
- Maintain updated inventory of blog articles and upcoming events
- Create centralized dashboard for content and event analytics
- Automate data aggregation from multiple sources into single spreadsheet
Requirements
- Active Google account with Google Sheets access permission
- External API endpoint providing blog and event collection data
- Valid API credentials or authentication tokens for the data source
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Google Sheets
Details
Trigger
Scheduled trigger
Nodes
7
Apps
1
Views
288
Downloads
167
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (7)
Schedule Trigger
Schedule Trigger
When clicking ‘Test workflow’
Manual Trigger
Fetch Squarespace blog
HTTP Request
Sticky Note
Sticky Note
Iterate the collection items
Split Out
Squarespace collection Spreadsheet
Google Sheets
Sticky Note1
Sticky Note