📋 Write all Linear tickets to Google Sheets
⚡ 1,300 views · 📋 Project Management
Description
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.
Screenshot 20240229 at 12.20.05.png
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
Google Sheets, GraphQL, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File