Connecting via Integromat

Integromat allows you to integrate and automate workflows across various online apps, including automated queries on bit.io.

First, create a new scenario:

15761576

Then, select the PostgreSQL integration for the operation that you'd like to perform with bit.io. Here, we will run a SELECT operation to query data to Integromat.

13061306

Then, go your bit.io repo page and click on the green Connect button in the upper left. You'll want to copy the password from that screen.

12161216

Now, add a new connection in Integromat and enter the bit.io connection parameters from your bit.io repo page. You will see a long list of tables in the drop-down — this includes both your own tables and all public tables on bit.io. By default, tables on bit.io are private, but many users have opted to publish their tables which is why you can see them here.

811811

Finally, follow the Integromat UI to configure your query. From here, you can export the query results to other Integromat integrations and set up a schedule for automated execution.

818818

Did this page help you?