Daily sync of Linear tickets to Google Sheets

# Daily sync of Linear tickets to Google Sheets with record updates

This automation workflow eliminates manual ticket exports from Linear — every day at 9:00 AM it fetches all tickets for a specified team via GraphQL API, processes them (including pagination), and syncs the data to Google Sheets, updating or creating rows by unique ´id´. Ideal for product managers, tech leads, and project managers who need a reliable daily snapshot of tasks.

## Who it´s for
- Development teams using Linear for task management
- Project managers requiring daily ticket exports in spreadsheet format
- Teams automating reports from Linear to Google Sheets
- Product managers tracking priorities and task statuses

## What the automation does
- Triggers daily at 9:00 AM via cron_schedule
- Fetches all team tickets from Linear using GraphQL API
- Handles pagination: retrieves next pages if hasNextPage is true
- Splits ticket objects, enriches with estimate and labels, flattens fields
- Syncs data to Google Sheets using appendOrUpdate mode with ´id´ as key
- Updates existing rows or appends new ones

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on cron_schedule
- Integrations with Linear (GraphQL API) and Google Sheets (Google Sheets API)
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n account with workflow creation access
- Linear API key with read permissions for tickets
- Google Account with edit access to target Google Sheet
- Team name (e.g., ´Adore´) configured in workflow parameters

## Benefits and outcomes
- Saves time by eliminating manual export from Linear
- Ensures up-to-date task data every morning
- Centralizes tasks with enriched fields (estimate, labels)
- Enables performance analysis using createdAt and completedAt timestamps
- Supports large datasets through proper pagination handling
- Reduces duplication errors with id-based row matching

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat