# Zoho Sheet Integration via LowCodeAPI

## Overview

Spreadsheet application

## Base Endpoint

```
https://api.lowcodeapi.com/zohosheet/
```

## Authentication

LowCodeAPI handles authentication automatically. You only need to:

1. **Sign up** at [Zoho Sheet](https://www.zoho.com/sheet)
2. **Get your credentials** from [credential page](https://accounts.zoho.com/developerconsole)
3. **Connect your account** in LowCodeAPI dashboard
4. **Use your `api_token`** in all requests

**Auth Type**: OAUTH2.0

## API Categories

- **Utility API's** - 1 endpoints
- **Workbook** - 11 endpoints
- **Worksheet** - 1 endpoints

## Common Endpoints

### Category: Utility API's

#### Convert Index to Range

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/utils`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/utils?api_token={api_token}
```

**Description**: used to convert start row, start column, end row, end column indexes respectively to a Range

**Request Body**:
```json
{
  "key": "value"
}
```

---

### Category: Workbook

#### List all workbooks

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/workbooks`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/workbooks?api_token={api_token}
```

**Description**: List all workbooks of the user

**Request Body**:
```json
{
  "key": "value"
}
```

---

#### List all templates

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/templates`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/templates?api_token={api_token}
```

**Description**: List all templates of the user

**Request Body**:
```json
{
  "key": "value"
}
```

---

#### Create workbook

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/create`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/create?api_token={api_token}
```

**Description**: Create workbook used to add a new workbook

**Request Body**:
```json
{
  "key": "value"
}
```

---

#### Create workbook from template

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/createfromtemplate`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/createfromtemplate?api_token={api_token}
```

**Description**: Create a new workbook from a template

**Request Body**:
```json
{
  "key": "value"
}
```

---

#### Upload workbook

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/upload`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/upload?api_token={api_token}
```

**Description**: Upload workbook

**Request Body**:
```json
{
  "key": "value"
}
```

---

#### Download workbook

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/download/resource_id`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/download/resource_id?api_token={api_token}
```

**Description**: Used to download an existing workbook

**Path Parameters**:

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
|`resource_id` | string | No | Resource Id |

**Request Body**:
```json
{
  "key": "value"
}
```

---

#### Insert images

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/insertimages`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/insertimages?api_token={api_token}
```

**Description**: Insert images into a workbook

**Request Body**:
```json
{
  "key": "value"
}
```

---

#### Copy workbook

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/copy`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/copy?api_token={api_token}
```

**Description**: Used to make a new copy of an existing workbook

**Request Body**:
```json
{
  "key": "value"
}
```

---

#### Share workbook

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/share`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/share?api_token={api_token}
```

**Description**: Used to share a workbook with a user

**Request Body**:
```json
{
  "key": "value"
}
```

---

#### Trash workbook

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/trash`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/trash?api_token={api_token}
```

**Description**: Used to create a new version

**Path Parameters**:

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
|`resource_id` | string | No | Resource Id |

**Request Body**:
```json
{
  "key": "value"
}
```

---

#### Restore workbook

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/restore`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/restore?api_token={api_token}
```

**Description**: Used to revert to an older version

**Path Parameters**:

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
|`resource_id` | string | No | Resource Id |

**Request Body**:
```json
{
  "key": "value"
}
```

---

### Category: Worksheet

#### Delete worksheet

**Method**: `POST` | **LowCodeAPI Path**: `/api/v2/resource_id`

**Full URL**:
```
https://api.lowcodeapi.com/zohosheet/api/v2/resource_id?api_token={api_token}
```

**Description**: Delete worksheet

**Path Parameters**:

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
|`resource_id` | string | No | Resource Id |

**Request Body**:
```json
{
  "key": "value"
}
```

---

## Complete Endpoint Reference

For a complete list of all 13 endpoints, refer to:
- **OpenAPI Definition**: `https://backend.lowcodeapi.com/zohosheet/definition`
- **Official Provider Documentation**: https://www.zoho.com/sheet/help/api/v2/