Whitelist Members

Hi everyone!
I’m building an app connected to an existing CRM. The CRM has a real-time list of members to a service. What I want is to 1) sync the list of active members’ emails and 2) check if the current user is an active member based on the imported list.

I would probably use zapier to sync the CRM to a spreadsheet, and then into a DB to Bubble. However, I’m not sure how to do this either. So my questions are:

  1. How can I create a workflow that syncs all emails into a DB called “Whitelist emails”
  2. How can I create a worflow that checks if curren’t user’s email is inside the whitelist of emails
  3. IF yes, how can I change the current user’s status to Member or Not Member based on that whitelist

Any ideas or just pointing me in the right direction would be of huge help!

This topic was automatically closed after 70 days. New replies are no longer allowed.