Hey everyone,
I have a Google Sheets workbook that is collecting user entered data. I have several dependent drop down menus and a script that collects a range of values and then enters it into a portion of the sheet. A robot then accesses this sheet, scrapes the data, and enters it into Oracle. I’d like to develop another Apps Script that allows the user to submit the entered data and deploy the robot through a button press. This is because data needs to be added at all hours, so running the robot manually or scheduling it for a specific time is just not viable.
I’ve read some articles about connecting Google Sheets with Orchestrator, but all of these articles focus on UiPath Cloud. Our organization uses an on premise server, and I haven’t been able to find much helpful information on how to achieve what I’m after using this particular platform. The best resource I found is the following:
…but I’m uncertain where to get some of the information it’s after. For example, the UiPath Automation Suite Host, I have no idea where to find this information.
Does anyone have any recommended resources to help with this? Again, an overview of the ask:
Establish an API connection from Google Sheets to Orchestrator to deploy a robot at a button press. This robot will scrape the data from the sheet and enter it into Oracle over the course of the day.
Any help would be greatly appreciated! Thanks everyone.