HomePricingIntegrations

Sheet-level Operations

Operations related to individual sheets within a spreadsheet

1. Create Sheet from JSON

Component settings

Parameter Name
Description

Credentials

Connect your Google account to authorize access to Google Sheets. Required to perform any actions.

Action

Select the action: - Create Sheet From JSON

Title

Input the Title of the "Google sheet" you want to create

Sheet Name

Input the "Sheet Name" you want to create

Sheet JSON

Input the JSON data Example: 

[
  {
    "name": "Huy",
    "age": 18,
    "class": "12A1"
  },
  {
    "name": "Tai",
    "age": 17,
    "class": "11B2"
  },
  {
    "name": "Thuy",
    "age": 16,
    "class": "10C3"
  }
]

2. Get Sheet Names

Component settings

Parameter Name
Description

Credentials

Connect your Google account to authorize access to Google Sheets. Required to perform any actions.

Action

Select the action: - Get Sheet Names

Spreadsheet ID

Input the "Spreadsheet ID" you want to get the info

3. Clear values

Component settings

Parameter Name
Description

Credentials

Connect your Google account to authorize access to Google Sheets. Required to perform any actions.

Action

Select the action: - Clear Values

Spreadsheet ID

Input the "Spreadsheet ID" you want to clear the values

Ranges

Input the ranges you want to clear Ex: 

[
  "Sheet1!A1:C5",
  "Sheet2!A1:B10"
]

Last updated

Was this helpful?