n8n Workflow: Write All Linear Tickets to Google Sheets

This n8n workflow automates the process of fetching all tickets from Linear and writing them into a Google Sheet. It's designed to provide a comprehensive, up-to-date record of your Linear tickets in a spreadsheet format, which can be useful for reporting, analysis, or backup.

What it does

This workflow performs the following key steps:

1. Triggers on a Schedule: The workflow is set to run periodically (e.g., daily, hourly) to ensure the Google Sheet is always updated with the latest Linear ticket data.
2. Fetches Linear Tickets: It uses the GraphQL node to query the Linear API and retrieve all tickets.
3. Processes Ticket Data: The Code node likely transforms or extracts relevant fields from the Linear ticket data.
4. Filters Data (Conditional Logic): The If node introduces conditional logic, potentially to filter tickets based on certain criteria (e.g., status, assignee, creation date).
5. Prepares Data for Google Sheets: The Edit Fields (Set) node is used to structure the data into a format suitable for Google Sheets, mapping Linear ticket fields to Google Sheet columns.
6. Splits Out Items: The Split Out node separates the processed data into individual items, ensuring each ticket is written as a distinct row in the Google Sheet.
7. Writes to Google Sheets: Finally, the Google Sheets node appends or updates the processed Linear ticket data into a specified Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Linear Account: Access to a Linear workspace and an API key for authentication with the GraphQL node.
• Google Account: A Google account with access to Google Sheets.
• Google Sheets Credential: An n8n credential for Google Sheets (OAuth2 or Service Account).

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Linear (GraphQL Node): Configure the GraphQL node with your Linear API key. You might need to set up a custom HTTP header for authorization, as GraphQL nodes often require this for API keys.
   • Google Sheets: Set up a Google Sheets credential in n8n.
3. Customize Google Sheets Node:
   • Specify the Spreadsheet ID and Sheet Name where you want the Linear tickets to be written.
   • Configure the Operation (e.g., Append Row, Update Row) and map the incoming data fields to your Google Sheet columns.
4. Adjust Schedule Trigger: Modify the Schedule Trigger node to set your desired frequency for the workflow execution (e.g., every day at a specific time).
5. Review and Customize Logic:
   • Examine the Code node to understand how Linear data is being transformed. Adjust it if you need different data points or formats.
   • Review the If node's conditions. If you only want to write specific types of Linear tickets, adjust the conditions accordingly.
   • Check the Edit Fields (Set) node to ensure the fields are correctly mapped for your Google Sheet.
6. Activate the Workflow: Once configured, activate the workflow to start automatically writing your Linear tickets to Google Sheets.