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!
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
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.