Search Airtable, add new record if record doesn't exist

Hello Community,

I’m needing to search my airtable to see if a record exists, then add a record if it does not exist.

I believe in the Make Academy we did something similar with Google Sheets but I can’t remember and I’m wondering if someone could please direct me back to this lesson or tell me how to do it?

I am scraping a website and getting user IDs and want to add the ID to my airtable if it isn’t in there already but not record it if it already exists.

I know I need to use search record module and create record module and a filter but not sure how to set it up.

Any help would be greatly appreciated!

Thanks,

Mark