For a quick introduction to the Alerts & Notifications add-on, please follow the steps below to start processing data via the add-on:
Start the add-on
After installing the add-on from the Google Workspace Marketplace just open a Google Sheet and check for the menu item “Enhancements → Alerts & Notifications → Start and job overview”
Create a job
On the start page “Job Overview” you can see a list of all your created Jobs. Create a new job by clicking on the red button „Create“.
Assign any name to your new job in the „General Job Settings“. Also set a desired start time, standard is „On Demand“. Optionally you can activate a processing log. Then click on the blue “Next”-button ( „>“-symbol).
Select your data
On the next step “Data Source Settings” you can configure all settings about the processed data. First of all, select the relevant sheet with the data that should be processed. By default, row number one is pre-selected as the column header row. Row number two is defined as the start row of your data. You can adjust these default values if necessary. All processing results will be written into a column for status messages. By default, a new column “Protocol Alerts & Notifications” will be created by the add-on.
Define a filter [optional]
OPTIONAL – Via the filter settings you can define a condition based rule to filter your data records. Defining a filter is optional. You can skip this step by just moving forward via the “Next, no filter” link.
Select your preferred action
Last step to finalize your job is to configure the “Action Settings” dialog. Select one of the available actions. To use the „Send email“ action for example, you have to insert an E-Mail receiver, a subject and a description of the emails to be sent. In any action you can use placeholders to refer to the column headers of your selected sheet. For example so you can maintain the e-mail addresses of the email receivers for each row in a sheet column and refer to this column within the email action field. To do so you can use the column header as a placeholder any action field. A placeholder has to be surrounded by „%“-characters. Examples: %Name%, %Address%, %Email% etc. Please note that a placeholder, apart from the percentage sign at the beginning and at the end, must be identical to the column headers used in the Google Sheet. It is also case-sensitive.
Run your created job
By clicking on the „Save“-button your settings are saved and the job is finally created. The newly created job is now listed in your start page „Job overview“. You can start the job manually at any time using the “Execute” button (⏵- Symbol) and the job starts processing of the defined datasets directly and run your configured action for each dataset!
You can access the complete user manual with all the details about the Alerts & Notifications Add-on via the following link: Alerts & Notifications User Manual