N8n google Sheet error

I’m trying to set up an automation, where the images are retrieved from my Google Drive, and the prompts for the images are also retrieved from google Sheets. currently, I have 3 images, and 2 prompts in my Google Drive, and Google sheet respectively. I want to run all the prompts for each image. I can’t seem to get this, as the google sheet is duplicating the prompts, and returning 6 items instead of 2. Can anybody help with what I’m doing wrong here. Thanks

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:

Open the google sheet node, go to the settings tab and enable the checkbox called “Execute Once”

Thanks Barn. It’s now returning two prompts from the sheet. One thing I am having an issue with is instead of sending the two prompts, for the three images in my drive, it is only sending data for just the two prompts, and giving just two prompts instead of 3

In that way I’ll suggest to use the Merge node and connect the Google Drive and Google Sheet to it. So it would be 6 items in the output (3 files x 2 promps each)

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