Writing data into existing sheet at the end

Help Studio
, ,
1

Hello, I noticed there is an AppendRow activity for sheets in Drive, but there isn’t an Append Range.

So I made my own version and for that I:

  1. Read the sheet and store it to a DT
  2. Get DT.Rows.Count and pass it as starting row in the Write Range activity.

But this doesn’t seem very performant if I have to read a hundred thousand of rows just to add a hundred ones.

And in the same way, the append row actually makes too many calls and there is a limit of calls per minute also.

Is there another way? Maybe a way to get the number of rows of a sheet without actually reading it so I can skip that part?

2

Hi @Palayn,

Once you have stored the values into the DT. Instead of using write range, try to use Append Range.

Append Range - this will append the rows into the existing sheet after the last row present in that sheet.
image

Try this out and let us know the update.

Regards,
@90s_Developer

3

Hello, thanks for the answer, but as I mentioned at the beginning, I’m talking about Sheets in Drive, there is no append range activity for that.

4

@Palayn,

Did you try to use this activity - Append Row
image

Regards,
@90s_Developer

5

@Palayn,

Check this out,

This is my sample spreadsheet value which I have called in the studio.
image

  1. In the GSuite Application Scope, after reading the excel through read range, you may try to use the Append Row activity and pass the required field details and in the row field pass your input value.
    Workflow Sample image
    image
    image357×688 15.6 KB

Output:
image

The value gets appended to the last of the existing row values.

I hope this would help you out to solve your issue. Update us, once you tried this method.

Regards,
@90s_Developer