Looping over google sheet cells with Open AI

[Ngozi_Dozie]

Describe the problem/error/question

I’m working on a workflow where I process rows from a Google Sheet, evaluate text in each column with OpenAI, and save the responses back to the same row.

My Use Case:

• I have a Google Sheet with five columns (q1 to q5), each containing answers to interview questions.

• I want to evaluate each answer using a different OpenAI prompt (e.g., prompt1 for q1, prompt2 for q2, etc.).

• I’d like to save the generated responses in new columns (F to J) of the same row.

What I’ve Done So Far:

• Used the Google Sheets Node to fetch rows.

• Created a Set Node to store the prompts. And using a Loop to select each row at a time

• Planned to use the OpenAI Node for evaluation.

Challenges:

1. How can I skip the header row?

2. What’s the best way to process each cell (q1 to q5) with its corresponding prompt?

3. How do I ensure that responses are saved back to the correct row?

Workflow Export:

[Link to workflow JSON or paste JSON here]

Any advice or suggestions would be greatly appreciated!

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

![Screenshot 2024-12-31 at 07.33.25|690x255](upload://9bWOIWmdqTZYZHQiltvlt9Z4hmC.png)

(for some reason pasting code giving me an error)

Share the output returned by the last node

Information on your n8n setup

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

[n8n]

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:

[ihortom]

Hey @Ngozi_Dozie , it doesn’t look like you have shared the workflow. You seem to have tried to paste the screenshot but that didn’t work as you psted it in the wrong place of the template presumably (between pair of triple backticks).