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" ]