Automation for Changes made by a particular user

Miles Allison

Hello,

Is there an automation option that allows a notification to be sent if a particular user makes any type of change? For example, User A can make changes to the sheet without triggering the notification, but if User B makes a change a notification is sent.

Thanks

Paul H

Add a Auto-Number/System Column for "Modified By"

put the users email instead of "automation@....."

Jeff Reisman

@Miles Allison

If you don't already have it, add the system column "Modified By" to your sheet and save the sheet. Set up your Alert automation, add your trigger for the automation to be "When rows are changed" or "When rows are added or changed," and in the Conditions, add a condition that "Modified By" is not one of <select your users that should not be notified.> (Alternatively, you can set it to only send the Alert if the Modified By IS one of the selected users.)

I tested this out by changing some rows as me, and then changing others while logged in with my personal "free user" account. I only got alerts for changes by my free user account.