AppsScriptPulse

Solutions, Calendar, Meet, Sheets, Beginner

Using Google Apps Script to schedule Google Meets for a Virtual Parents’ Evening Assistant

Tags:
| | 0 Comments |

If your school is considering conducting an online ‘Virtual Parents’ Evening’ due to covid restrictions, this project might save your staff time. The Google Sheet (make a copy at https://bit.ly/vpeassistant ) uses Google Apps Scripts to automatically create a Calendar event (in your default Calendar), create a Meet link as part of the event, paste the Meet link back into the Sheet and create a draft email to the parent containing the Meet link and time/date.

A simple and effective solution from Luke Craig to help you manage virtual parents evenings … and more. In particular useful to see how you can add Google Meet video calls to you calendar invites. The video description also includes a link to the source code on Github.

Solutions, Drive, V8, Beginner

Google Drive Monitor – Get Email Alerts When Files are Deleted in your Drive with Google Apps Script – Digital Inspiration

Tags:
| | 0 Comments |

Monitor your Google Drive automatically and get email alerts when important files and folders are deleted from your Google Drive. You can also watch file activity in Shared Drives

Source: Google Drive Monitor – Get Email Alerts When Files are Deleted in your Drive – Digital Inspiration

Snippet, Beginner, Sheets

The Gift of Script: Search spreadsheet for multiple criteria

Tags:
| | 0 Comments |

Search through rows of a Google Sheet simultaneously looking for certain criteria all in one single loop. I needed a way of doing this without multiple loops despite searching for separate information and here is a way of achieving that via true/false flags.

Rows of email address and role in spreadsheet

Screenshot of spreadsheet data to search

Source: The Gift of Script: Search spreadsheet for multiple criteria

Solutions, Docs, Forms, Sheets, V8, Beginner

Create PDF from a Google Form submission using Google Apps Script

Tags:
| | 0 Comments |

In this blog post , we will cover how to create a PDF from the responses of Google Form using Google Apps Script.

If you are looking for some guidance on creating and sending PDF Documents from Google Form responses this post has all you need to get started.

Source: Create PDF Using GoogleApps Script