How to send scheduled messages to Slack with the Google Calendar API

Wilco Schoneveld
Oct 14, 2019 · 3 min read

I work for the tech consultancy HeadFWD and we are a group of about 25 awesome and talented but slightly unorganised developers. We have a shared calendar but checking it often is not a priority for most of us, so we were looking for a way to send reminders of events and birthdays via Slack.

Demo

The result is an extension to our existing slack bot. We can schedule Slack messages by creating an event in the calendar. The event summary is used to target a specific channel, the event description is posted as the message. See it in in action here:

Demonstration of sending a slack message with a Google Calendar event

Method

We decided to use a polling solution to integrate both platforms. We already have a chat bot set up as a slack app so it was most convenient to add the feature there. Next, we created a dedicated calendar which we now use to schedule messages (events, recurrent reminders, birthdays, etc).

For each event, we use the description as a way to store the message and put the desired channel in the event summary. We can use mentions and slack formatting (including smileys) as expected, but can not use the formatting options provided by Google Calendar as that will transform the description to HTML, which is not supported by Slack.

Scheduling a message is as easy as creating a new Google Calendar event

Technical details

Our slack bot is created using NestJS and TypeScript. We choose nest-schedule to allow setting up of an interval job, in this case polling the calendar with the Google API to check for events to process. This is not required though, a simple Node script as a Cron job should do the job. We use the google-api-nodejs-client to retrieve and update calendar events, you can find the API docs here.

Connecting to the Google Calendar was not so trivial since OAuth is the only supported protocol and it requires an authenticated user (the bot is an app, not a google user). We have a G Suite and the magic trick is to set up a google service account with domain-wide delegation of authority to allow the service to impersonate a user.

Polling happens every 5 seconds and looks for events in the surrounding range so that messages are processed at the scheduled time. Recurrent calendar events are collapsed into single events by the API to make processing a whole lot easier.

In order to keep track of which events have been processed — to prevent duplicate postings — we needed a way to mark the events as handled. Since the calendar itself is a database, we decided to update the event summary with a symbol to mark it as either ‘sent’ (!) or indicate any issues with ‘problem’ (?).

In order to actually send the message to Slack we do a single http request on the postMessage endpoint with our app token. Alternatively, you can set up the node-slack-sdk in your application.

That’s about all there is to it! The full implementation of our calendar service is available here. Thanks for reading!

HeadFWD

High-end tech consultants working for top brands in NL

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store