This n8n workflow automates the process of retrieving and exporting tickets from a team management system, specifically Linear, into Google Sheets on a daily basis. The workflow is scheduled to run every day at 6 AM, ensuring that your team’s ticket data is consistently updated without manual intervention.
The process begins with a schedule trigger that initiates the workflow at the specified time. It then prompts users with sticky notes to set their team name in the filter (defaulted here as ‘Adore’). The primary node among these is the GraphQL query which fetches tickets associated with the specified team from the Linear API. The workflow intelligently handles pagination by checking if there are additional pages of data using the ‘hasNextPage’ property. If more tickets exist, it retrieves subsequent pages using the ‘endCursor’ to load all tickets.
Tickets are then split into individual items using the ‘Split Out’ node. Before writing to Google Sheets, each ticket is processed to set custom fields such as labels and default estimates through a ‘Set’ node and a JavaScript code node that flattens nested objects. The final step appends or updates these tickets in a designated Google Sheets document, making it easy to maintain an organized and up-to-date ticket repository.
This workflow is particularly useful for project managers, team leads, or support staff who need to keep a real-time, organized record of tickets for reporting, analysis, or workflow management.
Reviews
There are no reviews yet.