Automate Google Sheets + Notion
The database every team already has open. The team wiki agents can actually keep current. Put an agent between them and the hand-off stops being manual: it reads, decides, acts, and shows its work.
Competitive Watch already works across Google Sheets and Notion — free, and it runs on your machine.
Automations teams run
These are not field mappings. An agent reads the Google Sheets side, works out what it means, and only then decides what — if anything — should happen in Notion.
When a row is added or edited in Google Sheets…
…an agent can create and update pages in Notion — after reading the context and deciding it should.
When a sheet crosses a threshold in Google Sheets…
…an agent can write database rows in Notion — after reading the context and deciding it should.
When a schedule fires in Google Sheets…
…an agent can append meeting notes in Notion — after reading the context and deciding it should.
When a page is created or edited in Notion…
…an agent can append and update rows in Google Sheets — with the reasoning recorded in the run’s receipt.
When a database row changes in Notion…
…an agent can read ranges for reporting in Google Sheets — with the reasoning recorded in the run’s receipt.
When a status flips in Notion…
…an agent can maintain a rolling dashboard tab in Google Sheets — with the reasoning recorded in the run’s receipt.
The Google Sheets and Notion hand-off, setup template
Start with the google-sheets-api node and the notion-api node. Configure the Google Sheets source payload, the agent input, and the Notion 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": "5dbc1398-7080-4ea8-a1d8-355e10a230e0",
"name": "Google Sheets → Notion",
"nodes": [
{
"id": "97968a44-7b09-4cc0-af4e-1c94477fd21c",
"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": "268beac0-c028-49de-a859-b6bc5cde65a4",
"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 Notion, 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": "b1546be3-87e1-45e1-ae19-02282aaa760e",
"text": "Configure destination in Notion",
"x": 512,
"y": 528,
"isEditing": false,
"type": "notion-api",
"icon": "connect",
"category": "action",
"isSelected": false,
"parameters": {
"operation": "search",
"pageSize": 1,
"query": "CONFIGURE_QUERY",
"filterType": "all"
},
"description": "Setup template for Notion API. Interact with Notion - search, query databases, get pages, and create pages. Configure credentials, inputs and output mapping before use.",
"error": null,
"isActive": false,
"output": null,
"outputs": {}
}
],
"edges": [
{
"id": "be426f21-528e-4206-a09c-957520d09e94",
"start": {
"id": "97968a44-7b09-4cc0-af4e-1c94477fd21c",
"type": "output"
},
"end": {
"id": "268beac0-c028-49de-a859-b6bc5cde65a4",
"type": "input"
},
"startX": 800,
"startY": 168,
"endX": 512,
"endY": 360
},
{
"id": "29d4059b-4073-466b-aa93-c098eb5cd3a2",
"start": {
"id": "268beac0-c028-49de-a859-b6bc5cde65a4",
"type": "output"
},
"end": {
"id": "b1546be3-87e1-45e1-ae19-02282aaa760e",
"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 Notion API
Interact with Notion - search, query databases, get pages, and create pages.
- operation — Operation to perform Current example:
search. - query — Search query text Current example:
CONFIGURE_QUERY. - filterType — Filter results by type Current example:
all. - pageSize — Max results (default: 10-100) Current example:
1.
Install Competitive Watch
Competitive Watch already uses both Google Sheets and Notion, so installing it gives you this exact hand-off wired up — connected, editable, and running on your own machine.
Runs on your own machine · See what it does
Wiring Google Sheets to Notion
- Install AGNT — it runs on your own machine and needs no account to start.
- Authorise Notion (one OAuth sign-in) and Google Sheets (one OAuth sign-in). Nothing is stored anywhere but your disk.
- Describe the job in plain language, or paste the definition above; google-sheets-api does the reading and notion-api the writing.
- Gate anything you would not want done unattended, then let it run and read the first receipt end to end.
Google Sheets and Notion — common questions
Can I connect Google Sheets to Notion without writing code?
No code is required. Add both connections in the vault (Google Sheets uses one OAuth sign-in, Notion uses one OAuth sign-in), then either install a marketplace workflow for this pair or drag the two nodes onto the canvas and put an agent between them.
How is this different from a field-mapping Google Sheets to Notion automation?
Mapping tools move data; this reasons about it. Rather than copying a field into Notion, the agent can weigh what arrived from Google Sheets, classify it against criteria you wrote in prose, draft something new, and act only when it is warranted.
Does my Google Sheets and Notion data leave my machine?
Your credentials stay in a vault on your own disk rather than in someone else’s cloud. The only calls made are the ones the workflow needs: Google Sheets, Notion, and your chosen model provider — which can be a local one.
What does a Google Sheets and Notion run leave behind?
You get an auditable trail rather than a success flag. It shows the Google Sheets context the agent worked from, the judgment it made about meeting notes filed where they belong, and the exact change applied in Notion, with approvals attached where you required them.
