To check usage status in Airtable and provide magic link in Bubble.io

I’m integrating my Bubble.io app with Airtable, where I receive data from a sales platform via webhook and store it in Airtable. I would like to know how to check the status of a user in Airtable when they try to access the app. If the user is active, I want to send a magic login link to the registered email. If they are not active, I would like to display a warning in the browser. How can I configure this logic in Bubble.io?