opencode

Connect OpenCode to Google Sheets and MongoDB

Give OpenCode both Google Sheets and MongoDB and it can move data between your database and your spreadsheets on its own. It reads or aggregates records in MongoDB, then writes the results into a sheet your team already lives in. Point it the other way and it takes rows from a sheet and bulk writes them into a collection. MongoDB stays the system of record while Sheets becomes the place people read and edit the output.

Loading preview…
Opens a workflow with 57 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

MongoDB

38 tools
Find Documents
Find One Document
Insert One Document
Insert Many Documents
Update One Document
Update Many Documents
Replace One Document
Delete One Document
Delete Many Documents
Count Documents
Estimated Document Count
Distinct Values
Bulk Write
Find One and Update
Find One and Delete
Find One and Replace
Aggregate
List Collections
Create Collection
Drop Collection
Rename Collection
Create Index
List Indexes
Drop Index
Drop All Indexes
Vector Search
Create Vector Search Index
List Search Indexes
Update Search Index
Delete Search Index
Atlas Text Search
Create Atlas Search Index
Atlas Facet Search
List Databases
Drop Database
Run Command
Upload & Index Document
Create Multiple Indexes

What you can build

Aggregate a MongoDB collection and write the summarized results into a Google Sheet range your team can read.
Read a range of rows from a Google Sheet and bulk write them into a MongoDB collection.
Count documents across MongoDB segments and append the daily totals as new rows in a tracking sheet.
Run an Atlas text search in MongoDB and drop the matching records into a fresh spreadsheet for review.

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

Build a custom OpenCode agent

Open your OpenCode agent in one click

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