Definition and Usage
Retrieve a Google Spreadsheet by providing the Google OAuth token, the spreadsheet URL, and the sheet name. This command allows you to access and extract data from Google Sheets for further processing in your RPA workflow.
Parameter Values
Input parameters
Parameter | Description | Required | Options / Notes |
Google access token | Select the Google OAuth token for authentication | Yes | Must be a valid OAuth token with access to Google Sheets |
Google Sheets URL | Enter the URL of the Google spreadsheet | Yes | The URL should point to a valid Google Sheets document |
Sheet name | Enter the sheet name of the Google spreadsheet | Yes | The sheet must exist within the specified spreadsheet |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
Store spreadsheet into: This action produces a variable that contains the retrieved Google spreadsheet data.
Using Variables in Conditions
You can use variables in this command by clicking on the {x} icon next to input fields. This allows you to dynamically set parameters using previously defined variables. For example, you might use a variable to specify which sheet name to access based on earlier workflow logic.
Notes
Before using this command, ensure you have properly set up Google OAuth authentication and have the necessary permissions to access the spreadsheet.
The Google Sheets URL must be in the correct format (typically starting with "https://docs.google.com/spreadsheets/d/").
If the specified sheet name doesn't exist in the spreadsheet, the command will return an error.
The retrieved spreadsheet data structure will include all cells, formatting, and data from the specified sheet.