Automation - How to Send One Email Notification for Each Changed Row

I am using automation for one of our request approval processes, and need to be able to notify our help desk support team anytime the Completion Date column is updated with a date.

I know how to do this, however, I can't figure out how to prevent the notification email from grouping multiple requests into the same email. No matter what, I need the notifications to be sent to the help desk one email at a time.

Is there a way I can do this?

Find more posts tagged with

Support

Email Notifications

Comments

Paul Newcome

Set it to send "Right away".

Andrée Starå

Hi Leah,

To add to Pauls excellent advice. If you add a Placeholder in the subject or message when you have it to send right away, you'll make sure that it will send one at a time.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

That is a good point. If multiple updates are made and then the sheet is saved, it will send the notification right away, but it may still lump them together since they were all part of the same save. Placeholders is a good way to insure individual emails and allows for a little bit of customization.

Andrée Starå

Exactly!

Kate Hasse

@Andrée Starå Thank for your suggestion on this thread, but that does not work for me. I will leave pictures below to demonstrate. This happens on multiple workflows of mine. I have custom placeholders set up in the subject line and the body of the email, but if multiple rows get triggered at the same time, the email notification just removes those custom placeholders pretty much. Is there something I'm doing wrong? This is a headache for multiple workflows I have set up. In another workflow, my team member has to trigger update requests 1 at a time and then wait so they don't get grouped together and remove the whole custom email introduction.

Andrée Starå

Hi @Kate Hasse

Happy to help!

I think with the recent change to Alerts you'll have to use the option that includes the rows.

Did that change anything?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

taylor.integrated

@Andrée Starå @Andrée Starå, I'm running this same issue that @Kate Hasse is having. Do you mind clarifying more on the recent change to Alerts and using the rows option?

KevinL

@taylor.integrated @Andrée Starå @Kate Hasse

I am also experiencing this issue. Despite me having a {{cell}} placeholder in the text and the subject, it still groups the alerts. Even if I save after every trigger (ex: check box, save, next row check box save, etc.) it still groups the alerts. Support has mentioned this is expected behavior but any more insight to the recent change mentioned by @Andrée Starå in Oct or any other workaround?

KevinL

Quick Update: The only solution workaround I found was changing the alert action to request update request. Although we won't use the Open Update Form functionality, we are still able to send an alert per row that includes applicable {{cell}} info with our instructions linking to consolidated report in the message. I guess that's better than nothing.

David Milbrandt

@Constantine Chou

I just tested this. Only triggered the email notifications for 3 rows. It removed the placeholder and substituted the number of entries. I'd be happy to work within the rules if I knew what they were. Thanks.

Tony Exline

"placeholders will generate separate notifications if six or fewer rows are triggered simultaneously"

So with 50+ notifications going out each month I will have to send those out 6 or less at a time in order for this not to jumble them all together, or else I end up with this:

Assignment Notification - (4 entries) - (4 entries) - Dates: (4 entries) to (4 entries)

Unbelievable.

Victor Tey

This issue really needs to be fixed. It basically makes the alert feature unusable for process workflows if you have a high volume of requests being submitted.

Steven Gearhart

Agree, so frustrating, I have about 10 requests a week to turn on for 20 different people to create their worklist for the week. I will try doing them 6 at a time to see if that makes a difference, we will see.

Cathy Fraser

Hi All,

Can I please ask what do you mean by a "place holder" in the subject line? I run into this problem a lot and it courses issues as I have alerts being copied into a CRM (the CRM # field is included in the notification) if there are multiple notifications in one email this does not work.

Keen to see how best I can trigger the emails one at a time. And I agree, it needs to be fixed or at least an option to either select group notification or send out singular

Thanks in advance

Cathy

Jbody33

I am having the same issue. This is a worthless feature if I cannot send singular notifications from one form submission, or row entry.

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…