Developer & DevOps
Schedule GraphQL queries and update Google Sheets automatically
14 nodes
189
121
Scheduled trigger
Workflow Description
Automate periodic data collection from GraphQL APIs with direct writes to Google Sheets. The system executes queries on schedule, processes results through conditional logic, and distributes data across multiple rows without manual intervention or repetitive tasks.
How it works
- 1.Trigger automation based on predefined schedule intervals
- 2.Execute GraphQL query to retrieve data from external API
- 3.Apply conditional logic to filter and transform query results
- 4.Write processed data to Google Sheets rows in structured format
Use cases
- Sync customer or user data from external APIs to spreadsheets daily
- Automate report generation by pulling real-time metrics into Google Sheets
- Monitor API responses and log changes to audit trails for compliance
Requirements
- Valid GraphQL API endpoint and authentication credentials
- Edit permissions on target Google Sheets file
- Configured schedule trigger with appropriate frequency
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Graphql
Google Sheets
Details
Trigger
Scheduled trigger
Nodes
14
Apps
2
Views
189
Downloads
121
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 (14)
/
Every day at 06:00
Schedule Trigger
Get all your team's tickets
Graphql
Sticky Note1
Sticky Note
if has next page
If
Get end cursor
Set
Get next page
Graphql
Sticky Note
Sticky Note
Split out the tickets
Split Out
Sticky Note2
Sticky Note
Set custom fields
Set
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Write tickets to Sheets
Google Sheets
Flatten object to have simple fields to filter by
Code