opencode

Connect OpenCode to Gmail and Google Sheets

Wire Gmail and Google Sheets into OpenCode and it can turn inbox traffic into structured records and structured records back into outbound mail. It reads and parses incoming emails, appends or updates rows in a sheet, and emails reports built from what it finds in the data. The pair lets the agent run the read-extract-log-notify loop end to end without you touching a spreadsheet.

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

Gmail

27 tools
Send Email Message

Configuration for sending an email

Fetch Emails from Inbox

Configuration for reading emails from inbox

Fetch Email Message

Configuration for getting a specific message

Permanently Delete Message

Configuration for permanently deleting a message

Move Message to Trash

Configuration for moving a message to trash

Restore Message from Trash

Configuration for removing a message from trash

Update Message Labels

Configuration for modifying message labels

Reply to Email Message

Configuration for replying to an email

Forward Email Message

Configuration for forwarding an email

Create Email Draft

Configuration for creating a draft

List Email Drafts

Configuration for listing drafts

Fetch Email Draft

Configuration for getting a specific draft

Update Email Draft

Configuration for updating a draft

Delete Email Draft

Configuration for deleting a draft

Send Email Draft

Configuration for sending a draft

List Email Labels

Configuration for listing all labels

Create Email Label

Configuration for creating a label

Fetch Email Label

Configuration for getting a label

Update Email Label

Configuration for updating a label

Delete Email Label

Configuration for deleting a label

List Email Threads

Configuration for listing threads

Fetch Email Thread

Configuration for getting a specific thread

Move Thread to Trash

Configuration for moving a thread to trash

Restore Thread from Trash

Configuration for restoring a thread from trash

Update Thread Labels

Configuration for modifying thread labels

Permanently Delete Thread

Configuration for permanently deleting a thread

Fetch User Profile

Configuration for getting user profile

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

What you can build

Read new emails matching a query, extract the key fields, and append a row to a tracking sheet for each one
Pull a range from a Google Sheet, build a summary, and email it to the recipients listed in another column
Watch for order or signup emails, parse the details, and update the matching row in a sheet
Read a sheet of pending follow-ups and send a tailored Gmail message for every row that is due

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 Gmail and Google Sheets wired in as tools. Connect your account and run.