I want to create loop for Google Sheets

UI.Vision RPA HowTo
,
1

I want to create an automation for Google Sheets.
First, pick a text and then paste it on its front cell. I want to create a loop for it. I mean it automatically goes down for the next row.

2

@admin can you help me

3

To make such a macro you have to mix desktop automation and web automation together.
Nobody can do it for you, you have to study the ui vision documentation well.
I have created a macro that copies the cells of Excel and I tell you from now that it is very complex because you have to find a way to mark the row where you have arrived.
A simpler solution is to copy the cells and save them in csv.
Such a macro takes a long time to make and also requires fixing various focus-related issues.

This is an example of the macro code to create

{
“Command”: “comment”,
“Target”: “Start Desktop Automation”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “XType”,
“Target”: “${KEY_ESC}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “XType”,
“Target”: “${KEY_CTRL+KEY_HOME}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “XType”,
“Target”: “${KEY_ALT}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “XType”,
“Target”: “${KEY_RIGHT}${KEY_RIGHT}${KEY_RIGHT}${KEY_RIGHT}${KEY_RIGHT}${KEY_RIGHT}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “XType”,
“Target”: “${KEY_ENTER}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “pause”,
“Target”: “1000”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “XType”,
“Target”: “${KEY_F}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “XType”,
“Target”: “${KEY_ENTER}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “pause”,
“Target”: “1000”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “XType”,
“Target”: “${KEY_D}”,
“Value”: “”,
“Description”: “”
},