How to Sync Linear to Google Sheets Issue Reporting?
Description
Pull your team’s issues from Linear into Google Sheets every morning. Leaders get a simple sheet they can sort and filter for standups, sprint planning, and status reports. No more manual exports.
A daily schedule starts the run, then a GraphQL request gets issues for a chosen team. The flow checks for more pages and loops with the end cursor until all issues are loaded. Items are split into single rows, labels are turned into a clean comma list, and a default estimate of 1 fills any missing values. A small code step flattens nested fields so columns are simple. Finally, the Google Sheets node writes the data with automatic mapping, so you only need the id column in the sheet.
Set up needs a Linear API key and Google Sheets OAuth. Update the team name in both GraphQL nodes, pick your spreadsheet and tab, and confirm the schedule time. Expect faster reporting, fewer errors, and a ready-to-use sheet for backlog review and ops reporting. Ideal for product managers, engineering leads, and operations teams that want a daily, reliable source of truth.
Tools Required
What this workflow does?
- Daily schedule at a set time to refresh the sheet without manual work
- GraphQL query filters issues by team name for focused reporting
- Cursor based pagination uses hasNextPage and endCursor to fetch all pages
- Split array of issues into single rows for clean sheet output
- Set default estimate to 1 and turn labels into a simple comma list
- Code step flattens nested fields so columns are easy to filter and sort
- Google Sheets automatic mapping adds columns based on incoming fields
- Simple team filter updates in both GraphQL nodes to switch data sources
What are the benefits?
- Reduce manual export work from 30 minutes to 2 minutes each day
- Improve data accuracy by removing copy and paste errors by up to 95 percent
- Handle large backlogs with cursor paging so volume does not slow reporting
- Connect Linear and Google Sheets so teams can work in tools they know
- Create a consistent daily report that supports standups and planning
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with Linear and Google Sheets. See the Tools Required section above for links to create accounts with these services.
- Create a Linear API key in your Linear account under API settings. Keep it secure.
- In n8n, open the GraphQL nodes and in the 'Credential to connect with' dropdown, click 'Create new credential' and choose HTTP Header Auth. Add a header named Authorization with your Linear API key as the value, then save.
- Open both GraphQL nodes and update the variables to use your team name in the filter. Keep the endpoint as https://api.linear.app/graphql.
- Run the first GraphQL node once to confirm you see data with issues, pageInfo, and nodes in the output.
- In the n8n credentials manager, create a new Google Sheets OAuth2 credential. Follow the on screen steps to sign in and allow access. Give the credential a clear name.
- Create or select a Google Sheet and add one header column named id on the target tab.
- Open the Google Sheets node and select your Google account, spreadsheet, and sheet tab. Turn on automatic mapping so fields create columns as they appear.
- Review the Set node to adjust custom values like default estimate or label formatting if needed.
- Check the Schedule Trigger node and set the time that fits your timezone and reporting needs.
- Execute the workflow once manually to populate the sheet. Confirm rows were added and columns match the fields you expect.
- If no rows appear, ensure the sheet is owned or shared with the Google account you connected, and verify the Split Out node points to data.issues.nodes.
- If only the first page loads, check the If node condition and the end cursor path in the Set node. The loop should run until hasNextPage is false.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
