It is summer and in the summer people go to festivals and concerts. Let’s put together event software to create an information screen for concerts where you display the upcoming events on a television screen. Information of the events is stored in a Google Calendar this time. A Google Calendar is an electronic agenda that you can maintain via a web browser. So, when you are on the move, you can consult your calendar via smartphone.

This information will be read out by DataPoint and then displayed on your screen in real-time. Change the name of the event in your calendar (via your browser) and it gets updated in real-time on your connected screens. Perfect integration between a Microsoft PowerPoint slide show (the presentation tool for information screens) and Google Calendar.

event software using google calendar
Click to open the DataPoint menu and click the List button of the Connections group.
datapoint menu in powerpoint ribbon
Select the Google Calendar node in the provider list and click the Add Query button.
set up connection to google calendar
Click the Authenticate button in order to grant DataPoint to read your Google Calendar.
google calendar selection properties
Allow DataPoint to read out your events and calendar information, turning PowerPoint into easy to use event software.
grant read permission on your google calendar
First of all, you can select the calendar that you want to import. Potentially you have multiple calendars on your account. Select the correct one here, the one for displaying.

There are 2 date-related parameters to select your data. One goes back a number of days and the other one selects a number of days in the future that you can import in your slide show.

Choose a data refresh rate that suits your business needs.

Click OK to close and see a preview of data.

google calendar events preview in powerpoint
We start a new presentation and we use some shapes to display the first event. Just draw the different text boxes on your slide with static texts.

Select the first text to host the name of the event, or the name of the group or concert and click the Text box button of the DataPoint menu.

start with a new presentation
Assign the column named Title of row number 1 to this shape. Click OK to close. Whatever content of your first event of your Google Calendar, is now dynamically linked to this text box.
link text box dynamically to event name
Select the second text box and click the Text box button again. Choose Start as the column.
event date properties
In the preview, you will see that the start field of the Google Calendar entry is a data and time field together. We want to display the date part of this value only. Click the Format tab and select Date and time as category. In the Type options, choose a date only notation and click OK to assign it to the selected text box.
event date formatting
Select the 3rd text box and click the Text box button. We will choose the Start field or column again to show the hour that the concert commences.
event time selection
At the Format tab, choose now a time only option. Clock OK to close.
event time formatting
Select the shapes of the first event and duplicate them a few times to fill the slide. Select all fields of the second event.
repeat concert info
Click the DataPoint +1 shortcut to increment the row number. These text boxes will now show the information of the second event. Repeat these steps for the other concert blocks on this slide.
increment row number of event
google calendar events linked on slide
Almost done! Click the Set Up Slide Show button of the Slide show menu option.
open slide show settings
Set the Show Type to Browsed at a Kiosk (full screen) and click OK to close.
set slide show type to kiosk
Start the slide show and maintain the information in your Google Calendar by using your smartphone or a web browser. Now you have turned PowerPoint and Google Calendar into event software!
real-time powerpoint slideshow driven by google calendar events

Show your Google Calendar Events in Real-Time

Pin It on Pinterest

Share This