Skip to content
ClickRuntime

Connect Google Sheets to Linear

Many teams keep the list of things to watch in a sheet: domains, pages, data sources. When a check against that list finds a problem, it belongs in Linear as an issue someone owns. Connecting the two turns a shared list into tracked work.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Linear

Checks that run against the rows in your sheet and open Linear issues when something needs fixing. These are ready-made starting points. Anything else you can describe works too.
Daily

Get a Linear issue before an SSL certificate expires

Each morning the domains in your sheet are checked, and any certificate expiring within 30 days gets one Linear issue and a Slack message.

See how it works
DailyAI

Catch visual changes on your key pages every day

Each page in your sheet is compared with how it looked before, and real visual changes become Linear issues for your team.

See how it works
Weekly

Score your product sheet for missing data every week

Every Monday you get an email scorecard of how complete your product sheet is, and a Linear issue for each product with gaps.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and Linear, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and Linear automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Linear in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

At the end of each Linear cycle, add a row to my Velocity sheet with completed issues, points and scope added mid-cycle for each team.

When a row is added to my Feedback sheet, have AI check if a similar Linear issue already exists and either comment on it or create a new one.

Use cases

Why people connect Google Sheets and Linear

How the two apps work together

  • The automation checks the sheet every few minutes for new or changed rows.
  • Matching rows become Linear issues through the Linear API, and the issue identifier and URL go back into the row.
  • Linear webhooks or a scheduled query update rows when issues change state.

  • Backlog import from a spreadsheet

    Teams moving to Linear import a backlog sheet with title, description, priority and team columns. Each row becomes an issue and the identifier is written back.

  • Reporting for non-engineering teams

    Operations and finance get a sheet of completed Linear issues with estimates, cycle and assignee. They build their own charts from it.

  • Customer request tracker

    Customer success managers log feature requests in a sheet with account and revenue columns. Requests above a threshold become Linear issues.

  • Cycle velocity history

    Engineering managers record completed points per cycle in a sheet. Over time it shows whether planning matches delivery.

More apps

Google Sheets, Linear and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Sheet requests to Linear with Slack notice

When a row in my Requests sheet is marked Approved, create a Linear issue and post the link in #product.

Feature requests weighted by HubSpot deals

For each request in my sheet, add the total open HubSpot deal value for that company, and create a Linear issue when it passes $50,000.

Typeform bug reports to sheet and Linear

When a Typeform bug report comes in, add it to my Bugs sheet and create a Linear issue in the Support team.

Setup

Connect Google Sheets and Linear once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

Linear

Issue tracking

  1. In Linear, open Settings, Account, Security & access.
  2. Create a personal API key and copy it.
  3. In the ClickRuntime dashboard, open Connections & secrets and save the key as a secret for Linear.

FAQ

Questions about connecting Google Sheets and Linear

Do I need a special sheet layout?
No. You point the automation at the tab and columns you already use, such as a column of URLs or domains. A header row is fine.
Will it open the same issue twice?
No. It remembers which problems it has already raised, and only opens a new issue when something new goes wrong.
Can I add or remove items without changing the automation?
Yes. It reads the sheet on every run, so adding a row is enough to start checking it.
How do I connect Linear?
With a Linear API key saved as a secret in your ClickRuntime dashboard. Google Sheets is connected through your own Google account.
Can it update existing Linear issues from the sheet?
Yes. If the row holds the issue identifier, the script can update fields like priority, state or assignee.
Does Linear send updates back to the sheet?
It can. Linear webhooks reach a trigger link and the script updates the matching row.
Which Linear teams can it use?
Any team your Linear connection can access. The team can be fixed or taken from a sheet column.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Linear should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude