Why is it like this?

what i want to do is to clear all contents inside this specific sheet, and append new rows in that same sheet. but this gsheet clear node keeps on running and doesn’t stop.

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:

Hi @Everett_Sobinsky, could you share your workflow JSON or share more details about the specific Google Sheets node you’re having issues with? Also, have you tried rearranging the nodes so that you clear the Google Sheet node first and then append the Google sheet row after that, instead of running these nodes at the same time?

1 Like

hello @Everett_Sobinsky

First issue: Turn on the Google Sheets1 node option Execute only once, as of now, it will clear the sheet 151 times :sweat_smile:

Second issue: as @aya mentioned, keep clear sheets and append operations one after another, otherwise you may encounter the situation when the append will be executed first, and then the sheet gets cleared.

Third issue: You will receive 151 messages in the telegram (maybe it has been made by design)

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