Can the agent create and delete real users?

Only if you allowlist Admin Create User and Admin Delete User. Those are admin operations, so grant them when you want the agent provisioning accounts and leave them off for a read-only review that uses only Admin List Users.

Does the agent see user passwords or tokens?

No. It triggers Send Magic Link Signin or Send Password Reset Email through the Supabase credential, and Supabase handles delivery, so no secret rides the model. The credential itself resolves server-side.

Which spreadsheet does it read the user list from?

Whatever spreadsheet your Google Sheets credential can reach. It uses Read Multiple Sheet Ranges to pull the roster, then calls the matching Supabase admin operation for each row.

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 Google Sheets and Supabase

Give OpenCode both Google Sheets and Supabase and it can manage your users straight from a spreadsheet. It reads a roster from a sheet, then creates, updates, or removes accounts in Supabase and sends people a magic link or a password reset. Point it the other way and it lists your Supabase users into a sheet for an access review. Supabase stays the auth system of record while Sheets is the roster and the audit log.

Loading preview…

Opens a workflow with 53 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

Supabase

34 tools

Select Table Rows

Select/query rows from a table with filtering, ordering, and pagination

Insert Table Rows

Insert one or more rows into a table

Update Table Rows

Update rows matching filter conditions

Delete Table Rows

Delete rows matching filter conditions

Upsert Table Rows

Insert rows or update if they already exist (based on primary key or unique constraint)

Call Database Function

Call a database function (RPC)

Send Magic Link Signin

Send a magic link to user's email for passwordless signin

Sign Out User

Sign out the current user (requires user's access token)

Get Current User

Get current user details (requires user's access token)

Update Current User

Update current user's email, password, or metadata

Send Password Reset Email

Send password reset email to user

Verify Otp Code

Verify OTP code sent via email or SMS

Refresh Access Token

Refresh an expired access token using refresh token

Admin List Users

List all users (requires service_role API key)

Admin Create User

Create a new user (admin operation, requires service_role API key)

Admin Delete User

Delete a user by ID (admin operation, requires service_role API key)

Admin Update User

Update a user by ID (admin operation, requires service_role API key)

Create Storage Bucket

Create a new storage bucket

List Storage Buckets

List all storage buckets

Get Storage Bucket

Get bucket details

Delete Storage Bucket

Delete a storage bucket

Empty Storage Bucket

Empty a storage bucket (delete all files)

Upload Storage File

Upload a file to storage

Download Storage File

Download a file from storage

List Bucket Files

List files in a storage bucket folder

Delete Storage File

Delete a file from storage

Move Storage File

Move a file within or between buckets

Copy Storage File

Copy a file within or between buckets

Create File Signed Url

Create a signed URL for temporary file access

Get File Public Url

Get public URL for a file in a public bucket

Broadcast Realtime Message

Send broadcast messages to a Realtime channel

Invoke Edge Function

Invoke a Supabase Edge Function

What you can build

Read a list of new hires from a Google Sheet and create each one as a user in Supabase.

List every Supabase user and write them into a spreadsheet for an access review.

Read email addresses from a sheet and send each person a Supabase magic link or password reset.

Read a sheet of departures and delete each matching Supabase account to close out offboarding.

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