How to import zapier data to Weweb and Supabase

Ask us anything
, ,
1

I’m new to WeWeb

I’m trying to use Zapier to extract data from a certain type of email using the GmailAPI.

What I can’t figure out is how to update my Supabase database with the information extracted from the email in Zapier.

I understand WebHooks are the way forward but an explanation for a newbie would be appreciated.

I’ve already set up the table where the information can be populated inside Supabase. I have also set up a related collection to reference this called collection-zapier.

I have tried creating a workflow but don’t see how that is triggered?

Any help appreciated!

2

@Paul007 - Zapier would insert the data directly into Supabase, it wouldn’t go through weweb (unless you’re triggering your zap from weweb with a variable).

I’m not super familiar with Zapier (I’m more of a make.com guy), but it doesn’t look like they have a direct integration with Supabase. You’ll need to use the PostgreSQL zapier integration (Since Supabase is a PostgreSQL database). If you connect it to Supabase via your project url and probably anon key you should be able to insert the data directly to supabase.

Then you’d use WeWeb to display that table.

Hope that points you in the right direction.

3

Just use the Supabase’s REST API, don’t run Postgres queries as suggested above, because you can bomb your DB with one small mistake.

4

Thanks for your reply, esowers. That’s great, I appreciate the time you have taken to reply. Bteween you and Broberto, hopefully I’ll have some luck!

5

Thanks Broberto!

I’ll take a look at your method closer and see how I get on :slight_smile: