Connect OpenClaw to Google Sheets and Notion
What happens next
Set up in minutes
Choose where it runs
On your computer through your own OpenClaw, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in Google Sheets
A preset of real Google Sheets operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Pick what it can do in Notion
A preset of real Notion operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Connect Google Sheets
One sign-in. The agent acts through your account, scoped to the operations you picked.
Connect Notion
One sign-in. The agent acts through your account, scoped to the operations you picked.
Add your personal MCP link
The last step mints a private MCP URL for this agent and walks you through exactly this, with your real link filled in. The page flips to Connected the moment your OpenClaw first calls in. OpenClaw probes the server while adding it, so this lights up during openclaw mcp add.
Run this in your terminal
<your-link> is your personal server URL — setup mints it for you.
Exact capabilities
Tools OpenClaw gets
Google Sheets
85 toolsConfiguration for reading data from a Google Sheet
Configuration for writing data to a Google Sheet
Configuration for appending rows to a Google Sheet
Configuration for clearing values from a range
Configuration for creating a new spreadsheet
Configuration for getting spreadsheet metadata
Configuration for reading multiple ranges at once
Configuration for writing to multiple ranges at once
Configuration for adding a new sheet/tab
Configuration for deleting a sheet/tab
Configuration for copying a sheet to another spreadsheet
Configuration for renaming a sheet/tab
Configuration for duplicating a sheet within the same spreadsheet
Configuration for find and replace in a spreadsheet
Configuration for inserting rows
Configuration for deleting rows
Configuration for clearing multiple ranges at once
Configuration for inserting columns
Configuration for deleting columns
Configuration for formatting a range of cells
Configuration for sheet-level display properties
Configuration for auto-sizing columns or rows to fit their contents
Configuration for setting an explicit column width or row height
Configuration for merging cells
Configuration for unmerging cells
Configuration for drawing borders on a range
Configuration for alternating row colours
Configuration for adding a filter to a range
Configuration for removing a filter
Configuration for a conditional formatting rule
Configuration for sorting a range
Configuration for adding a dropdown or input rule to a range
Configuration for removing dropdowns / input rules from a range
Configuration for removing conditional formatting rules
Configuration for removing alternating row colours
Configuration for turning a range into a Sheets table
Configuration for removing a table
Configuration for editing or reordering a conditional formatting rule
Configuration for recolouring existing banding in place
Configuration for changing a table's name, range or column types
Configuration for spreadsheet-level properties
Configuration for naming a range
Configuration for changing a named range
Configuration for removing a named range
Configuration for protecting a range from edits
Configuration for changing a protected range
Configuration for removing range protection
Configuration for putting a hover note on cells
Configuration for inserting people or link smart chips
Configuration for anchoring a pivot table
Configuration for copying a range onto another
Configuration for moving a range
Configuration for pasting delimited text
Configuration for extending a series
Configuration for splitting a column of text
Configuration for trimming whitespace
Configuration for removing duplicate rows
Configuration for shuffling rows
Configuration for inserting cells and shifting the rest
Configuration for deleting cells and shifting the rest
Configuration for moving rows or columns
Configuration for appending blank rows or columns
Configuration for adding a chart
Configuration for changing an existing chart
Configuration for moving or resizing a chart
Configuration for a chart's border colour
Configuration for removing a chart
Configuration for appending rows of cells after the last row of data
Configuration for creating a saved filter view
Configuration for changing a filter view
Configuration for copying a filter view
Configuration for removing a filter view
Configuration for grouping rows or columns
Configuration for collapsing or expanding a group
Configuration for ungrouping rows or columns
Configuration for adding a slicer control
Configuration for changing a slicer
Configuration for tagging a sheet, row or column with durable metadata
Configuration for changing developer metadata
Configuration for removing developer metadata
Configuration for connecting a BigQuery data source
Configuration for repointing a data source
Configuration for disconnecting a data source
Configuration for refreshing connected data
Configuration for cancelling a running refresh
Notion
27 toolsSearch pages and databases by title
Query a database to retrieve pages
Retrieve a database's metadata and schema
Create a new database as a child of a page
Update a database's title, description, or properties
Retrieve a page's properties
Retrieve a single property value from a page
Create a new page in a database or as a child of another page
Update a page's properties, icon, or cover
Retrieve a block
Retrieve a block's children
Append new children blocks to a parent block
Update a block's content
Delete (archive) a block
List all users in the workspace
Retrieve a user by ID
Retrieve the bot user for the current integration
Create a comment on a page or in an existing discussion thread
Retrieve a comment by its ID
List comments on a block or page
Update a comment's rich text content
Delete a comment
List all views for a database
Retrieve a specific database view
Update a database view's name or layout
Initiate a file upload and get an upload URL
Get the status of an asynchronous Notion task
Starting points
What you can build
Meet the runner
About OpenClaw
Good to know
Frequently asked questions
Keep exploring
More ways to connect
More tools for OpenClaw
Popular OpenClaw pairs
Make it yours
Open your OpenClaw agent in one click.
NoClick runs OpenClaw for you with Google Sheets and Notion wired in as tools. Connect your account and run.