Zoho Sheet API Authentication

Every Zoho Sheet API request through MindCloud needs two things: a MindCloud API Key and a connectionId for your Zoho Sheet account. This page covers both, plus exactly how to send them, so you do not need to visit any other page to get authenticated.

Steps to authenticate

1. Create a MindCloud account at app.mindcloud.co if you do not already have one.
2. Generate a MindCloud API Key in API Keys. This is the Bearer token you send on every request. Keep it on your server.
3. Create a Zoho Sheet connection in Connections. Zoho Sheet uses OAuth. When you create the connection, you are redirected to sign in to Zoho Sheet and approve access — MindCloud stores the resulting tokens and refreshes them automatically, so your integration never has to.
4. Copy the connection’s connectionId — you will send it on every request alongside your MindCloud API Key.

How requests are authenticated

Authentication has two layers. Your MindCloud API Key authenticates the request to MindCloud, sent as a Bearer token in the Authorization header. The connectionId selects the connected Zoho Sheet account that should run the action. MindCloud stores and refreshes the Zoho Sheet credentials behind that connection, so you never send provider tokens with your requests.

Pass connectionId in the query string for GET and DELETE actions, and in the JSON body for POST, PUT, and PATCH actions.

For example, calling List All Workbooks with an Zoho Sheet connection looks like this:

curl --request GET \
  --url "https://connect.mindcloud.co/v1/universal/zohoSheet/latest/actions/list-all-workbooks" \
  --header "Authorization: Bearer $MINDCLOUD_API_KEY" \
  --get \
  --data-urlencode "connectionId=$CONNECTION_ID"

The Authorization: Bearer <your MindCloud API Key> header authenticates you to MindCloud; the connectionId tells MindCloud which Zoho Sheet account to run the action against. Missing or invalid Authorization returns 401, and a missing or mismatched connectionId returns 400.

Keep your key safe

Keep your MindCloud API Key on your server; do not ship it in browser code, mobile apps, public repositories, or logs. Anyone with the key can call the Universal API as your MindCloud account, across every connection you have created.