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).
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.
Next, select and event type.
Enter your Postgres credentials, which can be found on the bit.io Connect Tab
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.
For more info on Zapier's PostgreSQL integrations, check out their docs
Updated about 1 month ago