N8n automation to backup your SeaTable Bases

Hey everyone,

Inspired by a customer, I’ve built a new n8n automation. Its purpose is to run every night, check for updated bases, and save the dtable files to an external storage. This might provide double protection:

Important: This automation requires the community node SeaAdmin and a system administrator account. Therefore, this workflow is only suitable for self-hosted systems.

3 Likes

I just implemented this and figured out, that updated_at is the timestamp when the base was updated, not any of the content in the base. Is that correct? I’ve got this base that gets updated every single day, still the timestamp of updated_at says it’s 113 days old.

Dear vqui,
you’re right. The value “updated_at” is not updated if the content of the base changes. Only if the base name or the color of the base changes. But that is definately not how it should be.

Give me some days to clarify how we could solve this.

One more information. the value “updated_at” of the base changes if:

  • the base name changes.
  • the colour or the icon of the base changes.
  • if something happens in a file or image column.

But other changes in the base does not update this value.

As I said, give me some time to clarify this.

Great news! The proposed n8n workflow to back up SeaTable bases, was not really working, because the value updated_at did not necessary change, if some values were updated inside the base. This makes the workflow less useful.

BUT…
With the upcoming version 5.2, the value updated_at will change if you change any values inside the base, which means you can use this n8n backup workflow. Version 5.2 will be available on February 25th 2025. :partying_face: :tada:

Best regards
Christoph

1 Like

Looking forward to the new version of SeaTable!!

Which new features will be implemented?

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