Help - Remove similar and duplicates keywords

Questions
1

Hi, I’m creating this flow to remove similar and duplicate words from a Google Sheets spreadsheet.

My Problem: I want to delete 10 lines at a time, but the google sheets “delete” node does not delete 10, but several lines, it does not comply.

How the flow works: I take the words, pass them to the functions node, remove the duplicates, update the “new” column and remove the keywords that were used.

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

Hello @Edgard_Neto

Your workflow has some issues:

  1. your Update Node will be executed sooner than the deleted node and thus you will delete totally wrong rows.
  2. You should delete the rows in the reverse order because after you delete one row, the order of the next rows will change
  3. You can update the Code in a way that it will output start-end rows for each set of rows to delete to. In reverse order E.g. to delete rows 2-5, 7-9, 11-14 you should provide them as: 11-14, 7-9, 2-5
1 Like
4

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