Write all Linear tickets to Google Sheets — n8n Workflow

Medium complexity⏰ Scheduled9 nodes🏷️ Project Management👁 1,194 viewsby Mutasem

Overview

Use Case Track all Linear tickets in Google sheets. Useful if you want to do some custom analysis but don't want to pay for Linear's Plus features (Linear Insights) or that it does not cover.

Setup Add Linear API header key Add Google sheets creds Update which teams to get tickets from in Graphql Nodes Update which Google Sheets page to write all the tickets to You only need to add one column, id, in the sheet. Google Sheets node in automatic mapping mode will handle adding the rest of the co

Nodes used

Google SheetsGraphQLCode

Workflow Preview

👇🏽 Set your team name here in the filter.
(Our team's name is Adore)
👈🏽 Set your team name here in the filter.
(Our team's name is Adore)
👇🏽 Adjust any custom fields. Here we set la
👨‍🎤 Setup
1. Add Linear API header key
2. Add Google sheets creds
3. Update which teams to get tickets from in Graphql No
4. Update which Google Sheets page to write all the tic
You
👆🏽 Update which Google sheet to write to
⚡
E
Every day at 06:00
Get all your team's tick…
I
if has next page
G
Get end cursor
Get next page
S
Split out the tickets
S
Set custom fields
Write tickets to Sheets
Flatten object to have s…
9 nodes10 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a scheduled trigger, running on a defined schedule.

  2. 2

    Process

    Data flows through 9 nodes, connecting code, googlesheets, graphql.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (9)

GO

Google Sheets

googleSheets

#1
GR

GraphQL

graphql

#2
CO

Code

code

#3

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded write-all-linear-tickets-to-google-sheets file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Write all Linear tickets to Google Sheets", "nodes": [...], ...}

Integrations

codegooglesheetsgraphqlifscheduletriggersetsplitout

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes9
Complexitymedium
Triggerscheduled
Views1,194
CategoryProject Management

Created by

Mutasem

Mutasem

@mutasem

Tags

codegooglesheetsgraphqlifscheduletriggersetsplitout
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →