Skip to main content
Question

How do I include Gmail filters to add a new row on sheets with only specific words?

  • February 24, 2023
  • 5 replies
  • 35 views

sadidrahimi

Hey all, 

 

I couldn’t find this anywhere on Youtube or here

 

When I don’t include any filters, my spreadsheet row is updated perfectly fine

 

But when I’m trying to filter out words that indicate interest from prospective emails, nothing shows up

 

E,g “setup a time” “demo” “interested” to name a few 

 

I even used Google’s reference of “ “ but to no avail 

 

Here’s what I have typed, and I’m using the simple Gmail to Sheets template

 

Thank you in advance!

 

 

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

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 24, 2023

Hi @sadidrahimi 

Good question.

Click the more link to see more info that should point you in the right direction.

 


sadidrahimi
  • Author
  • New
  • February 25, 2023

Hello Troy,

 

I did, hence “I even used Google’s reference of “ “ but to no avail” 

 

It didn’t help with adding rows, so now I’m here 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 25, 2023

@sadidrahimi 

Check out this help article: https://support.google.com/mail/answer/7190?hl=en

 


sadidrahimi
  • Author
  • New
  • February 25, 2023

Troy, I appreciate your trying to help, but I’ve repeated my answer to you twice, both in comments and in the original question, stating that I’ve already done that

 

I’ve been on that Google article, combed over the entire article, and still, nada

 

I wouldn’t be here otherwise 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 25, 2023

@sadidrahimi

If you can’t get the Gmail search operators to work, then you can try using a Filter as step 2 in your Zap: https://zapier.com/apps/filter/help

 

Did you try this?

"demo" OR "set up a time" OR "interested"

or

{"demo" "set up a time" "interested"}

 

 

This doesn’t have the OR between the terms.