opencode

Connect OpenCode to Google Sheets and Notion

Connect Google Sheets and Notion to OpenCode and it can shuttle structured data between a spreadsheet and your Notion workspace. It reads rows from a sheet, creates or updates Notion database pages, and pulls Notion content back into cells. The combination lets it keep a Sheets table and a Notion database describing the same records aligned.

Loading preview…
Opens a workflow with 38 tools ready to use.

Tools OpenCode gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

Google Sheets

19 tools
Read Sheet Data

Configuration for reading data from a Google Sheet

Write Sheet Data

Configuration for writing data to a Google Sheet

Append Rows to Sheet

Configuration for appending rows to a Google Sheet

Clear Sheet Range

Configuration for clearing values from a range

Create New Spreadsheet

Configuration for creating a new spreadsheet

Fetch Spreadsheet Metadata

Configuration for getting spreadsheet metadata

Read Multiple Sheet Ranges

Configuration for reading multiple ranges at once

Write to Multiple Sheet Ranges

Configuration for writing to multiple ranges at once

Add Spreadsheet Sheet

Configuration for adding a new sheet/tab

Delete Spreadsheet Sheet

Configuration for deleting a sheet/tab

Copy Sheet to Spreadsheet

Configuration for copying a sheet to another spreadsheet

Rename Spreadsheet Sheet

Configuration for renaming a sheet/tab

Duplicate Sheet in Spreadsheet

Configuration for duplicating a sheet within the same spreadsheet

Find and Replace in Spreadsheet

Configuration for find and replace in a spreadsheet

Insert Sheet Rows

Configuration for inserting rows

Delete Sheet Rows

Configuration for deleting rows

Clear Multiple Sheet Ranges

Configuration for clearing multiple ranges at once

Insert Sheet Columns

Configuration for inserting columns

Delete Sheet Columns

Configuration for deleting columns

Notion

19 tools
Search Pages and Databases

Search pages and databases by title

Query Notion Database

Query a database to retrieve pages

Fetch Database Metadata

Retrieve a database's metadata and schema

Create Page Database

Create a new database as a child of a page

Update Database Metadata

Update a database's title, description, or properties

Fetch Page Properties

Retrieve a page's properties

Create Notion Page

Create a new page in a database or as a child of another page

Update Page Properties

Update a page's properties, icon, or cover

Fetch Notion Block

Retrieve a block

Fetch Block Children

Retrieve a block's children

Append Children to Block

Append new children blocks to a parent block

Update Block Content

Update a block's content

Delete Notion Block

Delete (archive) a block

List Workspace Users

List all users in the workspace

Fetch Workspace User

Retrieve a user by ID

Fetch Bot Integration User

Retrieve the bot user for the current integration

Create Page Comment

Create a comment on a page or in an existing discussion thread

Fetch Page Comment

Retrieve a comment by its ID

List Block Comments

List comments on a block or page

What you can build

Read rows from Google Sheets and create a Notion database page for each, mapping columns to properties
Pull entries from a Notion database into a spreadsheet for filtering, sorting, and sharing
Update existing Notion pages with fresh values whenever the matching sheet row changes
Compile a status digest from a Notion database and write it into a summary tab in Sheets

About OpenCode

OpenCode is an open, model-agnostic command-line coding agent. In NoClick it runs hosted and gains your apps as tools, so it can act on real systems rather than just edit files. Wire an integration into the agent and OpenCode can use that app’s operations directly while it works. It is a flexible choice when you want an open agent with broad model support and real tool access.

Open and model-agnostic
Flexible across many underlying models
Good general-purpose tool use
Lightweight to point at a focused task

Frequently asked questions

Open your OpenCode agent in one click

NoClick runs OpenCode for you with Google Sheets and Notion wired in as tools. Connect your account and run.