[solved]device automation - save a googlesheet to excel worksheet

I am fairly new to Kapow.
I am using version 10.3

I have a URL for a googledocs (which I can provide if needed)   https://docs.goggle.com/spreadsheets............

When I go through my steps in Chrome.....
1. load URL
2. left click File menu (which causes a fly out menu)
3. Left click download as (which causes a fly out menu)
4. left click on Microsoft excel


When I am in device automation, on step 2, once I left click the file menu, I am not seeing the flyout menu.

Could someone assist me in learning how to do this?

Hi,

If you step through the DA workflow and wait after you have selected the file menu does the fly out eventually appear? This sounds like it could be timing issue.

If the menu appears when stepping through slowly at design time but not when you run it end-to-end then your process is probably progressing before the interface has been updated. Adding a Tree Stops Changing Guard to your workflow after your File Menu action should resolve this, this will halt the workflow whilst the application tree is updating.

Depending on what you are trying to do it might be worth looking at the REST APIs available from Google. Kapow supports OAuth tokens that can be used with these APIs, this might be easier and more robust than going through the UI.

This was solved by first adding a guarded choice step with "tree stops changing" with 500ms.
This allowed the fly out menu to be shown and worked with.