Skip to content
ClickRuntime

Connect Google Sheets to Notion

Sheets are handy for raw data and quick lists, while Notion is where teams plan and write. Connect them to move rows into Notion databases as they arrive, publish summaries of your sheet data as Notion pages, and keep both in step.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Notion

Rows turned into Notion pages and records, and Notion reports built from your sheet data. These are ready-made starting points. Anything else you can describe works too.
Every 15 minutesAI

Score new applicants in a sheet and add them to Notion

Each candidate added to your applicants sheet is scored for the role and gets a card on your Notion hiring board.

See how it works
The moment it happens

Log voice agent call transcripts in Sheets and Notion

Each call your voice agent finishes is added as a row in your calls sheet and as a Notion page with the full transcript.

See how it works
Every 30 minutesAI

Score new leads from a sheet and add good ones to Notion

New leads in your sheet are scored against your ideal customer profile, and those above 70 become Notion CRM pages with a draft first message.

See how it works
DailyAI

Log news from your feeds to a sheet with a daily Notion report

Each day, new items from your RSS feeds are categorised and summarised by AI, added to a sheet and collected into a report page in Notion.

See how it works
WeeklyAI

Turn this week's saved links into a newsletter draft in Notion

Every Friday, the links you collected in your sheet become a newsletter draft page in Notion, ready to edit.

See how it works
WeeklyAI

Publish a weekly analysis of your sheet data in Notion

Every Monday last week's rows in your sheet are analysed and a report page with findings and likely causes is published in Notion.

See how it works
Daily

Copy yesterday's metrics from a sheet into a Notion daily report

Each morning, yesterday's campaign totals are added up from your metrics sheet and saved as an entry in your Notion daily-report database.

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 Notion, 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 Notion automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Notion 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

Copy rows from my sheet to Notion only when the Status column says Ready and the Budget column is over 1000, and write the Notion page link back into the row.

Every night, compare my Notion projects database with the Projects sheet and add a row to a Changes tab for any project whose status or owner changed.

Use cases

Why people connect Google Sheets and Notion

How the two apps work together

  • ClickRuntime checks the Google Sheet every few minutes for new or changed rows and creates or updates Notion pages.
  • On a schedule, it can read a Notion database and write the current values back to a sheet tab.
  • A key column, such as an ID or email, is used to match rows to pages so updates do not create duplicates.

  • Move form or import data into Notion

    Ops teams collect data in a Google Sheet from forms or exports. New rows can become Notion database pages so the team works on them where tasks live.

  • Report on Notion projects in a sheet

    Managers want charts and pivot tables on project status. A scheduled export of a Notion database into Google Sheets gives them numbers without manual copying.

  • Content calendar planning

    Marketing teams plan posts in a sheet and track production in Notion. Rows marked Approved can be created as Notion pages with title, channel and publish date.

  • Client list shared with non-Notion users

    Agencies keep a client database in Notion but finance uses Sheets. A nightly copy of selected properties keeps finance's sheet current.

More apps

Google Sheets, Notion 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.

New Notion pages from Sheets with Slack summary

When new rows are added to our Leads sheet, create pages in the Notion CRM database and post a daily count with names in #sales on Slack.

Form answers to a sheet, then Notion

Take new Google Forms responses from the linked sheet and create a Notion page for each one with the answers as properties.

Email owners about overdue tasks

Each morning, read the Notion tasks database, write overdue tasks to a Google Sheet tab, and email each owner their overdue list through Gmail.

Setup

Connect Google Sheets and Notion 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.

Notion

Productivity / Docs

  1. In Notion, open the developer portal at notion.so/profile/integrations and create a new internal integration.
  2. On its Configuration tab, copy the integration secret.
  3. On each page or database the automation should use, open ••• → Add connections and pick your integration.
  4. In the ClickRuntime dashboard, open Connections & secrets and save the secret as a secret for Notion.

FAQ

Questions about connecting Google Sheets and Notion

Does it keep the sheet and Notion in sync both ways?
Most of these automations move data one way, from the sheet to Notion or the reverse. Two-way sync is possible, but one source of truth per field avoids conflicts.
How does it match columns to Notion properties?
Each column is mapped to a property by name, such as Email to an email property and Stage to a select. Columns without a match are left out.
Which Notion databases can it use?
Only the ones shared with your Notion connection, from the database's ••• menu under Connections.
Will rows be added to Notion twice?
No. Rows already copied are remembered, or marked in a status column, so each is added once.
What happens to rows that existed before I started?
You choose. The script can import all existing rows once, or record the current last row and only handle new ones.
Can it handle sheets with several tabs?
Yes. You tell the assistant which tab to read or write, and it can use more than one.
Can Notion relations and rollups be copied?
Relations can be set if the script can find the related page, for example by name. Rollups and formulas are calculated by Notion and can be read but not written.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Notion should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude