How to handle duplicates in Google sheet?

Questions
1

Describe the problem/error/question

I am extremely new to n8n and workflow building. While trying to learn I built a workflow, which get rows from an existing google sheet. The data comes as first name and last name and email. Then i used a edit field to combine first name and last name creating a new column called full name. then used the update row in a sheet node to update the new column data. However, i noticed that in the google sheet the duplicate raws have no value for the new full name column. not sure why it is happening.

What is the error message (if any)?

None

Please share your workflow

Information on your n8n setup

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

Can you pls edit your workflow and output into a code-block?
you can add code-block by clicking the </> icon
image

3

What is the purpose of it ?

4

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