Create a custom output script for Automation Anywhere for Google Workspace

Use the default script or create a custom script to process the data that is returned from the bot. The output script is written in Google App Scripts code.

Create a new custom script to save or display the Google G Suite Sheets spreadsheet data results, call a REST API, or highlight or color a value in the spreadsheet to return data from the bot to the sheet.

To perform any Google G Suite function using App Scripts APIs, see Google Apps Script.

Optionally, use the default script. Select the Advanced Scripting tab and use the default option Default: Save to Cell. This option saves the results in the AutomationBotResult Google G Suite Sheets spreadsheet.

Procedure

  1. From your the Google G Suite Sheets application, open and log in to the Automation Anywhere Automation Anywhere for Google Workspace panel.
  2. From the Automation Anywhere for Google Workspace panel, open the sub-menu (three vertical dots) and select Advanced Scripting.
    The Advanced Scripting page appears. It is pre-populated with the default Save To Cell script, name, code and test data.
  3. Edit an existing or create a new script. Select from the pull-down menus and enter or edit the text fields.
    Select a Script
    Select an existing script, use the default Save to Cell script, or Create New script .
    Script Name
    Enter a name for the script. When an existing script is selected, this is automatically filled.
    Code
    Enter or edit existing JavaScript code.
    Test Data
    Enter or edit existing
  4. Test the script. Click Test.
    A message appears indicating if the script was successful or not.
  5. Save the script, click Save.
    You cannot save the script until it passed testing.