This little Arduino project is useful for those offices that have meeting rooms that people should book from Google Calendar. What happens in reality is that people often occupy rooms on the fly as booking would take too much time and an empty room in front of you is sooo inviting. This leads to overlaps and, well, vengeful negative feelings. 🧘🏻♂️
With this solution you can just install an Arduino Oplà next to the door and have it show whether the room is free or not based on live data coming from Google Calendar.
- Open Google Calendar and subscribe to the calendars of the room you want to display. This can be done clicking the "+" button on the left sidebar and selecting "Browse resources".
- Copy the resource ID of the room. It has the form of an e-mail address in the
...@resource.calendar.google.com
format. - Go to https://script.google.com/, create a new project and paste the code from MeetingRooms.js. Remember to configure the settings at the beginning of the script.
- Use the "Deploy" button in Google Apps Scripts and create a "Web app" deployment. Copy the deployment URL.
- Copy the contents of config.h-dist into a new file called config.h inside opla-meeting-room.
- Open the opla-meeting-room sketch with the Arduino IDE.
- Configure the various settings in config.h.
- Upload the sketch to your Arduino Oplà.
- Enjoy!
Bonus points: if you want to be able to update the firmware via WiFi, thus without connecting a USB cable, just use the Arduino Cloud. It can be set up in minutes and it's quite handy if you have multiple devices installed around.
When the room is busy the screen will be red, and information about the current meeting will be displayed (time slot and guests):
When the room is free but a meeting is scheduled, it will appear green and contain information about the upcoming meeting:
When no more meetings are scheduled for the current day, it will appear green with a generic message: