How to clear sheet and append new data

hello, i want to know on how do i append new data in gsheet and before appending new data i want to delete all existing content in all rows except the header. i’ve tried using if node, if its empty then i append but it reads the header so it always fall in false branch.

if gsheet is empty then i want to append new data from edit fields, then if its not empty i want to remove all content except the header(Row1)

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, have you tried appending the header every time you append new data from edit fields? This way, you can clear the Google sheet without leaving the header row. If this doesn’t work for your specific workflow, could you share your workflow or parts of your workflow which will help the community better understand where you’re stuck on.