Code in Google Sheets
Do you know that Google Sheets offers scripting?
The easiest way to fire function is to create custom menu. You just need to type in script editor following code:
This function will be fired after document’s open. It creates custom menu option with one item which will fire ‘alertFunction’. Let’s define this function.
Cooperating with UI is not the only thing we can do by scripts.
Google offers us much more functionalities like operating with sheet data:
Emails will be send from our gmail account.
For more information visit Official documentation.
Hope you enjoy this post. If You have any questions or problems leave a comment or send email.
See You soon!