How to integrate data into Supabase with Windsor.ai

Supabase is a development platform that helps developers build applications without having to create and manage most of the backend infrastructure themselves. It is built around PostgreSQL, a powerful relational SQL database.

Windsor.ai turns Supabase into a centralized analytics database that automatically stays up to date with data from hundreds of external services.

1. Create your Supabase account if you don’t have one.

2. Log in to your Windsor.ai account or register if you don’t have one.

3. Select the data source from which you want to streaom data, e.g., Facebook Ads. Sign in with your associated Facebook account and click the Next button.

4. Select the Filters and Fields you’d like to send to Supabase for analysis.

4. Scroll down to data destinations and click Supabase.

5. Click the Add Destination Task button.

5. Click the Connect Supabase button.

6. Enter all the required Supabase credentials if you are not logged in and click the Authorize Windsor.ai button:

7. Select the Supabase account and Supabase project you want to export your data into.

8. Fill in the Task name, Supabase password (PostgreSQL password), and Supabase table name fields.

9. Click the Test Connection button. If the connection is set properly, you’ll see a success message at the bottom; otherwise, an error message will appear. When successful, click the Save button in the lower-right corner of the form. The data stream to the Supabase database will start.

10. You can now see the task running in the selected data destination section.

11. Open your Supabase account to verify that your data has been imported.