All Collections
Connect your spreadsheets
Build widgets from spreadsheets
Display Google Calendar events on your dashboard via Google Sheets
Display Google Calendar events on your dashboard via Google Sheets

Learn how to use a Google Apps Script to get Google Calendar event data into Google Sheets.

Updated this week

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.

Table widget showing spreadsheet data fetched from Google Calendar
  1. Make a copy of this Google Sheet.

  2. Rename any column headings as needed. Make sure all column headings remain in row 1.

  3. Navigate to Extensions > Apps Script.

  4. In the pop-up code window, locate line 3 and replace the YOUR_CALENDAR_ID placeholder with the ID associated with your Google Calendar. Find your calendar ID by following these steps.

  5. Click the Save disk icon.

  6. Click on the Run icon to run the code block.

  7. Authorize the request to access your Google Calendar data.

    Authorize the request to access your Google Calendar data.
  8. Navigate back to your Spreadsheet, and it will now be populated with details of the next 10 events in your Google Calendar.

  9. Select the columns you want to include in your table widget. To include fewer than 10 events, reduce the number of selected rows.

    Select the table heading you want to include in your table widget
  10. Click the table icon to preview how your table widget will look. When you're happy with your selection, click Continue >.

  11. 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.

  12. Give your widget a name, like 'Upcoming events'.

  13. When you're ready, click Add to dashboard.

Did this answer your question?