Issue with "Write Cell" Function (Google Sheet)

Help Cloud Robots
, ,
1

Hello everyone,

I’m reaching out because I’m facing an issue with an RPA workflow.
I’m currently following the course “Get Started with UiPath Studio Web”, and I’m working on the first exercise: “Build your first automation”.

In this exercise, I need to interact with both a web page and a Google Spreadsheet.
The goal is to:

  1. Extract data from the spreadsheet
  2. Populate the relevant fields on the web page
  3. Generate a Unicorn name
  4. Update each Unicorn name back in the spreadsheet (For Each Row process)

So far, I’ve managed to generate the Unicorn name using the spreadsheet inputs, and I can retrieve the generated name successfully.
However, I’m stuck at the final step: updating the Unicorn name in the spreadsheet.

Here’s the issue:
When I run the automation, it updates only the A1 cell in the spreadsheet with the last Unicorn name, even though the Write Cell activity is included inside the For Each Row block. It seems as if the Write Cell is outside of the loop.

From what I can see, everything in my workflow looks correct, so I’m wondering if this could be an issue related to Google Cloud integration or something I’m missing in the loop logic.

Any ideas ? :slight_smile:

Thank you !

3

With screens (process and final Spreadsheet)

Capture d’écran 2025-09-08 à 21.04.13
Capture d’écran 2025-09-08 à 21.04.131038×1548 190 KB

4

Check the CurrentRow.UnicornName cell like what it returns. I think it is returning the static cell value in which your process is continuously overwritting the data.

Cheers

5
  1. Read the spreadsheet → Read Range → store in DataTable(e.g., dtUnicorns).
  2. For Each Row in dtUnicorns:
  • Generate the Unicorn name.
  • Update the DataTable column:

row(“UnicornName”) = generatedName

  1. After the loop, use Write Range to update the spreadsheet (do Not use Write Cell inside the loop).
6

@Simon_DA_ROS

you need tp pass the address not the column alone

Screenshot 2025-09-09 at 11.52.03 AM
Screenshot 2025-09-09 at 11.52.03 AM1248×270 12 KB

Screenshot 2025-09-09 at 11.52.08 AM
Screenshot 2025-09-09 at 11.52.08 AM278×392 2.73 KB

cheers

1 Like
7

I’m also stuck with the same step, the same issue with Microsoft 365. Do you have any updates?

8

Hi @Anil_G, thank you !! It’s working, it has to be the address :slight_smile:

1 Like
9

@Simon_DA_ROS

Glad it helped

Happy Automation

cheers

10

What’s the solution if I’m using Microsoft 365 workbook?

1 Like
11

@Indhu_C_N

Even that has a similar attribute…just use currentrow. and it would pop it

cheers