With this google script you can write in any cell of your spreadsheet a "@Mention" and a message and a mail will be sent to the email assigned to that @Mention with the message in it.
Example: Write in any sheet cell: Code in Django all day with @Jesus and @Everardo
The message will filter de @Names and send a mail to the specified mail in other shhet.
Here is the google sheet link for testing purposes (you have to do the process below for it to work):
https://docs.google.com/spreadsheets/d/1IDcv9Qz-FZjhxP3jpmvdo0fTsVJMKRXOVGY8bu2DOk0/edit?usp=sharing
ACTUAL USE IN YOUR GOOGLE SHEET:
-
COPY THE CODE
-
IN YOUR ACTUAL SHEET SELECT TOOLS > SCRIPT EDITOR
-
PASTE THE CODE
-
CREATE A CONTACT SHEET WITH THE FOLLOWING PATTERN (Make sure its the first sheet):
1st column 2nd Column @Carlos carlosexample@gmail.com @Mario marioexample@hotmail.com and so on...
-
CHECK THE CONTACT SHEET URL: AND COPY THE PART BETWEEN
/spreadsheets/d/ AND /edit#gid
- PASTE THIS PART IN THE CODE ON SCRIPT EDITOR IN:
var sheet = SpreadsheetApp.openById("HERE!!!!!!!!!!!!!!");
-
UNCOMMENT THE FIRST SNIPPET OF CODE JUST THE FIRST TIME YOU ARE TRYING THIS CODE
-
PRESS THE PLAY BUTTON (An arror will be thrown (THATS NORMAL), thats because no cell was selected when running the code).
-
Authorize your gmail account... this mail will be used to send all the emails.
-
RE-COMMENT THE FIRST SNIPPED... THIS WILL PREVENT DUPLICATE EMAILS.
-
SAVE
-
MAKE A MENTION IN ANY CELL WITH THE FORMAT @MENTION (THIS CAN BE IN ANY SPREADSHEET YOU CREATE IN THIS DOCUMENT)... AND AN EMAIL WILL BE SENT TO THE EMAIL ASSIGNED TO THAT @MENTION IN THE CONTACT SHEET.