Add Data row and not overwriting the 1st row on googlesheet

Learning & Development Programs Automation Starter
, ,
1

hi,
i have this process;
read range → open browser → scrape data - → write range

im stuck with writing range, after the 1st process. robot wont input the scraped data to the 2nd row of the google sheet. it overwrite the 1st row. . any help on this. thank you

2

Hey!

Could you please show us the flow here?

Don’t use Write range in the loop…

Use write range outside the loop…

Regards,
NaNi

3

here’s my process looks like:

image
image955×778 24.2 KB

image
image
image891×793 32.7 KB

image
image760×723 20.8 KB

4

Hey!

Every thing is inside the loop…

Try like this:

  1. Temp DataTable
  2. Read range
  3. For each row
  4. Open browser
  5. Data Scraping
  6. Add data row
  7. Close window

end of the for loop use Write range

5

image
there seems to be a problem with the variable for data table when it’s outside the loop.

6

Hey!

Change the scope of the variable…

Just navigate to Extract structured data activity click that activity… navigate to variables panel change the scope of that panel that’s it

Regards,
NaNi

7

image

image
image780×308 15.6 KB

Hi,
already tried excluding the write range of the loop. it run, but still it overwrite the first row.

8

i cant close also the browser in every loop because i need to log in every time oppening the website.