How to write to next cell in google sheets?

Help StudioX
,
1

Hello,

I need to write a column of data into the same column every week without overwriting what was previously written. How do I automate this? Write range asks for the starting cell and I can’t figure out how to make it the next open cell. Thanks.

2

Hi,

Can you try the following step?

  1. Read table as datatable using ReadRange. (Let’s say dt)
  2. Get number of rows of the datatable ( numberOfRows = dt.Rows.Count)
  3. Write target cell using WriteCell activity with the variable. Cell Address will be like "A"+(numberOfRows+2).ToString , for example. (Please modify column letter and offset value(2))

Regards,

3

Hi
->First get the rows count from Data Table using rowIndex=dt.Rows.Count
→ next you can use the “Write Cell” activity with a cell address like “CellName” + (rowIndex + 2).ToString() to write data to the next available cell.

Thak you

4

Hi thanks so much for responding. Are you able to include screenshots? I’m thinking I have to create a variable for the second step but don’t know what activity you’re using or how to do it. Thanks you!

5

Hi thanks so much for responding. How exactly are you using the data table rowindex section? Could you provide a screenshot per chance? Thanks you!

6

Hi,

Hope the following helps you.

image
image981×743 35.1 KB

Regards,