Zapier is a workflow automation tool that allows you to connect triggers to actions to create powerful automated processes. By connecting Zapier to bit.io, you could have new row inserts in your database trigger a facebook post, for example (read from Postgres). You could also set up a Zap that would trigger when you receive an email from a specific sender, and increment an integer in a specific row in your Postgres database (write to Postgres).

Connecting to bit.io with Zapier

In order to connect Zapier with bit.io, you'll need to find your PostgreSQL connection credentials from the bit.io Connect Tab of the database to which you would like to connect. You can find everything you need to know about your PostgreSQL credentials here

To get started, first select PostgreSQL as a trigger.

35923592

Select PostgreSQL as a trigger

Next, select and event type.

35923592

Select an event type

Enter your Postgres credentials, which can be found on the bit.io Connect Tab

22422242

Enter your credentials. Please see note below about database name change.

🚧

You must change the database name!

Database names on bit.io are typically in the format [username]/[database_name]. Zapier's Postgres client does not support "/"'s in the database name, so you must change this to [username].[database_name].

Once the "/" is replaced with a ".", all other credential's from bit.io's connect tab should work unchanged

Lastly, test your trigger. You're now ready to start working with actions.

35923592

Test your trigger and start playing with actions!

For more info on Zapier's PostgreSQL integrations, check out their docs


Did this page help you?