Create a pop-up alert in Google Sheets

In this project we will learn how to create pop-up alerts in Google Sheets with the help of Google Apps Script, and I´ll show you the main options and tips of this tool
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below

[@abdullahquhtani4247]

Great as usual 😊.
I have a suggestion. It’ll be great if you could make a script that send a notification to Telegram, slack or browser notification 🤔
Thank you 🙏🏻

[@practicalsheets]

Thank you for the suggestion!
I believe integration with Telegram is not that easy, because of the bots
But I will prepare a video
Regards!

[@ChandrasekarLoganathan]

Thanks for the video, its very helpful. Can u also put the script in the video description or in your website

[@practicalsheets]

Thank you!
For now it is available only in my patreon page. 😔
Kind Regards

[@aradhyagoel2544]

Thank you, this was very helpful!

[@practicalsheets]

Thank you for the comment!

[@richardwhalen1859]

Great Video - Thanks very much!!

[@practicalsheets]

Thank you for commenting!

[@abdullahquhtani4247]

Thank you for your reply. I think it’s a brilliant idea if a notification can be sent to telegram or any other social application when a new row added to Google sheet.

[@mattturner7750]

Great video thank you! I’m struggling at the moment to apply this pop up message to an image in my Google sheet project. Do you know if this is possible?

[@practicalsheets]

Do you mean you want to click on an image to show the popup
Kind Regards

[@varunchaudhari09]

Hey, thanks a lot, this was very helpful. Can you let me know how to run the script automatically every time someone opens this sheet?

[@practicalsheets]

Hello!
You should include yor function in an onOpen() function
Kind Regards

[@ElizabethStocks]

How do I make one of buttons, from the pop up alert, jump the a specific tab or a specific cell? Thanks :)

[@practicalsheets]

You could select the cell with .getRange(), and then use the method .activate()
Kind Regards

[@AnyPossibleRandomThing]

Is there a way to change the font size of the alert? Also can I add new line?

[@practicalsheets]

Hello!
You could add a new line with this command

For the font size we would need to go a bit more advanced and do a html form
I'll leave it for a new tutorial
Kind Regards

[@SA-bd7hd]

You explain everything 13minutes long and I was trying so hard to imitate the same you did but you seriously tell that it doesn't work on smartphones at the END of that video????? 😡🤯😡🤯😡🤯😡 You should have done that at the beginning so no one wastes hours of time for nothing!!!n

[@practicalsheets]

Thank you for the comment. I'll apply it for future videos!
Kind Regards