Create spreadsheets your teams can easily collaborate on for free. Powered with an automated data processor, an AI-assisted data analyst, and 1000+ integration possibilities, Zoho Sheet makes data handling easier and more effective.
Go to siteUsing the Zoho Sheet API, you can create a wide variety of applications that work with spreadsheets. With it, you can build extensions, automate workflow, create custom interfaces, and much more. Below are some examples of projects you could build with the Zoho Sheet API.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
zoho_sheet: {
type: "app",
app: "zoho_sheet",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://sheet.${this.zoho_sheet.$auth.base_api_uri}/api/v2/workbooks`,
headers: {
"Authorization": `Zoho-oauthtoken ${this.zoho_sheet.$auth.oauth_access_token}`,
},
params: {
method: `workbook.list`,
},
})
},
})
Zoho Sheet uses OAuth authentication. When you connect your Zoho Sheet account, Pipedream will open a popup window where you can sign into Zoho Sheet and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Zoho Sheet API.
Pipedream requests the following authorization scopes when you connect your account:
ZohoSheet.dataAPI.UPDATE
ZohoSheet.dataAPI.READ
GET
https://accounts.{{custom_fields.base_api_uri}}/oauth/v2/auth
?
client_id={{oauth.client_id}}
&
redirect_uri={{oauth.redirect_uri}}
&
state={{oauth.state}}
&
response_type=code
&
scope={{oauth.space_separated_scopes}}
&
prompt=consent
&
access_type=offline
POST
https://accounts.{{custom_fields.base_api_uri}}/oauth/v2/token
content-type: application/x-www-form-urlencoded
accept: application/json
client_id={{oauth.client_id}}
&
client_secret={{oauth.client_secret}}
&
redirect_uri={{oauth.redirect_uri}}
&
grant_type=authorization_code
&
code={{oauth.code}}
POST
https://accounts.{{custom_fields.base_api_uri}}/oauth/v2/token
content-type: application/x-www-form-urlencoded
accept: application/json
client_id={{oauth.client_id}}
&
client_secret={{oauth.client_secret}}
&
grant_type=refresh_token
&
refresh_token={{oauth.refresh_token}}