Automate Your Team's Task Management with Linear and Google Sheets
detail.loadingPreview
Streamline your team's workflow by automatically syncing Linear tasks to Google Sheets. This n8n workflow ensures you have a daily, up-to-date overview of all your team's tickets, ready for analysis and reporting.
About This Workflow
This n8n workflow is designed to effortlessly pull your team's tickets from Linear and consolidate them into a Google Sheet. Scheduled to run daily at 9 AM, it fetches all relevant tickets associated with your specified team, including key details like identifier, URL, title, priority, creation date, completion status, cycle, estimate, and labels. The workflow intelligently handles pagination to ensure all your tasks are captured. It then processes these tickets, setting default values for estimates and extracting label names for easier organization in your spreadsheet. Finally, it writes all this valuable data to your designated Google Sheet, providing a centralized hub for your team's task management.
This automation saves valuable time and reduces manual data entry, allowing your team to focus on what matters most: getting work done. Whether for tracking progress, generating reports, or simply maintaining visibility, this workflow is an essential tool for efficient operations.
Key Features
- Automated Daily Sync: Automatically fetches your team's tasks every day at 9 AM.
- Comprehensive Data Extraction: Captures key ticket details including ID, URL, title, priority, dates, status, cycle, estimate, and labels.
- Intelligent Pagination: Ensures all your tasks are retrieved, even if there are more than 100.
- Customizable Team Filtering: Easily set your team's name to retrieve the correct tickets.
- Data Transformation: Processes ticket data, sets default estimates, and formats labels for Google Sheets.
- Seamless Google Sheets Integration: Writes all fetched data directly to your specified Google Sheet.
How To Use
- Connect Linear: Obtain your Linear API header key and add it to the
httpHeaderAuthcredentials in the GraphQL nodes. - Configure Team Name: In the "Get all your team's tickets" GraphQL node (and the "Get next page" node if applicable), update the
variablesparameter to include your team's name in thefilter. - Set Up Google Sheets: Add your Google Sheets credentials and specify the target spreadsheet and sheet name in the "Write tickets to Sheets" node.
- Map Columns (Optional but Recommended): While the "autoMapInputData" mode will attempt to map columns, it's recommended to review and explicitly define key columns like 'id' in the "Write tickets to Sheets" node for precise control.
- Customize Custom Fields: Adjust the "Set custom fields" node to modify default estimates or how labels are processed to match your specific needs.
- Activate Workflow: Enable the n8n workflow to start your automated task synchronization.
Apps Used
Workflow JSON
{
"id": "d2bf723b-a8e6-47dd-a584-d315945a0151",
"name": "Automate Your Team's Task Management with Linear and Google Sheets",
"nodes": 23,
"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: d2bf723b-a8e6...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
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.