Hello,
I have a sheet that I'm trying to create a fairly straightforward notification automation routine for, but it seems I'm doing something wrong.
The relevant columns on my sheet are "Email" and "Account Type," so 2 entries would look something like this:
Email: abc@abc Account Type: Monthly
Email: cba@abc Account Type: Quarterly
I have 2 automation routines running right now. The Monthly automation is set to run on the 27th of every month. I've told the automation "Conditions - When frequency is one of 'Monthly'" "Alert someone - Send to contacts in a cell 'Email'."
The Quarterly automation is similar, just set to run on the 27th every 3 months. I've told the automation "Conditions - When frequency is one of 'Quarterly'" "Alert someone - Send to contacts in a cell 'Email'.
However, the automation is functioning such that SS sends both notifications to all recipients who have an email address in the Email cell, regardless of their account type whenever either of them run. So both Monthly and Quarterly accounts are receiving both notifications from both automations. I thought the conditional statement would restrict the notification to only email addresses from the Email cell that satisfy the conditional statement, but it seems like that isn't the case.
How do I modify this automation so that SS only sends only the monthly notification to email addresses with a Monthly account and only the quarterly notification to email addresses with a Quarterly account?
Thanks for any help!
