Google Sheets
Description
The Google Sheets plugin lets you manage spreadsheets and sheets in Google Sheets. It supports creating spreadsheets, creating and deleting sheets within a spreadsheet, copying sheets, appending rows, reading data, and looking up sheet IDs by name. The plugin authenticates using a Client ID, Client Secret, and Refresh Token from your Google developer console. Use this plugin when your workflows need to automate data entry, read spreadsheet data for processing, or manage Google Sheets as part of reporting workflows.
Prerequisites:
- Google developer console account should be created and subscribed: https://console.developers.google.com/.
- APIs for Google Drive and Google Spreadsheet should be enabled.
- Client ID and Client Secret should be generated from the Credentials tab. In exchange for the Client ID and Client Secret, a Refresh Token can be generated.
Google Spreadsheets plugin steps read from Google Drive. Google Drive differentiates between Excel files and Google Spreadsheet files. However, Google Spreadsheets plugin steps support only Google Spreadsheet files.
References:
- Google Spreadsheet documentation- https://developers.google.com/sheets/api
Refer Google Sheets Refresh Token Generation for enabling APIs, creating Client ID and Client Secret and generating Refresh Token.
Common Action Buttons:
| No. | Field Name | Description |
|---|---|---|
| 1 | OK | On click of this button. It will check the field values. If any required field values are missing, then it will display validation error message. If all the required field values are provided then it will save the field values. |
| 2 | Cancel | On click of this button, it will cancel the window and do not save any values |