# Gmail to upsert module

**URL:** https://community.make.com/t/gmail-to-upsert-module/40844
**Category:** Questions
**Tags:** gmail, airtable
**Created:** [June 7, 2024, 10:08pm UTC](https://community.make.com/t/gmail-to-upsert-module/40844 "2024-06-07T22:08:33Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Felipe\_Saucedo](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/felipe_saucedo/32/36821_2.png) [@Felipe\_Saucedo](https://community.make.com/u/Felipe_Saucedo)
#### Post date: [June 7, 2024, 10:08pm UTC](https://community.make.com/t/gmail-to-upsert-module/40844/1 "2024-06-07T22:08:33Z")

</div>

Hi, I am creating a scenario for a little CRM I am building in Airtable.

Currently I have a base to track interactions with contacts. The record names are the email adressess

 ![Screenshot 2024-06-07 at 19.02.10](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/d/3d76967d099ffb10a2294ff63b1300cbb0e5e4ad.png)

I want to update the record when a new email is sent to an address that already exists.

I created a scenario with the following modules.

Watch Gmail. → to pull all emails sent  
Search Airtable → to look for the records that have the same email as the receiver in GMail.  
Upsert Airtable → To either create a record with that email or create a new record if that is missing.

 ![Screenshot 2024-06-07 at 18.52.56](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/1/816160478c2de4abf888439846dca1ec563d898d.png)

 ![Screenshot 2024-06-07 at 18.53.14](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/2/d28f9d5b7fad35663c323e5803bcda92ab9bdae9.jpeg)

The proble is that the output of the search module comes empty. But I cannot seem to find the problem in the formula.

---

<div class="post-metadata">

### Author: ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)
#### Post date: [June 8, 2024, 10:42am UTC](https://community.make.com/t/gmail-to-upsert-module/40844/2 "2024-06-08T10:42:49Z")

</div>

Hi @Felipe_Saucedo  
You can apply the formula as follows:  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/b/ebe28d864a0e742d226584376be84681afc4c967.png)  
Output:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/e/fea13f4e04f092c67798d41f2818a5f39b9ceaea.png)

If you require additional assistance, please don’t hesitate to reach out to us.  
[MSquare Support](https://calendly.com/msquarepro/meeting) | [Book Live Implementation](https://calendly.com/msquarepro/msquareautomation-live)  
Visit us [here](https://www.msquare.pro/)  
[Youtube Channel](https://www.youtube.com/channel/UCqidlIIwbejxZmRUWBICcjQ)

---

<div class="post-metadata">

### Author: ![Felipe\_Saucedo](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/felipe_saucedo/32/36821_2.png) [@Felipe\_Saucedo](https://community.make.com/u/Felipe_Saucedo)
#### Post date: [June 13, 2024, 5:46pm UTC](https://community.make.com/t/gmail-to-upsert-module/40844/3 "2024-06-13T17:46:34Z")

</div>

Hey, thanks it worked. I don’t know what happened I had the " first and them removed the,

---

<div class="post-metadata">

### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [June 27, 2024, 5:49pm UTC](https://community.make.com/t/gmail-to-upsert-module/40844/4 "2024-06-27T17:49:06Z")

</div>