Hello Guys,
I hope someone can help me with this topic. I worked till now hours and dont see any success by my own.
I have this scenario, where I want to get Data from a Spreadsheet “X” and want to paste the data into a spreadsheet “Y”. I already managed to set up the “Get range value module” and it has round about 2000 Boundles. therefore I dont want to use the “Update a Row” Module for cost effectiveness.
Afterwards I have the Text Aggregator Module The Output afterwards is this:
After that I want to make the API Call, but the data should be pasted in a specific Sheet in the Spreadsheet and in a specific Columm. The Data should be posted in the Line between: L2 and AN - since the first spreadsheet is not fixed I dont have a specific number fo the end.
The API Module look like this:
Thats the error that occurs right now.
I tried to use tipps and solutions from other Videos and Posts here on the Community but nothing seems to work. I dont know even now, that if its possible. To do that. If you need more Information, please right me.
Here is one topic where I oriented: Insert multiple rows in Google Spreadsheets from HTTP request that give xml of products - #2 by EyalGershon
