Sync Linear Tickets to Google Sheets Daily

This n8n workflow automates the daily export of Linear tickets to Google Sheets, enabling teams to track issues, priorities, states, cycles, estimates, and labels without relying on Linear's paid Insights features. It uses a scheduled trigger to run every day at 9 AM, queries the Linear GraphQL API for tickets filtered by team (e.g., 'Adore'), handles pagination with hasNextPage and endCursor, and maps data automatically to a Google Sheet. Users simply add one 'id' column, and the workflow populates the rest.

Benefits include cost savings on premium Linear plans, seamless integration for custom dashboards or BI tools like Google Data Studio, and flexibility to add custom fields or transformations in n8n. Ideal for development teams needing historical ticket data for reporting, velocity tracking, or backlog analysis outside Linear's ecosystem.

Setup is straightforward: configure Linear API header auth, Google Sheets credentials, update team filters in GraphQL variables, specify the sheet and tab, customize data fields if needed, and activate. The workflow supports multiple teams by duplicating or adjusting GraphQL nodes, making it scalable for larger organizations.