Use the Google Apps Script platform to automatically fetch the next 10 events from a Google Calendar in Google Sheets and then display them in a table widget.
Make a copy of this Google Sheet.
Rename any column headings as needed. Make sure all column headings remain in row 1.
Navigate to Extensions > Apps Script.
In the pop-up code window, locate line 3 and replace the
YOUR_CALENDAR_IDplaceholder with the ID associated with your Google Calendar. Find your calendar ID by following these steps.Click the Save disk icon.
Click on the Run icon to run the code block.
Authorize the request to access your Google Calendar data.
Navigate back to your Spreadsheet, and it will now be populated with details of the next 10 events in your Google Calendar.
Switch to Geckoboard and connect the sheet using our Google Sheets data source.
Select the columns you want to include in your table widget. To include fewer than 10 events, reduce the number of selected rows.
Click the table icon to preview how your table widget will look. When you're happy with your selection, click Continue >.
Now, you'll next see the widget configuration screen. Click-drag each column name to change the order in which they appear on your widget.
Give your widget a name, like 'Upcoming events'.
When you're ready, click Add to dashboard.