Write all Linear tickets to Google Sheets
Go to WorkflowDescription
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 columns.
Set any custom data on each ticket
Activate workflow 🚀
How to adjust this template
Set any custom fields you want to get out of this, that you can quickly do in n8n.
Nodes Used (3)
Code
n8n-nodes-base.code
Google Sheets
n8n-nodes-base.googleSheets
GraphQL
n8n-nodes-base.graphql