Google Sheets - Get Values from Sheet (Range) to Dataset
This bot is based in the Google Sheets API. It requests the data in a specified Google sheet “Range” by executing the “spreadsheets.values.get” HTTP GET method and creates an Automate Dataset object (Name: ds_SheetValues) with the values that were received. Then you can use this dataset to loop the data and perform any desired action that you might need. Within the bot configuration, you will be able to set the Google Spreadsheet, the specific sheet name in case of multiple sheets and the range for the values to be received. This task also provides an example on how to use the dataset and creates a “.CSV” file with the data.
The Google API's token is specifically generated with information from the server or pc where it will run. Is mandatory to configure the Google Spreadsheet API's token on each agent where it will run.
You can use this bot to:
- Get values from an Excel file via API
- Obtain a CSV with the dataset values
This task is compatible with:
- Automate Ultimate 11.2 and greater
- Automate Plus 11.2 and greater
- Automate Desktop 11.2 and greater