Gists
This is a sample script for retrieving the event ID from the event URL of Google Calendar using Google Apps Script.
The event URL is like https://www.google.com/calendar/event?###. At the event URL, ### of https://www.google.com/calendar/event?### is not the event ID. So it is required to convert it.
Sample script var eventUrl = "https://www.google.com/calendar/event?###"; var eventId = Utilities.newBlob(Utilities.base64Decode(eventUrl.split("=")[1])) .getDataAsString() .split(" ")[0]; Logger.log(eventId);
Gists
Overview This is a simple method running Google Apps Script by the event notification from Google Calendar.
Description There are several event triggers in Google Apps Script. Ref1, Ref2 There is an event trigger for Google Calendar. The official document says An installable calendar event trigger runs when a user's calendar events are updated—created, edited, or deleted.. Ref3 If I want to use the trigger when the event in the calendar is starts and finished, it is required to use Calendar API by preparing the URL for receiving from Google.
I knew that the specification of github.com/urfave/cli had been changed by the update of https://github.com/urfave/cli. By this, when the CLI created by golang is installed with go get, an error occurred. So this error was removed.
The updated CLI tools are as follows.
goodls ggsrun ggsrun gistwatcher goris gorearrange gislack gogauth
Gists
Overview This is a sample script for the music streaming player for Discord with Google Drive using Node.js.
Description This sample script can achieve to play the music when uses the voice channel on Discord. The music files are put in the specific folder of Google Drive. This script downloads all music files and plays the music files at the voice channel with the stream.
Usage 1. Register BOT to Discord At first, please register your BOT to Discord.
Gists
This is a sample script for dynamically updating the custom menu of Google Spreadsheet using Google Apps Script.
Demo In this demonstration, when the Spreadsheet is opened, 5 functions added to the custom menu. You can see that when a column is added and deleted, the custom menu is updated.
Issue and workaround for this goal Unfortunately, in the current stage, when a function is added to the custom menu with addItem method, the argument cannot been able to be used.