Unanswered

paste excel data into google sheet

Like (0) Share

Report

Posted on 18 Apr 2021 08:50:34 by tjb2

I have a flow that extracts specific range data from an excel worksheet - I can then open the google sheets using the Launch new chrome action - then I just need to paste - but all the UI actions I have tried do not work:

Click UI element

Select Menu Option in window

etc

Can anyone help?

Rgds

TJB2

All responses (3)

Answers (0)

Community Power Pla... on 11 Aug 2021 at 01:36:39

Like (0)

Report

Re: paste excel data into google sheet

Hi @tjb2
A little late to the party, but you can paste values to a google sheet by sending keys Ctrl+V (be sure to focus browser window first).
This allows you to paste on cell A1, which is the cell active when you start GS.
I believe it's possible to paste in any cell once you have an image reference, with 'Move mouse to image' + 'Send a click after moving mouse'. For example, if you want to paste C1, capture an image with the header and cells, like this:
and then play with 'Mouse position relative to image' parameter as this:
Good luck
tjb2 2 on 24 Apr 2021 at 14:41:55

Like (0)

Report

Re: paste excel data into google sheet

None work I have tried 'hover over element', 'click link on webpage' 'press button'

If you are able to effect a paste to google sheet - please let me know how.

Rgds

TJB
Henrik_M 2,006 Super User 2024 Season 1 on 18 Apr 2021 at 09:54:27

Like (0)

Report

Re: paste excel data into google sheet

You need to use the actions located in the Web automation folder.