How to paste an image from clipboard into a google sheets column

Help Studio
, ,
1

Hello all!

I’ve been trying to automate grabbing an image to add to a spreadsheet for some work I’ve been doing. I was using the gsuite extension to apply to my Google Sheet. I read in the spreadsheet, grab a value from the column corresponding to my search term, search the website and grab the image. All of that works fine, even right clicking and copying the image. The one thing I cannot figure out is how to paste the image I get in the clipboard into a different column. I’m also trying to iterate this process so the basic model would be “pull value from cell B2, use it as search term, copy image, paste image in cell A2, then move to cell B3”. If anyone has any ideas for potential solutions, please let me know.

Thank you for your time!

2

Hi @Turt, welcome to the Community.

Since you are able to achieve image copying part, I’d suggest you to give ‘Set Range Value’ activity a try.

Use this activity to set the value of that cell to the contents of the clipboard. To ensure that the image is pasted correctly, set the TypeArgument property to ‘System.Drawing.Image’. This will tell UiPath to treat the clipboard contents as an image.

Hope this helps,
Best Regards.

3

I cant find any such ‘Set Range Value’ activity in UiPath. I also have the same requirement. Is anybody able to acheive this?
Can this be done via APIs.