# Make integration - How to check if email already exists before adding a new row to Glide table **URL:** \ **Category:** Ask for Help\ **Tags:** make\ **Created:** [June 18, 2024, 10:48am UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204 "2024-06-18T10:48:46Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![schrutefarms](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/schrutefarms/32/59686_2.png) [@schrutefarms](https://community.glideapps.com/u/schrutefarms)\ **Post date:** [June 18, 2024, 10:48am UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/1 "2024-06-18T10:48:46Z")
Hi everyone, Just started playing around with the new Make integration. Very exciting 😃 I am currently using it to import email leads into a Contacts table in my Glide app. I would like to set up some kind of filter or similar in make where it checks whether a contact with the same email address (as in the incoming email lead) already exists in my Glide table. If it does not exist, I would like to add a new row to the table, if it already exists I would like it to take a different route in my Make scenario. Not sure if this is possible for a user who is not on the Business plan in Glide? If there is no way to query a Glide table in Make on my current plan, is there a workaround, for example like “Get Rows” and then search all of them in Make instead? 🙃 Thank you so much for your help 🙏 ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 18, 2024, 11:56am UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/2 "2024-06-18T11:56:02Z")
If you want to “Get All Rows” then I think you’ll need a business plan or higher. I could help you with that Make scenario Webhook → get all rows → set variable → rest of flow > **[Using Glide API | Glide Docs](https://www.glideapps.com/docs/using-glide-tables-api)** > > Explore what you can do with the Glide Advanced API ---
**Author:** ![schrutefarms](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/schrutefarms/32/59686_2.png) [@schrutefarms](https://community.glideapps.com/u/schrutefarms)\ **Post date:** [June 18, 2024, 12:20pm UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/3 "2024-06-18T12:20:02Z")
Hi, @Eric_Penn thank you for your reply. I’m currently exploring the features available to me with the new native Make integration and it seems like the “Get Rows” module available to me in Make is actually getting all my rows from a table of my choice? And in that case it would only be a matter of me understanding on how to get Make to search through the data and look for a duplicate? Again, I might be completely wrong about this😎 ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 18, 2024, 12:33pm UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/4 "2024-06-18T12:33:29Z")
~~After the Get All Rows in Make you’ll want to add a “Set Multiple Variables” module. You want something like this. `rows` is from your Get All Rows Call, `4zMbr` is the name of the column in Glide to search, `packageid` is the Glide row ID.~~ Scratch that
 it’s a little early in the morning for Make scenarios
 but i will get back to you with the answer ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 18, 2024, 12:50pm UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/5 "2024-06-18T12:50:00Z")
Ok one way to do it is set it up like a filter. You build the flow completely as if you already checked the email and it is a new user. Then come back and put filter in between working steps. ![Screenshot 2024-06-18 at 8.50.25 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/6/86232bf7153fe2b1147fb887cd9437a51509d538.png) ---
**Author:** ![schrutefarms](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/schrutefarms/32/59686_2.png) [@schrutefarms](https://community.glideapps.com/u/schrutefarms)\ **Post date:** [June 18, 2024, 1:43pm UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/6 "2024-06-18T13:43:12Z")
Sweet, this looks great. Thank you so much for taking time to explain this🙏 Will look into this🙂 I don’t fully understand what everything in the “Conditions” field in your example means, but will look in the Make documentation to learn more about it. Will probably be back here with some more questions soon! ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 18, 2024, 1:56pm UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/7 "2024-06-18T13:56:15Z")
You will find the get and map functions in the fly out panel. ![Screenshot 2024-06-18 at 9.52.34 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/aeababe6e60cca788334e8cfdeb4571048a418c7.png) `rows []` - that’s from your Glide get all rows call `Email` - by default the name of the Email column in your Glide Users table is ‘Email’
 the Email column name could change if you move it. If you have moved the column it my be an unfriendly name like F0123 The red email - is the one we want to search from the webhook 
and be sure to put Basic operators: Does not exist 😉 ---
**Author:** ![schrutefarms](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/schrutefarms/32/59686_2.png) [@schrutefarms](https://community.glideapps.com/u/schrutefarms)\ **Post date:** [June 18, 2024, 2:06pm UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/8 "2024-06-18T14:06:58Z")
Thanks! Can I ask, what is the reason for writing “Email” twice? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 18, 2024, 2:12pm UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/9 "2024-06-18T14:12:12Z")
It’s because we want to return a primitive array with emails having an email equal to the email from the webhook. I hope that makes sense
 If you ever have any questions how to use a function in Make you can hover over it for more info ![Screenshot 2024-06-18 at 10.09.46 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4a3a41d3ba344f743c67e6bdd3adf70195c41dd8.png) ---
**Author:** ![schrutefarms](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/schrutefarms/32/59686_2.png) [@schrutefarms](https://community.glideapps.com/u/schrutefarms)\ **Post date:** [June 18, 2024, 2:33pm UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/10 "2024-06-18T14:33:15Z")
Thanks so much for explaining, I will give this a try🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 19, 2024, 12:41am UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/11 "2024-06-19T00:41:08Z")
My man explained map and get better than I have ever could. Just for more information, this is basically a lookup, wrapped in Make functions. ---
**Author:** ![schrutefarms](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/schrutefarms/32/59686_2.png) [@schrutefarms](https://community.glideapps.com/u/schrutefarms)\ **Post date:** [June 25, 2024, 6:56am UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/12 "2024-06-25T06:56:03Z")
So sorry for the late reply here, just got time to test this. And it works great! đŸ„ł đŸ„ł đŸ„ł Thank you so much! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 2, 2024, 6:56am UTC](https://community.glideapps.com/t/make-integration-how-to-check-if-email-already-exists-before-adding-a-new-row-to-glide-table/74204/13 "2024-07-02T06:56:57Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.