N8n - Insert or Update?

Baserow Help
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What do you need help with?

Hello, I would like to create a simple n8n workflow like this one ; Exploring Airtable alternatives led me recently to SeaTable and it turned out to be an interesting discovery worth sharing. | n8n About and test if a record exists or not, then use the update or insert method accordingly.
I was not able to do it in the past (months ago). Is this possible now ?
Thanks for your help,
Stéphane

2

Hi,

This should already be possible for a long time with n8n.

  • Step 1: get the record based on the id (Get a row node) or based on a filter (Get many rows node)
  • Step 2: check if the result is empty or not (if node)
  • Step 2a: if the result is empty → insert the record (Create a row node)
  • Step 2b: if the result is not empty → update the record (Update a row node) based in the id that was returned in Step 2
3

Tested, … happy to see it works now !

Thanks,