Get email notifications, chat messages or create calendar events to monitor your Google Sheets™ data based on filters. Handle form submissions and copy, move, format your KPI and thresholds datasets.
Listing updated:February 22, 2024
Works with:
53K+
Overview
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.
   

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
Additional information
PricingFree of charge with paid features
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
View and manage forms that this application has been installed in
See, edit, create, and delete all your Google Sheets spreadsheets
View and edit events on all your calendars
See and download any calendar you can access using your Google Calendar
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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
tanmay priyadarshi
May 18, 2023
I've been using it for a while now, and I find it easy to use.
Is this review helpful?
Yes
No
Profile Picture
Jochen Hegele
January 5, 2023
Cool to track your sheet data. Especially the feature to edit cells or change color of cells if rows were being processed is great.
Is this review helpful?
Yes
No
Profile Picture
Ghulam Mujtaba KB
May 20, 2023
I'm new to this app, and I hope it will be useful
Is this review helpful?
Yes
No
Profile Picture
Muhammad Husnain Akmal
May 3, 2023
It help me a lot with my work. Highly recommend!
Is this review helpful?
Yes
No
Profile Picture
RT cartoon tv
May 15, 2023
I love this extension.
Is this review helpful?
Yes
No
Profile Picture
Jai Kumar
May 10, 2023
Pretty useful! Thank You Creator!
Is this review helpful?
Yes
No
Profile Picture
Muntazir Khan
May 2, 2023
I like❤ this very helpful
Is this review helpful?
Yes
No
Profile Picture
Anwar khan official
May 4, 2023
Seamlessly worked for me. Thank you!
Is this review helpful?
Yes
No
Profile Picture
R C. K
May 16, 2023
I love it already
Is this review helpful?
Yes
No
Profile Picture
Knowledge Pack
May 11, 2023
Great app!
Is this review helpful?
Yes
No
1-10 of 22
Search
Clear search
Close search
Google apps
Main menu