App Icon
Monitor your KPI and thresholds of your Google Sheet™ data. Based on filters copy, move or just highlight this data in your sheet and get automatically notified via email or chat.
Listing updated:September 14, 2022
Works with:
32,393
Overview
With Alerts & Notifications add-on you keep track on your Google Sheet™ data! Based on filter conditions create individual jobs and get automatic notifications or update alerts via Email, Google Chat™ , Slack or MS Teams. The add-on validates your sheet data regularly via time based jobs or handles Google Form based answers directly after their submit. Get flexible notifications by defining filter rules and insert dynamical content directly into your notifications. The add-on als supports creation of Google Tasks™ or data transfer via http service requests. Highlight your contents, change cell values, copy sheet data, move rows or delete rows of your sheet data automatically. 

Supported Languages: 
- German
- English

Help and Support:  
We are providing a short quick start guide and a detailed user manual. You can also contact our support team directly if you have any questions.
problems. For more information please check out our support center:
https://apps-experts.de/google-workspace-add-ons/overview-add-on-help-and-support/

Use Cases:
- Track your KPI (key performance indicators) based on sheet data and get notified automatically via E-mail or Chat
- Get alerts when threshold values are exceeded
- Get automatically alerted by e-mail or get alerts by chat based on individual conditions  
-  Automatic cell highlighting and bulk formatting based on filter conditions.
- Update customer or company specific values automatically.
- Sending of emails or create Google Tasks™ as reminders of deadlines.
- Auto creation of Google Tasks™ based on individual defined filter conditions.
- Copying, Shifting and Deleting of already completed order- and customer requests. 
- Remove duplicates or copy rows to another sheet
- Automatic cell color based highlighting and content maintaining to reduce manual efforts for monthly reports. 
- Forwarding of Google Forms™ based support requests directly after submitting.
- Forwarding of sheet datasets via http service requests to 3rd party systems like workflow or reporting tools.

Key Features:
- Get auto notifications and update alerts via E-mail, Google Chat™, Slack or MS Teams for every processed row or only once after processing.
- Create time based cron jobs to automate tasks and reminders.
- Define which data to process based on individual filter and rule based conditions.
Handle submitted datasets based on Google Forms™ automatically.
- Copy data, move sheet data or delete row based contents of your sheet.
- Use bulk processing to change cell values or highlight specific rows or cell values automatically.
- Automatic creation of Google Tasks™.
- Sent Notifications via Google Chat™, Slack and Microsoft Teams.
- Transfer of relevant datasets to 3rd Party Systems via HTTP REST rest based interface.
- Query your sheet data with our Query Builder and define action for selected records.
   

Quick Start:
1. If you have installed Alerts & Notifications add-on correctly just open a spreadsheet and check for menu item “Extensions → Alerts & Notifications”
2. On start page “Job Overview” you can see all your created jobs. Create a new Job via click on the button "Create".
3. Then insert a job name and define if the new job should run on demand or periodically. Also select your data source and define which sheet records will be processed. 
4. Via filter settings you can define a condition based rule to filter your data records if necessary. 
5. Finally select your preferred action and configure the action appropriately. By default Action “Change sheet data” is selected with option “test run”. Keep it to run a test run or change it directly to your preferred action and create automatic notifications via E-mail, Chat or create Google Tasks™.
6. Your created job is now listed on start page "Job Overview". Here you can change or run your created job at any time.

Further information is available here: 
https://apps-experts.de/google-workspace-add-ons/google-sheets-alerts-and-notifications-add-on/

Alerts & Notifications is a new add-on available in the Google Workspace Marketplace and an alternative to add-ons like Magic Cell Notifications, Bulk Sheet Manager or Sheet Go.

Some add-on features are only available in our premium version of Alerts & Notification add-on. By using Free-Version of the add-on you sent up to 500 Notifications and updates each month. By choosing one of our business plans you can use notifications via Microsoft Teams, Google Chat™ and Slack. Also you can post processed data to REST based services. 

-----------------------------------------------------------------------------------
Keywords:

- Notifications via Chat
- Chat Notifications
- E-mail Notifications
- Slack Notifications
- Microsoft Teams Notifications
- E-mail Notification
- Slack Notification
- Microsoft Teams Notification
- E-mail Alerts
- Slack Alerts
- Microsoft Teams Alerts
- E-mail Alert
- Slack Alert
- Microsoft Teams Alert
- Google Forms™ Notifications
- Google Forms™ Notification
- Google Forms™ Alerts
- Google Forms™ Alert
- MS Teams Notifications
- Google Chat™ Card Messages



Additional information
PricingFree of charge with paid features
Developer
Trader status unspecified
Privacy policy
Terms of service
Alerts & Notifications - Sheets data monitoring will ask for the permissions shown below. Learn more
Alerts & Notifications - Sheets data monitoring will need access to your Google account
This will allow Alerts & Notifications - Sheets data monitoring to :
See, edit, create, and delete only the specific Google Drive files you use with this app
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
Create, edit, organize, and delete all your tasks
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu