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

Download your free data driven PowerPoint templates
Use DataPoint to link presentations to various data sources
Great Digital Signage software for playlists with images, videos and PowerPoint presentations
Download FREE PowerPoint Templates

Download FREE PowerPoint Templates

You will receive more than 10 PowerPoint templates that you can use to create your information screens and digital signage.

You will also be asked if you want to be added to our mailing list to receive the latest resources, "how-to" articles and updates from our team.

You are subscribed successfully! You will get the gift with free Microsoft PowerPoint templates in your final subscription confirmation mail.

10 Secrets to Exceptional Presentations

Instant Access: 10 Secrets to Exceptional Presentations

Join our mailing list to receive the latest presentation resources from our team.

You have Successfully Subscribed!

Pin It on Pinterest

Share This