Update spreasheet after several API calls

Questions
1

Hi! I’m trying to update several rows of my spreadsheet after calling different APIs (using several HTTPS nodes).

Do I have to use a Spreadsheet Read node, every time I call one of the API’s (using a separate HTTPS node)?

In other words, my spreasheet rows need to be enriched by data coming from 2-3 different API calls. What is the optima way to achieve this?

Thanks

2

Hi @Juan_Ramirez Welcome to n8n :n8n: community :tada:


It depends on the data you plan to add to the spreadsheet. If all the data is intended for the same row, you can merge the API responses and then update that row.

However, if the data needs to be distributed across multiple rows, you will have to call the Google Sheets update row node more than once.

In any case, n8n automatically handles workflows that include more than one input item with just one node.

If you have a real workflow, feel free to share it and we can explain the process in greater detail…

2 Likes
3

Thanks, Mo. I needed to play more with the nodes, had not tried merge :slight_smile:

1 Like
4

URW, the more you try things, the more you understand how things work, GL :wink:

5

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