Sign inStart your trial

01. IntegrationProductivityProductivity

Keep your Notion databases and Google Sheets in sync, automatically.

Inbound: capture work where it happens

Every proposed sheet change waits for your approval before anything is written. You stay in control without doing the data entry yourself.

02. Overview

Connect Notion to Google Sheets with an approval on every action

The notion google sheets integration on Rills keeps your spreadsheets up to date whenever something changes in Notion. Whether you run a content calendar, a client tracker, or a project database, every update in Notion can flow into Google Sheets as a new or updated row without any copy-paste.

Rills works by watching your Notion workspace for the triggers you choose, then proposing the matching Google Sheets action for you to review. Approvals and all the logic behind them are free. You only spend credits when an action actually writes to your sheet. Approve from your phone with a swipe, or let a trusted pattern auto-approve once you are confident in it.

With notion to google sheets automation you can log every new Notion page to a master spreadsheet, sync database record changes in real time, and track file uploads with a timestamped audit row. If you want to connect notion to google sheets without babysitting manual exports, this is the workflow for you.

03. Use cases

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

Sync Notion database updates to a Google Sheet

When a record in your Notion database is added or modified, the corresponding row in your Google Sheet is upserted to match. Your sheet stays current without any manual copy-paste between tools.

Build this workflow
04. Triggers and actions

Notion triggers and Google Sheets actions

  • databaseContentUpdatedUpsert Rows (Smart Update/Insert)

    When Notion database records are added or modified, automatically sync those changes into Google Sheets by upserting rows, keeping both systems in sync without manual data transfer.

  • pageCreatedAppend Values to Spreadsheet

    When a new page is created in Notion, automatically append a corresponding row to Google Sheets to maintain a master log of all pages and their metadata.

  • fileUploadCompletedAppend Values to Spreadsheet

    When a file upload completes in Notion, automatically log the upload event with metadata (filename, date, uploader) into a Google Sheets tracking sheet for audit and organization.

  • pagePropertiesUpdatedUpsert Rows (Smart Update/Insert)

    When Notion page properties change (status, due date, owner), automatically update or insert the corresponding row in Google Sheets to keep project tracking sheets current.

Triggers from Notion

  • pageContentUpdated

    Fires when a page's content blocks are changed

  • fileUploadCompleted

    Fires when a file finishes uploading successfully. Process, distribute, or organize the uploaded file automatically.

  • databaseSchemaUpdated

    Fires when the structure of a database changes, such as adding or removing fields. Detect schema changes and update systems that depend on the database.

  • databaseContentUpdated

    Fires when items in a database are added, updated, or removed

  • databaseCreated

    Fires when a new database is created in the workspace

  • dataSourceContentUpdated

    Fires when data in a connected external system changes. Keep your Notion workspace automatically synchronized with live data from outside sources.

  • pageCreated

    Fires when a new page is created in the workspace

  • commentCreated

    Fires when a new comment is posted on a page

View all 31 Notion triggers

Actions in Google Sheets

  • Find and Replace in Spreadsheet

    Quickly find and replace text, numbers, or formulas across your entire spreadsheet to fix errors, update information, or clean up data in bulk. This saves hours of manual cell-by-cell editing when you need to make consistent changes throughout your sheet.

  • Look up spreadsheet row

    Search for the first row in a Google Spreadsheet that exactly matches a specific value, automatically locating the data you need without manual scrolling. This helps you quickly find customer records, inventory items, or any specific information stored in your sheets.

  • Create a Google Sheet

    Creates a new Google Sheet in your Google Drive with an optional custom name and location. Use this to quickly set up spreadsheets for tracking, analysis, or collaboration without leaving your workflow.

  • Execute SQL on Spreadsheet

    Query and modify Google Sheets data using SQL syntax, allowing you to perform complex searches, updates, and data transformations without leaving your spreadsheet. This operation automatically recognizes your sheet structure and supports SELECT, INSERT, UPDATE, and DELETE commands.

  • Upsert Rows (Smart Update/Insert)

    Intelligently updates existing rows in a spreadsheet by matching a key column, or inserts new rows if no match is found, while automatically handling column mapping and partial updates without disrupting other data.

  • Append Values to Spreadsheet

    Adds new rows of data to the end of your Google Sheet without overwriting existing information. Perfect for continuously building datasets like customer records, sales logs, or inventory updates.

  • Get Data Validation Rules

    Retrieve all data validation rules from your Google Sheets to understand what values are allowed in each cell, including dropdown lists, number ranges, and custom constraints.

  • Format cell

    Applies visual formatting like text color, background color, and text style to cells in your Google Sheet to make important data stand out and improve readability.

View all 53 Google Sheets actions
05. How approvals work

Every action waits for a tap.

  1. 01

    Workflow proposes

    When a Notion event fires, the agent drafts the Google Sheets 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

Notion → Google Sheets
82

Sync Notion database updates to a Google Sheet?

Trigger: New event in Notion

Action: Run in Google Sheets

Pause until you approve.

SWIPE → APPROVE
06. Setup

How to connect Notion to Google Sheets

  1. 01

    Start your free trial

    Create a Rills account at rills.app. No credit card is required, and your 14-day trial starts immediately.

  2. 02

    Connect your Notion workspace

    Authorize Rills to access Notion using your existing account. You select which pages and databases Rills is allowed to watch.

  3. 03

    Connect your Google account

    Authorize Google Sheets in the same way, then choose the specific spreadsheet you want to write to.

  4. 04

    Pick a trigger and action

    Select the 'Database content updated' trigger from Notion and pair it with the 'Upsert Rows' action in Google Sheets. Rills maps the fields for you.

  5. 05

    Approve your first run from your phone

    When the trigger fires, Rills sends a proposed sheet update to your phone. Swipe to approve and watch the row appear in your spreadsheet. You are live.

07. FAQ

Common questions about connecting Notion to Google Sheets

How do I connect Notion to Google Sheets?

Sign up for Rills, then authorize both your Notion workspace and your Google account inside the app. From there, pick a Notion trigger and a Google Sheets action from the curated pairings, and Rills handles the rest. The whole setup takes about five minutes.

How much does this integration cost?

Rills includes a free 14-day trial and no credit card is required to start. Approvals and all automation logic are always free. You only pay credits when an action actually writes data to Google Sheets, so experimenting costs nothing.

Can it update an existing row instead of always adding a new one?

Yes. The upsert action checks whether a matching row already exists in your sheet and updates it if found, or inserts a new one if not. This keeps your spreadsheet clean when Notion database records are edited repeatedly over time.

Do I have to approve every single action?

By default, yes. Every proposed Google Sheets write waits for your swipe before it runs. Once you trust a pattern, you can configure it to auto-approve so the workflow runs hands-free. You choose how much oversight you want for each automation.

What Notion events can trigger a Google Sheets update?

The supported triggers include database content updates, new page creation, file upload completion, and page property changes. Each covers a common workflow so you can pick the one that matches how your team actually uses Notion day to day.

Will this work if my Notion database has many records?

Yes. Rills processes each trigger event individually, so high-volume databases work fine. Upsert actions match on a key you define, preventing duplicate rows even when many records change at once. You approve in batches or let trusted rules handle volume automatically.

08. Get started

Start with: Sync Notion database updates to a Google Sheet

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