Sign inStart your trial

01. IntegrationProductivityProductivity

Keep Notion in sync every time your Google Sheets data changes

Inbound: capture work where it happens

Rills proposes each Notion action before it runs, so you approve from your phone rather than chasing down unexpected changes. Every approval sharpens what the workflow does next.

02. Overview

Connect Google Sheets to Notion with an approval on every action

The google sheets notion integration on Rills is built for solopreneurs and small teams who track data in spreadsheets but do their project work inside Notion. When something changes in a sheet, a corresponding action fires in Notion: a new page, an updated property, a refreshed dashboard, or a brand-new database. No copy-pasting between tabs.

Rills runs the logic, proposes the exact action it plans to take, and then waits. You get a notification on your phone, review the proposed change, and swipe to approve or reject. Approvals never cost a credit, so you stay in control without worrying about runaway automation bills. Over time, the workflow learns from your decisions and gets better at anticipating what you actually want.

With google sheets to notion automation you can turn new rows into Notion pages the moment data lands, push row edits straight to the matching Notion page properties, and write updated metrics to a Notion dashboard whenever a key aggregate changes. To connect google sheets to notion at the project level, Rills can also spin up a fresh Notion database each time a new spreadsheet is created in your Drive.

03. Use cases

What Google Sheets can hand to Notion, with you in the loop

Turn new sheet rows into Notion pages instantly

Each time a new row is added to your spreadsheet, a matching Notion page is created with the row data mapped to the right properties. You end up with a live Notion record for every entry without any manual copying.

Build this workflow
04. Triggers and actions

Google Sheets triggers and Notion actions

  • GOOGLESHEETS_NEW_ROWS_TRIGGERCreate a page

    When new rows are added to a Google Sheet, automatically create corresponding Notion pages to maintain a synchronized record of each entry.

  • GOOGLESHEETS_SPREADSHEET_ROW_CHANGED_TRIGGERUpdate a page's properties

    When a specific row in Google Sheets is updated, automatically sync those changes to the corresponding Notion page's properties to keep data consistent.

  • GOOGLESHEETS_AGGREGATE_METRIC_CHANGED_TRIGGERUpdate a page's content as markdown

    When a key metric in Google Sheets changes (sum, count, average), automatically update a summary or dashboard page in Notion with the new metric value.

  • GOOGLESHEETS_NEW_SPREADSHEET_CREATED_TRIGGERCreate a database

    When a new spreadsheet is created in Google Sheets, automatically initialize a corresponding Notion database to establish a linked data structure.

Triggers from Google Sheets

  • GOOGLESHEETS_NEW_ROWS_TRIGGER

    Fires when new rows are added to a spreadsheet. Use this to automatically process, notify about, or sync new data entries.

  • GOOGLESHEETS_NEW_SPREADSHEET_CREATED_TRIGGER

    Fires when a new spreadsheet is created. Use this to automatically initialize new spreadsheets with templates, permissions, or integrations.

  • GOOGLESHEETS_AGGREGATE_METRIC_CHANGED_TRIGGER

    Fires when a calculation like sum, count, average, minimum, or maximum changes for a specific column. Use this to trigger alerts or workflows when key metrics shift.

  • GOOGLESHEETS_SPREADSHEET_ROW_CHANGED_TRIGGER

    Fires when a specific row's values change, or when a row you're tracking appears or disappears. Use this to monitor individual records and react to their updates.

  • GOOGLESHEETS_CELL_RANGE_VALUES_CHANGED_TRIGGER

    Fires when values change in a specified cell or range of cells. Use this to trigger actions whenever specific data points are updated.

  • GOOGLESHEETS_NEW_SHEET_ADDED_TRIGGER

    Fires when a new sheet or tab is added to a spreadsheet. Use this to automatically set up formatting, formulas, or data for newly created sheets.

  • GOOGLESHEETS_TABLE_QUERY_RESULT_CHANGED_TRIGGER

    Fires when rows are added, removed, or updated in a saved query's results. Use this to trigger workflows based on changes to query output from your data.

  • GOOGLESHEETS_WORKSHEET_NAMES_CHANGED_TRIGGER

    Fires when sheets are added, deleted, or renamed within a spreadsheet. Use this to keep external systems in sync with your spreadsheet structure.

View all 16 Google Sheets triggers

Actions in Notion

  • Retrieve a page

    Fetch a page's properties and metadata to access its structured data, timestamps, and configuration details without retrieving its full content.

  • Update a page's properties

    Update any property on a Notion page including title, status, tags, and custom fields to keep your database current. This lets you modify page metadata, change document states, or archive pages without recreating them.

  • Query a data source

    Search and retrieve specific pages from your Notion database using filters and sorting to find exactly what you need. Use this to build filtered reports, look up entries by criteria, or work through large datasets in manageable chunks.

  • Create a page

    Add a new page to Notion either as a child of an existing page or as a new database entry, with customizable properties and initial content. Use this to expand your Notion workspace with structured information that integrates with your existing pages and databases.

  • Update a page's content as markdown

    Update a page's content by providing markdown text, which Notion automatically converts into its native block format. This is ideal for bulk content updates or working with markdown-formatted content from other sources.

  • Create a database

    Set up a new structured database within Notion by defining properties like text fields, numbers, dates, and relationships. This lets you programmatically create organized data collections for your business without manual setup.

  • Revoke a token

    Invalidate an access token to prevent it from being used for future API requests, useful for disconnecting integrations or removing access when it's no longer needed.

  • Retrieve a user

    Fetch a specific user's profile information including their name, avatar, email, and account type to display user details or verify team member information.

View all 35 Notion actions
05. How approvals work

Every action waits for a tap.

  1. 01

    Workflow proposes

    When a Google Sheets event fires, the agent drafts the Notion action and pauses.

  2. 02

    You approve from your phone

    A push notification lands on your phone. Swipe to approve or reject in seconds.

  3. 03

    Action runs, then learns

    Confidence climbs each time you approve. Repeated approvals graduate to auto-execute.

Queue 3

Google Sheets → Notion
82

Turn new sheet rows into Notion pages instantly?

Trigger: New event in Google Sheets

Action: Run in Notion

Pause until you approve.

SWIPE → APPROVE
06. Setup

How to connect Google Sheets to Notion

  1. 01

    Start your free trial

    Go to Rills and create an account. No credit card is needed, and the 14-day trial gives you full access to build and test workflows.

  2. 02

    Connect your Google Sheets account

    In the Rills dashboard, authorize your Google account. Rills will be able to watch your spreadsheets for the triggers you choose, such as new rows or changed cells.

  3. 03

    Connect your Notion account

    Authorize your Notion workspace inside Rills. Select the pages and databases you want Rills to be able to write to so permissions are scoped correctly.

  4. 04

    Choose a trigger and a Notion action

    Pick a trigger, for example new rows added to a spreadsheet, then select 'Create a page' as the Notion action. Map your sheet columns to the Notion properties you want populated.

  5. 05

    Approve your first run from your phone

    Add a row to your sheet to fire the trigger. Rills will propose the new Notion page and send you a notification. Review the details and swipe to approve. The page appears in Notion only after you confirm.

07. FAQ

Common questions about connecting Google Sheets to Notion

How do I connect Google Sheets to Notion?

Start a free Rills trial, then authorize both your Google Sheets and Notion accounts inside the dashboard. Pick a trigger, choose a Notion action, and Rills guides you through field mapping. Your first workflow can be live in under ten minutes, with no code required.

How much does it cost to run Google Sheets to Notion automations?

Rills offers a free 14-day trial and no credit card is needed to start. Approvals and workflow logic are always free. You only pay a credit when a real action executes in Notion, so reviewing and rejecting a proposed change costs you nothing.

Can Rills create a Notion database automatically when I make a new spreadsheet?

Yes. The new-spreadsheet trigger detects when a fresh Google Sheets file is created in your Drive and tells Rills to initialize a corresponding Notion database. You approve the action from your phone before the database is created, so nothing appears in Notion without your sign-off.

Do I have to approve every single Notion action?

By default, yes, and that is the point: you see exactly what will change before it changes. If you trust a specific workflow after reviewing several runs, you can allow it to execute automatically. You stay in control of which workflows need approval and which can run hands-free.

What happens if I reject a proposed Notion action?

Rejecting an action cancels that specific run and logs your decision. Rills uses that feedback to refine future proposals, so the workflow gets more accurate over time. No partial changes are made to Notion, and your sheet data is left untouched.

Does the integration work with any Notion database, or only specific templates?

The integration works with any Notion database you own or have edit access to. During setup you map your Google Sheets columns to the Notion properties of your choice, so the workflow fits your existing structure rather than forcing you into a template.

08. Get started

Start with: Turn new sheet rows into Notion pages instantly

Free to try. Approvals are always free. You only pay when your workflows take real actions.