AppsScriptPulse

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

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.

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

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.

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

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

trigger automated meeting invite reminders using apps script

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

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

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

Search Google Calendar date range for specific events

Search through a given date range on Google Calendar, look through the events and then extract their Title & Id.

Source: The Gift of Script: Search Google Calendar date range for specific events

Creating Calendar events using Google Sheets data with AppScript

Today I’m going to show you how to automatically add Meetings/Events data from Google Sheets into a Google Calendar. This trick came really handy for me so I hope this will serve you the same.

How to automatically add Meetings/Events data from Google Sheets into a Google Calendar.

Source: Creating Calendar events using Google Sheets data with AppScript

Gym Attendance App built with Google App Script and React

Edward Meehan created a Gym Attendance web app using Google App Script and React that logs members attendance to be used for members and class metrics.

Source: Gym Attendance App built with Google App Script and React

Google Apps Script: How force subscribe Google Group Members to a Google Calendar for G Suite – Yagisanatode

Use Google Apps Script to get all the emails addresses of the members in a G Suite group, compare that against all the current members in the Calendar and add anyone who is missing

Google Apps Script, G Suite Admins, Google Calendar, Calendar API,  AdminDirectory, GroupsApp  Note! This article is for G Suite users and admins. You won’t be able to apply the same code to Consumer accounts.  Google Groups in  G Suite can be a really convenient and clean way to share users to drive folders and file locations, … Continue reading “Google Apps Script: How force subscribe Google Group Members to a Google Calendar for G Suite”

 

Source: Google Apps Script: How force subscribe Google Group Members to a Google Calendar for G Suite – Yagisanatode

Record time and activities with Google Sheets, Calendar and Apps Script

Jasper Duizendstra demonstrates how with a little bit of Google Apps Script you can easily use your Google Calendar to keep a record of how much time you spend on tasks and then query/report this via Google Sheets. The post contains instructions and code for getting started

Source: Record time and activities with Google Sheets, Calendar and Apps Script

Subscribe to Apps Script Pulse...