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?
Best answer
How do I populate a Google Sheet with email URLs and business names when a specific email is received in Gmail?
Best answer by Troy TessaloneBest answer by Troy Tessalone
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
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31355 replies
Hi
Good question.
Please post detailed screenshots with how your Zap steps are configured to give us full context, thanks.
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
1 person likes this
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
+14- Zapier Expert
- 31355 replies
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
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
1 person likes this
This is the final steps that automatically fills in my google sheet. Am I going about my steps the best way?
+14- Zapier Expert
- 31355 replies
- Answer
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
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
1 person likes this
Thanks for the advice
+6- Zapier Staff
- 404 replies
Hi
You’re welcome! Great to hear that Troy was able to help you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.