Hi,
I have set up a scenario to extract two separate arrays from an API using an HTTP request. However, I have had to use two separate HTTP requests which is causing issue getting this into Google Sheets.
When testing the first Request, this imported fine into google sheets using the ’ Add a row’ function. I then tried to set up a second router to run the second request, but the Second 'Add a Row ’ adds the new data to the bottom of the sheet and not into the top row.
Is anyone able to help with this? I have attached a photo of the sheet and the scenario.
Kind Regards,
Connor
1 Like
If you want to add the data to the persons row. You will need to use In route 2
- Search rows - search for the row with the data (name)
- Update a row module not add a row and select the row it found and update Column D there.
If your using 2 add a row modules you will only add new rows not update any existing.
Thank you for your response. I have tried this which fills the rows correctly but it is not cycling through the data from the iterator, instead just pasting the first bit of data 20 times to fill the required rows.
I searched the Google sheet using the correct column and ‘Does not exist’, with a maximum number of results of 20 as there are 20 empty rows in the table.
I have attached the result and the update row module.
Any help would be appreciated, still quite new at this.
1 Like
You could probably do it this way, with one iterator-aggregator pair, and a bulk add rows module.
In the aggregator, you will have to use the iterator’s “Bundle order position” variable to reference the respective second un-iterated array’s values.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!