Google Sheets - Write to Sheets (Range) from Dataset Values

This bot is based in the Google Sheets API. It requests the appending of data to a specified Google Sheet “Range” by executing the “spreadsheets.values.append” HTTP POST method. The input will be an Automate Dataset object (Name: ds_AppendValues) with the values to be appended, so you can use any Automate action to create the dataset with values (csv file, excel file, database, etc.). 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 appended to. Within the task you will find an example for the dataset creation with values read from a “.CSV” file.

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:

  • Write values in an Excel file on Google Sheets from a dataset


 This task is compatible with:

  • Automate Ultimate 11.2 and greater
  • Automate Plus 11.2 and greater
  • Automate Desktop 11.2 and greater
Fortra's connectors, solution templates, and digital coworkers are the result of our experience training and implementing automation initiatives for our customers. All the configurations are maintained by Fortra Professional Services. If you need our help to configure a connector, please complete the form here.