Check comma separated email address is valid

The following Google Apps Script is designed to loop through a Google Sheet cell of email addresses that have been separated by a comma and space. It then uses a regular expression (regex) to confirm the email address meets the correct formatting criteria.

This code was developed as a way of implementing additional checks when asking users to be precise in how exactly they enter multiple email addresses. So if they were to forget the space for instance it could alert them, before the rest of the code risked failing as whatever task it was designed to do.

Regular expression to check the format of an email address

Change Drive ownership without email notification

The following Google Apps Script is designed to change ownership of a Google Drive item without sending the default email notification to the new owner. Please note this will only work within your organisation (i.e. on the same domain) and not between personal Google account (where consent is required by Google).

Snippet of code for changing Drive ownership

The Gift of Script YouTube channel

There is now a new dedicated YouTube channel for the Gift of Script content.

All previous videos have been collated into Playlists.

Subscribe @TheGiftofScript.

Correct date formats in a Google Sheet

The following Google Apps Script is just one way you could search through data within a Google Sheet, pinpoint all date-values (no matter where they are), check their format (e.g. dd/mm/yyyy) and update it to a format of your choosing if necessary.

This function has been useful when American/British date formats have managed to make their way into a Google Sheet.

Screenshot showing difference between American/British date formats

Google Add-on: Send Recurring Emails

What it does

Easily send recurring emails at a frequency of your choosing e.g. every 7 days, every 27 days, every 1 month, etc.

Write your email(s) once, select your start date, frequency, recipient(s), then kick back and relax. The tool will automatically check every day at a time that you specify to see if any emails need sending.

Example uses:

• Newsletter submissions.
• Monthly reports.
• Team meetings.
• Attendance checks.

Demo video

Find out more

Send Recurring Emails Add-on webpage.

Google Add-on: Bulk Calendar Events

What it does

Bulk create Google Calendar™ events with optional video conferencing (Google Meet™). Add location, guests, change the event visibility, colour and much more.

Example uses:

• Meetings
• Workshops
• Events
• 1:1s

Demo video

Find out more

Bulk Calendar Events Add-on webpage.

onFormSubmit Trigger simultaneous executions

The following post is a caution around onFormSubmit triggers after I recently discovered a way that somebody had inadvertently managed to execute my code simultaneously over 253 times. Now unless a Google Form is submitted by 253 individuals all at the same time ... then this is baffling.

When should an onFormSubmit trigger run?

At the point when a Google Form has been completed and the 'Submit' button pressed.

Probation Tracker Tool

The following Google Apps Script tool was developed to allow you to easily be reminded of when upcoming probation review meetings are due. Enter the details into the Google Sheet, including upcoming review dates, and the tool will automatically email the Line Manager both 14 days before and on the day of the review date.

Manage probation review dates in a spreadsheet and be sent reminder emails