Can OpenCode read my whole spreadsheet or just certain tabs?

It uses the read operations you expose, like Read Multiple Sheet Ranges, scoped to the spreadsheet its Google credential can reach. Point it at specific ranges and it only touches those. The Sheets credential resolves on our server and is never passed to the model.

Will it create tasks in ClickUp that I did not ask for?

The agent can only call the ClickUp operations you allowlist, so if you expose Add Task to List and Add Tag to Task, that is all it can do. It cannot touch anything outside those operations. You decide the surface before it runs.

How do the two tools stay in sync during one task?

Because both ClickUp and Google Sheets are wired into the same agent, it can read a range from a sheet and add the matching tasks to ClickUp in one pass, then append a confirmation row. There is no handoff between separate jobs. Each credential is resolved server-side per call.

What makes OpenCode different here?

OpenCode is open and model-agnostic, so you have flexibility over the underlying model. NoClick handles running it and connecting your apps as tools.

How do I give OpenCode tools?

Connect an integration node to the agent's tools handle and choose the operations to allow. Each becomes a tool the agent can call.

Do I manage any infrastructure?

No. NoClick runs the OpenCode harness in a hosted sandbox and resolves credentials for the apps you connect.

Can it combine several apps?

Yes. Add as many integrations as you need and the agent can use them together in one run.

Connect OpenCode to ClickUp and Google Sheets

Give OpenCode your ClickUp and Google Sheets together and it can turn a spreadsheet into real project work without you copying rows by hand. The sheet is usually where the plan lives, and ClickUp is where the tasks, tags, and dependencies land. OpenCode reads the ranges you point it at, adds the matching tasks to the right lists, and can append a confirmation back to the sheet. The two tools together let one agent move a plan from a row into a tracked item.

Loading preview…

Opens a workflow with 244 tools ready to use.

What happens next

Set up in minutes

The open button drops you into a guided setup. It asks exactly this, nothing else:

Choose where it runs
On your computer through your own OpenCode, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in ClickUp
A preset of real ClickUp 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 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.
Connect ClickUp
One sign-in. The agent acts through your account, scoped to the operations you picked.
Connect Google Sheets
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 OpenCode first calls in.
1. Run this in your terminal
$opencode mcp add
2. Choose Remote and paste your server URL
https://mcp.noclick.app/s/<your-link>
3. Choose No when asked about OAuth authentication — the link itself is the key
<your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools OpenCode gets

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

ClickUp

159 tools

Get Authorized Workspaces

List the Workspaces (teams) the token can access.

Get Spaces

List spaces in a Workspace.

Get Folders

List folders in a space.

Get Lists

List the lists inside a folder.

Get Workspace Members

List members of a Workspace (for assignee selection).

Create Task

Create a new task in a list.

Get Tasks

Retrieve tasks in a list (paginated).

Get Task

Fetch a single task's full details.

Update Task

Modify a task (name, status, priority, dates, etc.).

Delete Task

Remove a task.

Get Filtered Team Tasks

Query tasks across a whole Workspace by filters.

Create List

Create a list inside a folder.

Create Folder

Create a folder in a space.

Create Task Comment

Add a comment to a task.

Get Task Comments

Retrieve comments on a task.

Get Accessible Custom Fields

List custom fields available in a list.

Set Custom Field Value

Set a custom field value on a task.

Create Time Entry

Log a time entry in a Workspace.

Get Time Entries

Retrieve time entries within a date range.

Start Timer

Start a running timer (optionally tied to a task).

Stop Timer

Stop the currently running timer.

Create Goal

Create a goal in a Workspace.

Get Goals

List Workspace goals.

Create Task Attachment

Attach a file (by URL) to a task. NoClick downloads the URL and uploads it to ClickUp as multipart/form-data.

Custom API Request

Escape hatch: call ANY ClickUp endpoint not modeled as a first-class op.

Get Authorized User

Merge Tasks

Get Task Time in Status

Get Bulk Tasks' Time in Status

Create Task From Template

Add Dependency

Delete Dependency

Add Task Link

Delete Task Link

Add Task to List

Remove Task From List

Get Space Tags

Create Space Tag

Edit Space Tag

Delete Space Tag

Add Tag to Task

Remove Tag From Task

Create Checklist

Edit Checklist

Delete Checklist

Create Checklist Item

Edit Checklist Item

Delete Checklist Item

Get Chat View Comments

Create Chat View Comment

Get List Comments

Create List Comment

Update Comment

Delete Comment

Get Threaded Comments

Create Threaded Comment

Remove Custom Field Value

Get Workspace Custom Fields

Get Folderless Lists

Create Folderless List

Get List

Update List

Delete List

Create List From Template (Folder)

Create Folderless List From Template

Get Folder

Update Folder

Delete Folder

Create Folder From Template

Create Space

Get Space

Update Space

Delete Space

Get Goal

Update Goal

Delete Goal

Create Key Result

Edit Key Result

Delete Key Result

Get Workspace Views

Get Space Views

Get Folder Views

Get List Views

Create Workspace View

Create Space View

Create Folder View

Create List View

Get View

Update View

Delete View

Get View Tasks

Get Task Members

Get List Members

Invite Guest to Workspace

Get Guest

Edit Guest on Workspace

Remove Guest From Workspace

Add Guest to Task

Remove Guest From Task

Add Guest to List

Remove Guest From List

Add Guest to Folder

Remove Guest From Folder

Invite User to Workspace

Get User

Edit User on Workspace

Remove User From Workspace

Create User Group

Get User Groups

Update User Group

Delete User Group

Get Custom Roles

Get Shared Hierarchy

Get Single Time Entry

Update Time Entry

Delete Time Entry

Get Running Time Entry

Get Time Entry History

Get All Time Entry Tags

Add Tags to Time Entries

Remove Tags From Time Entries

Rename Time Entry Tag

Track Time (Legacy)

Get Tracked Time (Legacy)

Edit Tracked Time (Legacy)

Delete Tracked Time (Legacy)

Get Webhooks

Create Webhook

Update Webhook

Delete Webhook

Get Workspace Seats

Get Workspace Plan

Search Docs

Create Doc

Get Doc

Get Doc Page Listing

Get Doc Pages

Create Doc Page

Get Doc Page

Edit Doc Page

List Chat Channels

Create Chat Channel

Create Chat Location Channel

Create Chat DM Channel

Get Chat Channel

Update Chat Channel

Get Chat Channel Followers

Get Chat Channel Members

List Chat Messages

Create Chat Message

Update Chat Message

Delete Chat Message

Create Chat Reply

Get Chat Replies

Get Chat Message Reactions

Create Chat Reaction

Delete Chat Reaction

Get Chat Message Tagged Users

Create Audit Logs

Google Sheets

85 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

Format Cells

Configuration for formatting a range of cells

Update Sheet Properties

Configuration for sheet-level display properties

Auto-Resize Columns Or Rows

Configuration for auto-sizing columns or rows to fit their contents

Set Column Width Or Row Height

Configuration for setting an explicit column width or row height

Merge Cells

Configuration for merging cells

Unmerge Cells

Configuration for unmerging cells

Add Or Remove Borders

Configuration for drawing borders on a range

Add Alternating Colours

Configuration for alternating row colours

Set Filter

Configuration for adding a filter to a range

Clear Filter

Configuration for removing a filter

Add Conditional Formatting

Configuration for a conditional formatting rule

Sort Range

Configuration for sorting a range

Add Dropdown Or Input Rule

Configuration for adding a dropdown or input rule to a range

Remove Dropdown Or Input Rule

Configuration for removing dropdowns / input rules from a range

Remove Conditional Formatting

Configuration for removing conditional formatting rules

Remove Alternating Colours

Configuration for removing alternating row colours

Convert Range To Table

Configuration for turning a range into a Sheets table

Delete Table

Configuration for removing a table

Edit Conditional Formatting

Configuration for editing or reordering a conditional formatting rule

Recolour Alternating Colours

Configuration for recolouring existing banding in place

Edit Table

Configuration for changing a table's name, range or column types

Update Spreadsheet Properties

Configuration for spreadsheet-level properties

Add Named Range

Configuration for naming a range

Update Named Range

Configuration for changing a named range

Delete Named Range

Configuration for removing a named range

Protect Range

Configuration for protecting a range from edits

Update Protected Range

Configuration for changing a protected range

Unprotect Range

Configuration for removing range protection

Cell Notes

Configuration for putting a hover note on cells

Insert Smart Chips

Configuration for inserting people or link smart chips

Pivot Table

Configuration for anchoring a pivot table

Copy And Paste Range

Configuration for copying a range onto another

Cut And Paste Range

Configuration for moving a range

Paste Delimited Text

Configuration for pasting delimited text

Auto-Fill Range

Configuration for extending a series

Split Text To Columns

Configuration for splitting a column of text

Trim Whitespace

Configuration for trimming whitespace

Remove Duplicate Rows

Configuration for removing duplicate rows

Randomise Range

Configuration for shuffling rows

Insert Cells

Configuration for inserting cells and shifting the rest

Delete Cells

Configuration for deleting cells and shifting the rest

Move Rows Or Columns

Configuration for moving rows or columns

Append Rows Or Columns

Configuration for appending blank rows or columns

Add Chart

Configuration for adding a chart

Edit Chart

Configuration for changing an existing chart

Move Or Resize Chart

Configuration for moving or resizing a chart

Set Chart Border

Configuration for a chart's border colour

Delete Chart

Configuration for removing a chart

Append Rows After Data

Configuration for appending rows of cells after the last row of data

Filter View

Configuration for creating a saved filter view

Update Filter View

Configuration for changing a filter view

Duplicate Filter View

Configuration for copying a filter view

Delete Filter View

Configuration for removing a filter view

Group Rows Or Columns

Configuration for grouping rows or columns

Collapse Or Expand Group

Configuration for collapsing or expanding a group

Ungroup Rows Or Columns

Configuration for ungrouping rows or columns

Add Slicer

Configuration for adding a slicer control

Update Slicer

Configuration for changing a slicer

Add Developer Metadata

Configuration for tagging a sheet, row or column with durable metadata

Update Developer Metadata

Configuration for changing developer metadata

Delete Developer Metadata

Configuration for removing developer metadata

Connect BigQuery Data Source

Configuration for connecting a BigQuery data source

Repoint Data Source

Configuration for repointing a data source

Delete Data Source

Configuration for disconnecting a data source

Refresh Data Source

Configuration for refreshing connected data

Cancel Data Source Refresh

Configuration for cancelling a running refresh

Starting points

What you can build

Read a roadmap tab in Google Sheets and add each row as a task to the right ClickUp list, tagging it by priority.

Set up dependencies between ClickUp tasks from an order column in a sheet, then append a confirmation row back to the sheet.

Add external reviewers as guests to specific ClickUp folders and lists from an access list you keep in Google Sheets.

Rename a time-entry tag across ClickUp and record the change in a Google Sheets audit tab so the log stays current.

Meet the runner

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

Good to know