AppsScriptPulse

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