Automate Google Sheets + Linear
The database every team already has open. Fast issue tracking that deserves fast automation. Put an agent between them and the hand-off stops being manual: it reads, decides, acts, and shows its work.
Report Assembler is a ready-made agent built around Google Sheets; point its last step at Linear to finish this hand-off.
Automations teams run
Unlike field-mapping automation, the step in the middle is an agent: it can summarise, classify, judge and draft, not merely copy values from Google Sheets into Linear.
When a row is added or edited in Google Sheets…
…an agent can create issues with full context in Linear — after reading the context and deciding it should.
When a sheet crosses a threshold in Google Sheets…
…an agent can update status and assignees in Linear — after reading the context and deciding it should.
When a schedule fires in Google Sheets…
…an agent can write cycle summaries in Linear — after reading the context and deciding it should.
When an issue is created in Linear…
…an agent can append and update rows in Google Sheets — with the reasoning recorded in the run’s receipt.
When a status changes in Linear…
…an agent can read ranges for reporting in Google Sheets — with the reasoning recorded in the run’s receipt.
When a cycle ends in Linear…
…an agent can maintain a rolling dashboard tab in Google Sheets — with the reasoning recorded in the run’s receipt.
Copy this Google Sheets → Linear workflow
Start with the google-sheets-api node and a custom-api call to api.linear.app. Configure the Google Sheets source payload, the agent input, and the Linear operation. The sequential template does not implement conditional writes or approval by itself.
This is a schema-checked starting point, not an end-to-end tested automation. Replace every CONFIGURE_ value, choose the operations you intend, connect credentials and map source outputs into later inputs. An edge orders steps; it does not supply a condition, an approval gate or a field mapping. Add and test those controls explicitly before any write. Cloud APIs and model providers may receive data. Keep the workflow inactive until tested with fixtures.
{
"id": "e599e86b-5b21-4b90-a31b-e2a77bed3d90",
"name": "Google Sheets → Linear",
"nodes": [
{
"id": "13d24ab4-5502-4a83-ac7b-4b759c6dc5ca",
"text": "Watch Google Sheets",
"x": 512,
"y": 144,
"isEditing": false,
"type": "google-sheets-new-row",
"icon": "connect",
"category": "trigger",
"isSelected": false,
"parameters": {
"spreadsheetId": "CONFIGURE_SPREADSHEETID",
"sheetName": "CONFIGURE_SHEETNAME"
},
"description": "Setup template for Google Sheets New Row. Listen for new rows added to a specified Google Sheet and trigger the workflow when a new row is detected. Configure credentials, inputs and output mapping before use.",
"error": null,
"isActive": false,
"output": null,
"outputs": {}
},
{
"id": "a0b04335-b6ac-4927-abf9-a0da9367840a",
"text": "Review source and draft",
"x": 512,
"y": 336,
"isEditing": false,
"type": "agnt-agent",
"icon": "connect",
"category": "action",
"isSelected": false,
"parameters": {
"agentId": "CONFIGURE_AGENTID",
"message": "Read the Google Sheets item. Decide whether it warrants action in Linear, and explain why.\nSource input: CONFIGURE_SOURCE_INPUT. Produce a reviewable draft only; do not take external actions."
},
"description": "Setup template for Agent Chat. Chat with an AI agent from your agent library. Select an agent and send messages to interact with it within your workflow. Configure credentials, inputs and output mapping before use.",
"error": null,
"isActive": false,
"output": null,
"outputs": {}
},
{
"id": "35cbc453-a66c-4635-ace6-e7d8c58311b6",
"text": "Call Linear",
"x": 512,
"y": 528,
"isEditing": false,
"type": "custom-api",
"icon": "connect",
"category": "action",
"isSelected": false,
"parameters": {
"url": "https://api.linear.app/graphql",
"method": "GET",
"authType": "None",
"query": "",
"headers": "{}"
},
"description": "Setup template for Custom API Request. This action node makes a custom API request to any endpoint with configurable method, headers, and authentication. Configure credentials, inputs and output mapping before use.",
"error": null,
"isActive": false,
"output": null,
"outputs": {}
}
],
"edges": [
{
"id": "cd38497e-a2bd-4578-a942-17ccbce909c4",
"start": {
"id": "13d24ab4-5502-4a83-ac7b-4b759c6dc5ca",
"type": "output"
},
"end": {
"id": "a0b04335-b6ac-4927-abf9-a0da9367840a",
"type": "input"
},
"startX": 800,
"startY": 168,
"endX": 512,
"endY": 360
},
{
"id": "3ac4bbdd-dc5f-4913-a303-3cd6d5587636",
"start": {
"id": "a0b04335-b6ac-4927-abf9-a0da9367840a",
"type": "output"
},
"end": {
"id": "35cbc453-a66c-4635-ace6-e7d8c58311b6",
"type": "input"
},
"startX": 800,
"startY": 360,
"endX": 512,
"endY": 552
}
],
"zoomLevel": 1,
"canvasOffsetX": 0,
"canvasOffsetY": 0,
"isTinyNodeMode": false
}Configure Google Sheets New Row
Listen for new rows added to a specified Google Sheet and trigger the workflow when a new row is detected.
- spreadsheetId — The ID of the Google Spreadsheet to monitor Current example:
CONFIGURE_SPREADSHEETID. - sheetName — The name of the sheet within the spreadsheet to monitor Current example:
CONFIGURE_SHEETNAME.
Configure Custom API Request
This action node makes a custom API request to any endpoint with configurable method, headers, and authentication.
- url — The URL of the API endpoint Current example:
https://api.linear.app/graphql. - method — The HTTP method for the request Current example:
GET. - authType — The type of authentication Current example:
None. - query — Query parameters for the request (e.g., 'key1=value1&key2=value2') Current example:
. - headers — Optional headers for the request. e.g., {"Content-Type": "application/json"} Current example:
{}.
Install Report Assembler
Report Assembler is a working agent built around Google Sheets. Install it, point its last step at Linear, and you have this hand-off without building it from an empty canvas.
Runs on your own machine · See what it does
Build it in AGNT
- Get AGNT Community Core. Free, local, no sign-up needed to run a workflow.
- Add both connections to the vault — Google Sheets takes one OAuth sign-in, Linear takes an API key pasted into the vault.
- Configure the nodes above, or start from a marketplace workflow and edit it. The agent in the middle is the part worth spending time on.
- Run it once with an approval gate in place. The receipt tells you what it read, what it concluded, and what it changed in Linear.
Google Sheets and Linear — common questions
Can I connect Google Sheets to Linear without writing code?
Yes. Google Sheets connects with one OAuth sign-in and Linear with an API key pasted into the vault, both from the local credential vault. You then describe the job in plain language — “when a row is added or edited, create issues with full context” — and the agent handles the rest.
How is this different from a field-mapping Google Sheets to Linear automation?
A field mapping copies values and breaks on the first record nobody anticipated. The middle step here reads the Google Sheets item in full and decides — whether it matters, how to summarise it, and what belongs in Linear. Deciding to do nothing is a valid outcome, which no mapping can express.
Does my Google Sheets and Linear data leave my machine?
AGNT Community Core is local-first, so there is no vendor middleman holding your Google Sheets or Linear tokens. The runtime talks directly to both services. Choose a local model and the content of what it reads never leaves the machine at all.
What does a Google Sheets and Linear run leave behind?
A receipt: what was read in Google Sheets, which tools ran with which arguments, what the agent concluded, and what it wrote to Linear. Anything consequential can sit behind an approval gate so a person signs off before it happens.
