Matching ChatGPT replies to correct field in Google Sheets

Questions
1

I am very new to N8N and love the platform, so I’m sure this is a very dumb fix, I’m just not sure how to go about it.

I am attempting to match outputs from OpenAI to a specific field in Google Sheets (Column E, “reply” and have them match their corresponding comments (note_url)

The issue is the data is misaligned and not starting at the top of the reply column. I thought I could just specify that I wanted the replies to go to Column E but didn’t see that option.

googlesheetsreplies
googlesheetsreplies1059×699 160 KB

Workflow

image
image1519×811 45.8 KB

Last node in the workflow

image
image1824×1037 135 KB

If I have to pass the note_url data to get it to match I’m unsure how to do that since the output is coming from ChatGPT.

TIA!

  • 1.103.1
  • Database (default: SQLite)
  • n8n EXECUTIONS_PROCESS setting (default: own, main)
  • Running n8n via Docker Desktop
  • Windows 10
2

Dear @moxnox Welcome to the community.

Now regarding the problem that you are facing. Just instead of selecting matching column as relay.

Select author as matching column.

As what matching column really means.

So matching column just try to match the recent output from the previous output to decided which column to update.

and as you have selected relay as matching column which never exist in the previous module that’s why the problem happening here.

so just select author as matching replay.

Now, if you are still confused, I will love to help you solve it out.

For this can you please share your workflow here.

Here is how to share your workflow

Share your workflow

Happy to help…