Automatic Workflows

Questions
,
1

Hello Folks,

I am integrating postgres and airtable to allow automatic syncing whenever a change has been made in either of them. However my syncing are not done automatically, I have click on execute workflow for that to happen.

NB: My workflow is active

Any ideas on how to make the workflow to be executed automatically would be highly appreciated.

3

Welcome to the community @Anton_Odongo!

Did you activate the workflow?

Possible via the toggle on the top right on the screen:
Screenshot from 2023-08-09 13-54-23

4

If I understood correctly, you are looking for some kind of trigger which “fires” every time new record is added / updated / deleted in either of the source.

I’d say there are ways of making this:

  1. Put Airtable trigger to catch changes from AT. On the Postgres side, you can create a trigger in the database that makes an HTTP Request. You can put both triggers in a single workflow and start synching process whenever one of them is activated.
  2. Put a schedule trigger that checks both sources every N minutes / hours. I think both AT and Postgres have a “date modified” variable which can be used to identify the latest changes. If there are any records which were added / changed within the last N mins / hours, then they should be synched. With the deleted records it’s a bit trickier, I think the only way is via outgoing trigger from AT / Postgres.
1 Like
5

I did activate my workflow

6

I have an airtable trigger which checks for any update/insertion every minute and I have activated the workflow too but still it is not automatic as required.

for postgress I havea postgress trigger which checks for any insertion and sends to airtable but that too is not automatic yet my workflow is active

7

Hi @Anton_Odongo, I am sorry you are having trouble.

Perhaps you can share a few more details here? Which version of n8n are you currently using, how does your workflow look like and are there any errors when inspecting past executions?