How to use clear feature in google sheets?

"I want to set up a workflow:

  1. First, use a code node to obtain the data I need.
  2. Delete the data in the first sheet of the spreadsheet (except for the first row).
  3. Update the spreadsheet with the data obtained from step 1.

How should I set up this workflow? If I use the ‘Clear’ function in Google Sheets to delete and then use ‘Update’ to input new data, it seems that it won’t work."

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 @dangkabang52585258,

Welcome to the community! :sparkles:

Could you provide the workflow you have so far? It would make it easier to help you if I can see exactly what you mean.
For example, are you sending the data from the code node to a google sheet? Or editing it first and sending it already edited?

이미지 11

That example wouldn’t work.

This one does:

thank you so much