How to find content on google sheets and copy content of cell to the right of it

Hi guys,

I’m really new to all this and need some help on executing ctrl+F on a google sheets page, searching for a specific entry, then copying the contents of the cell to the right of it, then pasting it somewhere else.

I’ve tried XType | ${KEY_CTRL+KEY_F} but for some reason, it doesn’t do anything, so I’m stuck there.

Thanks for the help!

Very complicated to do, I suggest you do not use google sheets but use csv (you can convert google sheets in csv and import it in ui vision).

If you want to automate google sheets you must use desktop automation it’s very hard and require more time.

So let’s say I use a csv instead. What would I do from there to get to the result I want?

Yes, you must use csvread command

https://ui.vision/rpa/docs/selenium-ide/csvread