Zoho Sheet

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 site
Explore
/
Apps
/
Zoho Sheet

Zoho Sheet API Integrations

Build and run workflows using the Zoho Sheet API. Use 1000s of source-available triggers and actions across 1000+ apps. Or write custom code to integrate any app or API in seconds.

Overview

Using 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.

  • Create custom interfaces to view, organize, and manipulate spreadsheets.
  • Automate spreadsheet functions like data sorting, formula calculation, and data updating.
  • Create an extension that interacts with multiple Zoho Sheets accounts.
  • Manage and combine data from multiple sources.
  • Develop tools for team collaboration on sheets.
  • Create charts, graphs, and visualizations for insights into the data.
  • Migrate spreadsheets from one platform to another.
  • Generate personalized reports from sheets with data.
  • Develop applications that integrate with other products and services.
  • Automate notifications for timelines, checklists, and other tasks.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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`,
      },
    })
  },
})

Authentication

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.UPDATEZohoSheet.dataAPI.READ
OAuth Request Configurations:
  1. authorization
    GEThttps://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
  2. accessToken
    POSThttps://accounts.{{custom_fields.base_api_uri}}/oauth/v2/tokencontent-type: application/x-www-form-urlencodedaccept: application/json
    client_id={{oauth.client_id}}&client_secret={{oauth.client_secret}}&redirect_uri={{oauth.redirect_uri}}&grant_type=authorization_code&code={{oauth.code}}
  3. refreshToken
    POSThttps://accounts.{{custom_fields.base_api_uri}}/oauth/v2/tokencontent-type: application/x-www-form-urlencodedaccept: application/json
    client_id={{oauth.client_id}}&client_secret={{oauth.client_secret}}&grant_type=refresh_token&refresh_token={{oauth.refresh_token}}