With Alerts & Notifications add-on you keep track on your Google Sheet™ data! Based on filter conditions create individual jobs and get automatic email notifications for sheet data or update alerts via 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™, Google Calendar™ events 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.
- Automat your sheet data validation and get informed regularly,
- Update customer or company specific values automatically.
- Sending of emails or create Google Tasks™ as reminders of deadlines.
- Send email notifications to users and you when user submit your form.
- Check new responses or datasets periodically up to an one hour interval and get notified.
- 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.
- Send results of a form submission via e-mail or chat to people you have listed and/or to an email address available in the form submission.
- Create time based cron jobs to automate tasks and reminders.
- Define which data to process based on individual filter and rule based conditions.
- Track changes in your check your Google sheet values and receiver automatic reminders about critical stocks and order triggers.
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.
- Create various sheet automation processes and stay informed about Google sheet changes.
- Handle Google Form™ responses automatically and forward email notifications.
- Automatic creation of Google Tasks™.
- Create Google Calendar™ events and shedule events automatically.
- 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.
- Manipulate Sheet data or sheet columns based on predefined conditions
   

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 150 Notifications per month. By choosing one of our business plans you can send unlimited notifications via email, Google Chat™, Microsoft Teams™ 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
- Google Calendar™ event creation
- Schedule Google Calendar™ events
- Form to Calendar
- Auto answers Google Forms™
- MS Teams Notifications
- Google Chat™ Card Messages