Automated Daily Task Scheduling Workflow

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.

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.

1. 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.