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.
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.
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.
I use Google Apps Script to support staff and students in my job. I enjoy dabbling with creating tools to help with automation and I freely share my learning experiences on my blog: www.pbainbridge.co.uk
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”
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