Skip to main content

I have 3 sections to my automation:

Gmail (new email search)

Filter (Custom business name)

google sheet (auto fills in email URL)

 

My question is how do I get the Filter (business name) to be in the google sheet along with the email URL?

Hi @kylemogli 

Good question.

Please post detailed screenshots with how your Zap steps are configured to give us full context, thanks.


thanks for the reply. here is the overview of the 3 steps

 


in the first step/action all new email that come in  

with the words chatgpt text in


in the 2nd action/filter I only want the companies called AI news and Nomad life to only be used


@kylemogli 

If you wanted to know which passed the filter then you have 2 options:

 

OPTION 1

2 Zaps

1 Zap for each Company, set in the Filter step.

Then you can hardcode the desired company value in to the GSheet step for the desired column

 

OPTION 2

Paths

1 Path per Company

Each Path has a Filter step

NOTE: Paths require the Zapier Professional plan or higher

Then you can hardcode the desired company value in to the GSheet step for the desired column


This is the final steps that automatically fills in my google sheet. Am I going about my steps the best way?


@kylemogli 

You will have to set a static value here since the desired right side filter parameter value is not an available data point using one of the Zap design approaches previously shared.

 

OPTION 1

2 Zaps

1 Zap for each Company, set in the Filter step.

Then you can hardcode the desired company as a static value in to the GSheet step for the desired column

 

OPTION 2

Paths

1 Path per Company

Each Path has a Filter step

NOTE: Paths require the Zapier Professional plan or higher

Then you can hardcode the desired company as a static value in to the GSheet step for the desired column


Thanks for the advice @Troy Tessalone 


Hi @kylemogli 

You’re welcome! Great to hear that Troy was able to help you!