Question

Can I make my Gmail-Slack integration only send a message once when a specific email label is applied?

  • 4 June 2023
  • 5 replies
  • 36 views

What I want to do is when an email receives a certain label it will send a message in Slack. This works fine. The issue is that I only want it to happen once, but when people talk back n forth in the email thread it keeps sending Slack a message.

 

How do I get it to only message in Slack once?


5 replies

Userlevel 7
Badge +14

Hi @TravisDryden 

Good question.

You’ll likely have to log each email thread in a lookup table to reference each time the Zap is triggered to run.

If the Gmail Thread ID exists, then Filter the Zap.

 

 

Thank you Troy!

 

This is where I’m at trying to create a table, but how would I configure this?

 

Userlevel 7
Badge +14

@TravisDryden 

You can’t use a Lookup Table for this since your lookup table will be dynaimc, meaning new entries will always be added to it.

Try using Airtable or GSheets instead.

Concept is find/create row, followed by a filter step if found = true.

Ok makes sense, how do I get it to look up the google sheets?

 

Userlevel 7
Badge +14

@TravisDryden 

Add this GSheet Zap action. (might be called Lookup Row)

 

Reply