How to insert delete a Google Sheet and insert data

Questions
1

I have a set of items which I want to update a Google Sheet with. Therefore I have to delete all rows from the previous update. When I create a delete node I have to set it to “execute once” in order to avoid the Google rate limits (and for a cleaner operating workflow, too). But then I will have only the first item for the consecutive update node.

When I split the flow into a second edge that connects the source node with the delete node and a merge node then this gets an additional item from the delete node.

So what is the most elegant and common and GUI based way to get over this common task?

Here is what I’ve set up so far:

image
image2070×607 60.3 KB

Thank You very much in advance.
-Robbit.

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.65.2
  • Database (default: SQLite): (where to find out within GUI?)
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Windows 11
2

Welcome to the community @Robbit !

Tip for sharing information

Pasting your n8n workflow

Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.

```
<your workflow>
```

That implies to any JSON output you would like to share with us.

Make sure that you have removed any sensitive information from your workflow and include dummy or pinned data with it!

I believe your Merge node is not configured correctly. You need “Choose Branch” mode with “Use Data of Input” set to 2.

1 Like
3

Great! That works fine. Thank You. :blush:

4

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