{"id":4648,"date":"2026-04-02T15:51:52","date_gmt":"2026-04-02T13:51:52","guid":{"rendered":"http:\/\/neu.apps-experts.de\/sheets-alerts-notifications-quick-start-guide\/"},"modified":"2026-04-14T11:02:06","modified_gmt":"2026-04-14T09:02:06","slug":"sheets-alerts-notifications-quick-start-guide","status":"publish","type":"page","link":"https:\/\/apps-experts.de\/en\/sheets-alerts-notifications-quick-start-guide\/","title":{"rendered":"Sheets Alerts & Notifications \u2013 Quick Start Guide"},"content":{"rendered":"

Quick Start Guide<\/h1>\n<\/div><\/div>
<\/div>
\"Google-Sheet-Alerts-and-Notifications-NEU-gruen-2022\"<\/div><\/div><\/div><\/div><\/div>

Sheets Alerts & Notifications<\/strong> \u2013 Quick Start Guide<\/h2>\n

For a quick introduction to the Alerts & Notifications add-on, please follow the steps below to start processing data via the add-on:<\/strong><\/p>\n

Start the Add-on<\/h3>\n

After installing the add-on from the Google Workspace Marketplace<\/a>\u00a0 just open a Google Sheet and check for the menu item \u201cExtensions \u2192 Alerts & Notifications \u2192 Start and job overview\u201d<\/strong><\/p>\n

1. Create a Job<\/h3>\n

On the start page \u201cJob Overview\u201d you can see a list of all your created Jobs. Create a new job by clicking on the red button \u201eCreate\u201c<\/strong>.<\/p>\n

\"\"<\/p>\n

Assign any name to your new job in the \u201eGeneral Job Settings\u201c<\/strong>. Also set a desired start time, standard is \u201eOn Demand\u201c. Optionally you can activate a processing log. Then click on the blue \u201cNext\u201d-button ( \u201e>\u201c-symbol)<\/strong>.<\/p>\n

2. Select Your Data<\/h3>\n

On the next step \u201cData Source Settings\u201d you can configure all settings about the processed data. First of all, select the relevant sheet with the data that should be processed.<\/strong> 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 \u201cProtocol Alerts & Notifications\u201d<\/strong> will be created by the add-on.<\/p>\n

\"\"<\/h2>\n<\/p>\n

3. Define a Filter [Optional]<\/h3>\n

OPTIONAL<\/strong> \u2013 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 \u201cNext, no filter\u201d<\/strong> link.<\/p>\n

\"\"<\/h2>\n<\/p>\n

4. Select Your Preferred Action<\/h3>\n

Last step to finalize your job is to configure the \u201cAction Settings\u201d<\/strong> dialog. Select one of the available actions. To use the \u201eSend email\u201c 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<\/strong> 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 \u201e%\u201c-characters. Examples: %Name%, %Address%, %Email%<\/strong> 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.<\/p>\n

\"\"<\/h3>\n<\/p>\n

5. Run Your Created Job<\/h3>\n

By clicking on the \u201eSave\u201c-button<\/strong> your settings are saved and the job is finally created. The newly created job is now listed in your start page \u201eJob overview\u201c. You can start the job manually at any time using the \u201cExecute\u201d button (\u23f5- Symbol)<\/strong> and the job starts processing of the defined datasets directly and run your configured action for each dataset!<\/p>\n

\"\"<\/p>\n

You can access the complete user manual with all the details about the Alerts & Notifications Add-on via the following link: User Manual Sheets Alerts & Notifications<\/a><\/em><\/p>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>

Do you have any questions<\/strong>? Feel free to contact<\/a><\/strong> us!<\/h3>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>\n\n","protected":false},"excerpt":{"rendered":"Quick Start Guide Sheets Alerts & Notifications \u2013 Quick Start Guide 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\u00a0 just open a Google Sheet and check for the menu...","protected":false},"author":5,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-4648","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/apps-experts.de\/en\/wp-json\/wp\/v2\/pages\/4648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/apps-experts.de\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/apps-experts.de\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/apps-experts.de\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/apps-experts.de\/en\/wp-json\/wp\/v2\/comments?post=4648"}],"version-history":[{"count":0,"href":"https:\/\/apps-experts.de\/en\/wp-json\/wp\/v2\/pages\/4648\/revisions"}],"wp:attachment":[{"href":"https:\/\/apps-experts.de\/en\/wp-json\/wp\/v2\/media?parent=4648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}