Append range in Gsuite - google sheets file

Hello!

I copied data from a website (a datatable) and store them as datatable variable, then I added them in a google sheets file. My problem is that the data is overwritten with each extraction and I need to append every extraction to keep them all.
I tried “Append range” but I saw it worked only with Excel files.
Is there another activity that works with google sheets files?
Or another way to append data in my sheets file?
Thank you very much!

Ruxandra

Hello @Ruxandra_Zamfir

You can use the GSuite activities.

Thanks

Hello @Ruxandra_Zamfir ,

Under the Gsuite package there is an activity called Append Row is available, you can use that one.
image

Thanks,
Sanjit

Hi @Ruxandra_Zamfir

You can try with Write Range activity

Check out the XAML file

image

GSuiteAutomation.xaml (11.7 KB)

Check out this tutorial fro more information of configuration

Regards
Gokul

Hello!

Thank you for your answer. Append row needs a array variable, I used Table Extraction and I have a datatable variable. I tried to convert it in array, but I have errors.
Thank you!
Ruxandra

@Ruxandra_Zamfir try this way
image

Hello!

Thank you for your answer. I tried to open your xaml, but it doesn’t work, it seems I have not the activity. I’ve already use Write range activity, it works, but it doesn’t append more ranges, it It overwrites them.
I can read very well your print-screen.

Thank you!

Ruxandra

What is issue while opening the XAML file?

In the if activity (You should need to give any one of the column name of the G-Suite spreadsheet)

It will work, i have test the process in my environment.

In the Write Range pass the Starting cell based on the needing.

Regards
gokul

Thank you! It works.
Have a nice day!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.