Automate Your Team's Ticket Management with n8n and Linear
detail.loadingPreview
Effortlessly sync your team's Linear tickets to Google Sheets with this n8n workflow. Automate ticket collection and gain better visibility into your team's work.
About This Workflow
This n8n workflow is designed to streamline your project management by automatically pulling your team's tickets from Linear and organizing them in a Google Sheet. Running daily, it fetches all relevant tickets, including their identifier, URL, title, priority, creation and completion dates, state, cycle, estimate, and labels. The workflow handles pagination to ensure all tickets are captured and allows for customization of team names and default ticket values. It then seamlessly writes this data to a specified Google Sheet, providing a centralized and up-to-date view of your team's progress. This solution is ideal for teams looking to improve reporting, track progress, and gain deeper insights into their workload without manual data entry.
Key Features
- Daily Ticket Sync: Automatically fetches all your team's tickets every day at 9 AM.
- Comprehensive Data Extraction: Captures key ticket details like ID, URL, title, priority, status, cycle, estimate, and labels.
- Pagination Handling: Ensures that all tickets, even for large teams, are retrieved.
- Google Sheets Integration: Writes ticket data directly to your Google Sheets for easy analysis and reporting.
- Customizable: Easily adjust team names and default values for estimates and labels.
How To Use
- Connect Linear: Add your Linear API header key to the
n8n-nodes-base.graphqlnodes. - Configure Team Name: Update the
filterin the GraphQL nodes to specify your team's name (e.g., "Adore"). - Set Custom Fields: Adjust the
n8n-nodes-base.setnode to customize default estimates or labels as needed. - Google Sheets Setup: Connect your Google Sheets account and specify the target sheet and worksheet where you want to write the ticket data.
- Activate Workflow: Enable the n8n workflow to start the daily automated data synchronization.
Apps Used
Workflow JSON
{
"id": "f9cd3a74-55ed-4610-af2d-93b39af723ee",
"name": "Automate Your Team's Ticket Management with n8n and Linear",
"nodes": 28,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: f9cd3a74-55ed...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.