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, Calendar, Chat

Add a Google Meet to Calendar Events with Google Apps Script

Tags:
| | 0 Comments |

My small team relies on automation to make things run. Part of our PD process is a Google Form workflow that kicks off calendar events, document creation, and email notifications. Since we’ve moved to online learning, we wanted to update that process to automatically add a Google Meet link for any PD that doesn’t have to be in person.

There are some official Google guides that show how to attach a Meet event to the Calendar, but nothing from the perspective of Apps Script specifically, so that’s what is shown here.

Source: Add a Google Meet to Calendar Events with Google Apps Script

Solutions, Calendar

Fake calling to leave one meeting for the next — Google Apps Script to the rescue

Tags:
| | 0 Comments |

All through the day, I want call reminders for specific events 10 mins before the meeting time, so I can leave my current meeting with out a hitch and go for the next one. So I used 3 tools for this: Google Calendar to fetch meeting times, Google Calendar to fetch meetings. Twilio to make calls. And finally Google Apps Script to put it altogether.

An interesting implementation by Urwa Shabir on managing meeting schedule using Twilio, Google Calendar and Apps Script.

Source: Fake calling to leave one meeting for the next — Google Apps Script to the rescue

Solutions, Calendar

How to Colorize Google Calendar Event Using Apps Script

Tags:
| | 0 Comments |

Google Calendar provides a facility to create multiple calendars in order to keep different kind of events tidy. It also let’s us colorize them, but in the addition to that, you can also colorize different events in a single calendar!

Automatically colorize your calendar events using the power of Google Calendar and Google Apps Script platform.

Source: How to Colorize Google Calendar Event Using Apps Script (1/2)

Solutions, Calendar

React on Google Calendar change with Apps Script and EventUpdated trigger

Tags:
| | 0 Comments |

It is really amazing how it is simple to make this script and have an app that run on each change perform in your Google Calendar.

A quick post to deal with a script that run when a new event or an event is updated in my Google Calendar. Hopefully in Apps Script we have an EventUpdated trigger.

Source: React on Google Calendar change with Apps Script and EventUpdated trigger

Solutions, Calendar, Forms

Plan an Educational Visit in under two minutes using Google Apps Script

Tags:
| | 0 Comments |

This video demonstrates how teachers can plan an educational visit in under two minutes using Google Witchcraft and Wizardry (also known as Google Apps Script!)

A creative approach on automating the process of filling a Google Form towards an education visit and creating a Calendar invite with all the relevant information.

Official News, Solutions, Calendar, Sheets

How to track time with Google Calendar and sync to Google Sheets – Sheets to Apps

Tags:
| | 3 Comments |

In this episode of Sheets to Apps, we will show you how to track your work time on projects via Google Calendar. More importantly, he’ll be showing you how you can sync Calendar events to Google Sheets, creating a spreadsheet that shows you the total time spent on your projects.

Short video highlighting Jasper Duizendstra’s G Suite Developer Solution Gallery contribution.  See the YouTube description for all the links you need.

Solutions, Calendar, Forms

Manage event registration with Apps Script, Google Calendar and Google Forms

Tags:
| | 0 Comments |

Manage training or event registration with Apps Script, Google Forms and Google Calendar.

Using Google Calendar to setup a meeting is really easy and works like a charm for business or personal needs. But sometimes you want to manage event registration for an event, a training and in this case you need to share a form and register the participant after the submission. Hopefully Google Apps Script is at the rescue.

Source: Manage event registration with Apps Script, Google Calendar and Google Forms

Solutions, Calendar

Trigger automated meeting invite reminders using Google Apps Script

Tags:
| | 0 Comments |

send a follow-up email to all undecided participants of a meeting that you’ve scheduled via google calendar using apps script.

here’s a piece of code that you could schedule for every morning (preferably before your official work hours start) to be triggered, such that the script could iterate through every single meeting event that you’ve scheduled (i.e. where you’re the “organiser”) for the day and send an email to all those invitees who’ve neither accepted nor declined (even excluding the maybe’d ones too) to said invites.

Nice post from Sourabh Choraria which covers interacting and using data from your Google Calendar.

Source: trigger automated meeting invite reminders using apps script

Solutions, Calendar

How to create an automated calendar with Google Apps Script with open source on top

Tags:
| | 0 Comments |

Speaking at conferences can be hard. This tutorial aims to help you better manage the “administrative” of submitting to calls for proposals (CFPs) and speaking at conferences.

Get this single small script that does everything Zapier does and more.

Source: How to create an automated calendar with Google Apps Script with open source on top