Schedule Trigger Automate

Automated workflow for scheduling daily tasks at 6:00 AM on platform n8n, seamlessly retrieving and organizing your team's tickets from GraphQL into Google Sheets. Enhance productivity by ensuring timely updates and easy access to ticket information, while simplifying data management with custom fields and automation.

7/8/2025
14 nodes
Complex
schedulecomplexschedule triggergraphqlsticky notesplitoutgooglesheetsautomationadvancedcronlogicconditional
Categories:
Schedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
Schedule TriggerGraphqlSticky NoteSplitOutGoogleSheets

Target Audience

This workflow is ideal for:
- Project Managers: Who need to track team tickets efficiently.
- Team Leads: Seeking to automate ticket retrieval from Linear.
- Developers: Who want to integrate ticket data into Google Sheets for reporting.
- Data Analysts: Looking to analyze ticket data without manual entry.
- Small to Medium Enterprises (SMEs): That manage multiple projects and require streamlined processes.

Problem Solved

This workflow addresses the challenge of manually tracking and managing team tickets across different platforms. It automates the retrieval of tickets from Linear based on specific team filters and writes them directly into Google Sheets, thereby saving time and reducing the risk of human error.

Workflow Steps

  • Trigger: The workflow runs daily at 06:00 AM to ensure timely updates.
    2. Get Tickets: It fetches all tickets for the specified team, in this case, Adore, from the Linear API.
    3. Pagination Handling: If there are more than 100 tickets, it checks for additional pages and retrieves them until all tickets are collected.
    4. Data Processing: Each ticket's details are split and processed to extract relevant fields, such as estimate and labels.
    5. Flattening Data: The ticket data is flattened to simplify the structure for easier filtering.
    6. Write to Google Sheets: Finally, the processed ticket data is appended or updated in a specified Google Sheets document, allowing for easy access and analysis.

    • Customization Guide

  • Team Name: Update the team name in the GraphQL query to match your specific team.
    2. Google Sheets Integration: Modify the Google Sheets document ID and sheet name to direct the output to your desired location.
    3. Custom Fields: Adjust any custom fields in the 'Set custom fields' node to match your project requirements, such as changing the default estimate value or adding additional labels.
    4. Schedule Timing: Change the trigger time in the 'Every day at 06:00' node to fit your preferred schedule.
    5. Additional Filters: Enhance the GraphQL query with more filters as necessary to refine the ticket data retrieved.