Hi @Sandra,
The formula looks good, however, it is not supported through the API and I presume that it runs just fine if you run it in Airtable directly. You need to slightly update the formula so that it works via the Make Module. What you want to do is, structure your formula like this,
RIGHT({Email},LEN({Email})-FIND(‘@’,{Email}))=“gmail.com”
And, the second section i.e gmail.com needs to be evaluated on make itself, which you can do by using,
{{last(split(2.email; "@"))}}
So, your overall formula in Airtable Module will look like,
RIGHT({Email},LEN({Email})-FIND('@',{Email}))="{{last(split(2.email; "@"))}}"
P.S > Repace Email with your Airtable Column Name.