Copy from google sheets pasting into chatgpt copy the response and paste into new google sheet

UI.Vision RPA
1

I have google sheet containing some records in single clm .I want copy content of each cell from sheet wait for response after getting response copy the response and pate into new sheet one by one but I don’t know how to apply the loop.
anyone’s help will be appreciated

{
“Name”: “tzat”,
“CreationDate”: “2023-11-18”,
“Commands”: [
{
“Command”: “open”,
“Target”: “https://docs.google.com/spreadsheets/d/1TyqfIzoJGJJNTfhmXhyIFpGlBcqGr9OjjzL0RiWHlhY/edit#gid=0”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “comment”,
“Target”: “echo // data=${c}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “click”,
“Target”: “/html/body/div[2]/div[8]/div[7]/div[3]/div[3]”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “storeText”,
“Target”: “/html/body/div[2]/div[8]/div[7]/div[3]/div[3]”,
“Value”: “c”,
“Description”: “”
},
{
“Command”: “open”,
“Target”: “https://chat.openai.com/”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “click”,
“Target”: “id=prompt-textarea”,
“Value”: “”,
“Targets”: [
“id=prompt-textarea”,
“xpath=//[@id="prompt-textarea"]",
“xpath=//textarea[@id=‘prompt-textarea’]”,
“xpath=//textarea”,
“css=#prompt-textarea”
],
“Description”: “”
},
{
“Command”: “click”,
“Target”: “xpath=//div[2]/div/button”,
“Value”: “”,
“Targets”: [
"xpath=//[@id="__next"]/div/div[2]/main/div[2]/div[2]/form/div/div[2]/div/button”,
“xpath=//div[2]/div/button”,
“css=#__next > div.relative.z-0.flex.h-full.w-full.overflow-hidden > div.relative.flex.h-full.max-w-full.flex-1.flex-col.overflow-hidden > main > div.flex.h-full.flex-col > div.w-full.pt-2.md:pt-0.border-t.md:border-t-0.gizmo:border-t-0.dark:border-white/20.md:border-transparent.md:dark:border-transparent.md:pl-2.gizmo:pl-0.gizmo:md:pl-0.md:w-[calc(100%-.5rem)] > form > div > div.flex.w-full.items-center > div > button”
],
“Description”: “”
},
{
“Command”: “type”,
“Target”: “id=prompt-textarea”,
“Value”: “${c}”,
“Description”: “”
},
{
“Command”: “pause”,
“Target”: “10000”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “click”,
“Target”: “xpath=//pre/div/div[2]”,
“Value”: “”,
“Targets”: [
“xpath=//[@id="__next"]/div/div[2]/main/div[2]/div/div/div/div/div[3]/div/div/div[2]/div[2]/div/div/div/pre/div/div[2]",
“xpath=//pre/div/div[2]”,
“css=#__next > div.relative.z-0.flex.h-full.w-full.overflow-hidden > div.relative.flex.h-full.max-w-full.flex-1.flex-col.overflow-hidden > main > div.flex.h-full.flex-col > div.flex-1.overflow-hidden > div > div > div > div.w-full.text-token-text-primary.border-b.border-black/10.gizmo:border-0.dark:border-gray-900/50.gizmo:dark:border-0.bg-gray-50.gizmo:bg-transparent.dark:bg-[#444654].gizmo:dark:bg-transparent > div > div > div.relative.flex.w-[calc(100%-50px)].flex-col.gizmo:w-full.lg:w-[calc(100%-115px)].agent-turn > div.flex-col.gap-1.md:gap-3 > div.flex.flex-grow.flex-col.max-w-full.gap-3.gizmo:gap-0 > div > div > pre > div > div.p-4.overflow-y-auto”
],
“Description”: “”
},
{
“Command”: “storeText”,
“Target”: “xpath=//pre/div/div[2]”,
“Value”: “d”,
“Description”: “”
},
{
“Command”: “echo”,
“Target”: “data=${d}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “open”,
“Target”: “https://docs.google.com/spreadsheets/d/1TyqfIzoJGJJNTfhmXhyIFpGlBcqGr9OjjzL0RiWHlhY/edit#gid=0”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “click”,
“Target”: “id=g3eim:2pt”,
“Value”: “”,
“Targets”: [
“id=g3eim:2pt”,
"xpath=//[@id="g3eim:2pt"]”,
“xpath=//div[@id=‘g3eim:2pt’]”,
“xpath=//td[3]/div/div[3]/div/div[2]”,
“css=#g3eim:2pt”
],
“Description”: “”
},
{
“Command”: “click”,
“Target”: “xpath=//div[3]/div[3]/div/div/div”,
“Value”: “”,
“Targets”: [
“xpath=//[@id="t-formula-bar-input"]/div",
“xpath=//div[3]/div[3]/div/div/div”,
“css=#t-formula-bar-input > div”
],
“Description”: “”
},
{
“Command”: “type”,
“Target”: "xpath=//[@id="t-formula-bar-input"]/div”,
“Value”: “${d}”,
“Targets”: [
“xpath=//*[@id="t-formula-bar-input"]/div”,
“xpath=//div[3]/div[3]/div/div/div”,
“css=#t-formula-bar-input > div”
],
“Description”: “”
},
{
“Command”: “comment”,
“Target”: “type // xpath=//div[3]/div[3]/div/div/div”,
“Value”: “${d}”,
“Description”: “”
}
]
}

2

The best solution is to convert Google Sheet to csv and then use it in ui vision

3

I tried that but its taking only one record at time in loop but i want atleast three records to copy.
{
“Name”: “chatgpt automation”,
“CreationDate”: “2023-11-20”,
“Commands”: [
{
“Command”: “open”,
“Target”: “https://chat.openai.com/”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “store”,
“Target”: “3”,
“Value”: “diffcounter”,
“Description”: “”
},
{
“Command”: “csvReadArray”,
“Target”: “hadapsar - sheet1.csv”,
“Value”: “myCSV”,
“Description”: “”
},
{
“Command”: “echo”,
“Target”: “Number of rows = ${!CsvReadMaxRow}”,
“Value”: “green”,
“Description”: “”
},
{
“Command”: “executeScript_Sandbox”,
“Target”: “return ${myCSV[0]}.length;”,
“Value”: “col”,
“Description”: “”
},
{
“Command”: “echo”,
“Target”: “Number of columns = ${col}”,
“Value”: “pink”,
“Description”: “”
},
{
“Command”: “comment”,
“Target”: “loop over all CSV values in the array”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “forEach”,
“Target”: “myCSV”,
“Value”: “row”,
“Description”: “With each loop, we copy a new array ROW into the ${row[0]} variable”
},
{
“Command”: “echo”,
“Target”: “url is ${row[0:1]}”,
“Value”: “brown”,
“Description”: “”
},
{
“Command”: “store”,
“Target”: “${row[0:1]}”,
“Value”: “s”,
“Description”: “”
},
{
“Command”: “type”,
“Target”: “id=prompt-textarea”,
“Value”: “${s}”,
“Targets”: [
“id=prompt-textarea”,
“xpath=//[@id="prompt-textarea"]",
“xpath=//textarea[@id=‘prompt-textarea’]”,
“xpath=//textarea”,
“css=#prompt-textarea”
],
“Description”: “”
},
{
“Command”: “click”,
“Target”: "xpath=//[@id="__next"]/div/div[2]/main/div[2]/div[2]/form/div/div/div/button”,
“Value”: “”,
“Targets”: [
“xpath=//*[@id="__next"]/div/div[2]/main/div[2]/div[2]/form/div/div/div/button”,
“xpath=//form/div/div/div/button”,
“css=#_next > div.relative.z-0.flex.h-full.w-full.overflow-hidden > div.relative.flex.h-full.max-w-full.flex-1.flex-col.overflow-hidden > main > div.flex.h-full.flex-col > div.w-full.pt-2.md:pt-0.border-t.md:border-t-0.gizmo:border-t-0.dark:border-white/20.md:border-transparent.md:dark:border-transparent.md:pl-2.gizmo:pl-0.gizmo:md:pl-0.md:w-[calc(100%-.5rem)] > form > div > div > div > button"
],
“Description”: “”
},
{
“Command”: “visualAssert”,
“Target”: "x90lzu.png”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “comment”,
“Target”: " click // xpath=//div[${diffcounter}]/div",
“Value”: “c”,
“Description”: “”
},
{
“Command”: “storeText”,
“Target”: “xpath=//div/div[3]/div/div”,
“Value”: “testvar”,
“Description”: “button click”
},
{
“Command”: “storeText”,
“Target”: “xpath=//div[${diffcounter}]/div”,
“Value”: “c”,
“Description”: “”
},
{
“Command”: “pause”,
“Target”: “3000”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “executeScript_Sandbox”,
“Target”: “return parseInt(${diffcounter}) +2 ;”,
“Value”: “diffcounter”,
“Description”: “”
},
{
“Command”: “echo”,
“Target”: “data=${c}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “store”,
“Target”: “${c}”,
“Value”: “!csvLine”,
“Description”: “”
},
{
“Command”: “csvSave”,
“Target”: “test auto.csv”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “comment”,
“Target”: “Perform other actions within the same chat, if needed”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “end”,
“Target”: “”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “”,
“Target”: “”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “”,
“Target”: “”,
“Value”: “”,
“Description”: “”
}
]
}

4

my code is storing one row at time i want to store multiple row from csv at time can you help me ?
here is my code
strong text{
“Name”: “chatgpt”,
“CreationDate”: “2023-12-4”,
“Commands”: [
{
“Command”: “open”,
“Target”: “https://chat.openai.com/c/8ec7caa0-3a3e-4e18-b62a-388028aa4d2a”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “store”,
“Target”: “3”,
“Value”: “diffcounter”,
“Description”: “”
},
{
“Command”: “csvReadArray”,
“Target”: “untitled spreadsheet - sheet1 (3).csv”,
“Value”: “myCSV”,
“Description”: “”
},
{
“Command”: “echo”,
“Target”: “Number of rows = ${!CsvReadMaxRow}”,
“Value”: “green”,
“Description”: “”
},
{
“Command”: “executeScript_Sandbox”,
“Target”: “return ${myCSV[0]}.length;”,
“Value”: “col”,
“Description”: “”
},
{
“Command”: “echo”,
“Target”: “Number of columns = ${col}”,
“Value”: “pink”,
“Description”: “”
},
{
“Command”: “comment”,
“Target”: “loop over all CSV values in the array”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “forEach”,
“Target”: “myCSV”,
“Value”: “row”,
“Description”: “With each loop, we copy a new array ROW into the ${row[0]} variable”
},
{
“Command”: “echo”,
“Target”: “url is ${row[0]}”,
“Value”: “brown”,
“Description”: “”
},
{
“Command”: “store”,
“Target”: “${row[0]}”,
“Value”: “s”,
“Description”: “”
},
{
“Command”: “type”,
“Target”: “id=prompt-textarea”,
“Value”: “${s}”,
“Targets”: [
“id=prompt-textarea”,
“xpath=//[@id="prompt-textarea"]",
“xpath=//textarea[@id=‘prompt-textarea’]”,
“xpath=//textarea”,
“css=#prompt-textarea”
],
“Description”: “”
},
{
“Command”: “click”,
“Target”: "xpath=//[@id="__next"]/div/div[2]/main/div[2]/div[2]/form/div/div/div/button”,
“Value”: “”,
“Targets”: [
“xpath=//*[@id="__next"]/div/div[2]/main/div[2]/div[2]/form/div/div/div/button”,
“xpath=//form/div/div/div/button”,
“css=#__next > div.relative.z-0.flex.h-full.w-full.overflow-hidden > div.relative.flex.h-full.max-w-full.flex-1.flex-col.overflow-hidden > main > div.flex.h-full.flex-col > div.w-full.pt-2.md:pt-0.dark:border-white/20.md:border-transparent.md:dark:border-transparent.md:w-[calc(100%-.5rem)] > form > div > div > div > button”
],
“Description”: “”
},
{
“Command”: “comment”,
“Target”: “visualAssert // zjusfz_dpi_96.png”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “pause”,
“Target”: “15000”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “storeText”,
“Target”: “xpath=//div/div[${diffcounter}]/div/div”,
“Value”: “c”,
“Description”: “”
},
{
“Command”: “executeScript_Sandbox”,
“Target”: “return parseInt(${diffcounter}) +2 ;”,
“Value”: “diffcounter”,
“Description”: “”
},
{
“Command”: “echo”,
“Target”: “data=${c}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “store”,
“Target”: “${c}”,
“Value”: “!csvLine”,
“Description”: “”
},
{
“Command”: “csvSave”,
“Target”: “test auto - sheet1.csv”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “comment”,
“Target”: “Perform other actions within the same chat, if needed”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “end”,
“Target”: “”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “”,
“Target”: “”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “”,
“Target”: “”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “”,
“Target”: “”,
“Value”: “”,
“Description”: “”
}
]
}

5

Hi

The code you wrote is too confusing in my opinion, if you need to perform a simple copy and paste of data it is much simpler to use the “csvRead” command

I believe the code can be greatly simplified and the work can be done with a few lines of code more efficiently