Question
Nihon Insight Technologies Corporation
JP
Last activity: 6 Nov 2018 20:02 EST
Automation for Google Spread Sheet
Can I automate operations for a Gllgole Spread Sheet?
For example,
How can I get/set a cell value of a Google Spread Sheet?
How can I create a automation flow to execute below actions?
- Click [File] > [Download as] > [Microsoft Excel (.xlsx)]
- Then click [Save] button in the dialog of IE to download.
And I notice that I can interrogate some components in a Google Spread Sheet with Web Application Adapter(IE),
but I can't interrogate any component with Universal Web Application Adapter(Chrome).
Can I use Universal Web Application Adapter(Chrome) for a Google Spread Sheet
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
US
I've never tried before. The universal web adapter has less functionality than the web adapter running in IE, so I'd suspect that it might not work (since Google Sheets works best in Chrome). Perhaps you can download the file as an Excel and work with it using the Excel connector. That would be the approach I would start with.