Best answer

Ways for a reply to a specific email to update a specific Notion DB item

  • 15 December 2022
  • 4 replies
  • 68 views

Userlevel 1

Hi guys,

I have a Zap I am not sure how to create. We have a DB in Notion of certain items which correspond to emails sent in Gmail. So email sent in gmail with a specific subject creates a entry in that database with the body of the email that was sent + the email address of the recepient + First and last name.

What I want to do is to automatically update a specific entry based on a reply to a specific email.


E.g.

 

Email 1 sent to person A with email abc@test.com with body X

 

Notion DB item Y is created with these criteria based on the emails subject as it is predictable.

 

One week later I follow up with email 1a because of no reply. I need zapier to know to update Notion DB Item Y with additional email 2 that was sent.
 

This should happen for each email that gets sent out from gmail with a specific subject.

 

So for example email 2 to person B with body Z would create notion DB item W. following up with 2a email would update the body of notionDB body W and so on.

 

Is this feasible?

icon

Best answer by GetUWired 15 December 2022, 15:09

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +12

Hi @Draganmin 

Gmail has as trigger for New Email matching search. 
https://zapier.com/apps/gmail/integrations 

You will then most likely need some logic to isolate the correct email address.. whether it’s in the from field of the to field. Then search for the item in notion by the email address, and update it if found. Your flow would be something like this

Trigger: New Email matching search in Gmail

Action(s): logic to isolate the email address stored in Notion.. you could use code for this or perhaps a couple of formatters. 

Action: Find Database Item in Notion

Action: Update Database item in Notion

Userlevel 1

Thank you for this! Is this a scalable solution?

I.e. I do not need to specify a single email but I can say take the email address field from the email received and cross reference in NotionDB, if you find an entry that has this address in the email field, update it with relevant information

Userlevel 7
Badge +12

Zapier will only return the first matching instance in Notion. 

Userlevel 1

got it. So from my understanding I can do what I described, but it will be done only for the first match it finds? If so, that’s good enough, thanks a lot!