Create lead events in Facebook Conversions from new rows with custom queries in PostgreSQL

First, we need to connect PostgreSQL and Facebook Conversions to Zapier.

• 

  Create Zapier account.

  Create Zapier account if you don't have one.

• 

  Connect PostgreSQL to Zapier.

  Give Zapier access to your PostgreSQL account, using PostgreSQL credentials.

• 

  Connect Facebook Conversions to Zapier.

  Give Zapier access to your Facebook Conversions account, using Facebook Conversions credentials.

Next, we need to create a workflow automation scenario using graphical no-code web interface of Zapier.

• 

  Set up a Trigger action for PostgreSQL

  Choose the following trigger: New Row (Custom Query) (Triggered when new rows are returned from a custom query that you provide. **Advanced Users Only**).

• 

  Then set up an Action for Facebook Conversions

  Choose this action: Send Lead Event (Publish lead events to Conversions API).

Finally, we need to test this automation and publish it.

• 

  Customize data flow

  Configure the data that is exchanged between PostgreSQL and Facebook Conversions.

• 

  Test the workflow and turn it on for production use

  Test your scenario and publish to production. Now you have an automatic workflow, that will Create lead events in Facebook Conversions from new rows with custom queries in PostgreSQL!