How to process each row in google sheets, and not get any https error in next steps

Questions
, ,
1

image
image1035×675 35.6 KB

I am not able make Http request, it shows error all the time.

Example here separately when i test open AI node works.

But when i use it in sequence after google sheets and uses some parameters in the prompt it doesnt work.

Do i have to use looping module to process each row from google sheets ?

For this i am using self hosted n8n ,
didnt connect to an sql database
running docker via npm
windows operating system.

plz anyone can tell me how to fix this? i want to process each row in the google sheets.

For this do i need to use Loops or try other configuration.

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

What happens when you say it doesn’t work? What error are you getting?

4

Hey @M_Tanusri

You have two options. You can either aggregate all rows and pass them all together or you can loop through each and process them one by one. It really depends on what you want to do.

If you want to do a summary of the content of the spreadsheet, or analysis you should aggregate and process at once.
If you want to perform an action (i.e. send email) for each row you should use the loop.

Here is an example for both:

5

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