Google I/O
Pro PlusEvents Manager I/O - GoogleRequires an Events Manager Pro Plus license. Compare plans
The Events Manager I/O - Google plugin adds two formats to Events Manager I/O, each for both importing and exporting:
| Format | Import | Export |
|---|---|---|
| Google Calendar | Reads the events of any calendar in a connected Google account. | Creates your events in a calendar and updates them on later runs. |
| Google Sheets | Reads rows from a sheet, with the same field mapping as CSV and Excel. | Writes your events as rows in a sheet and updates those rows on later runs. |
It uses the accounts you connect, so it can reach private calendars and sheets, not only public ones.
A public Google Calendar has an iCal address (in the calendar's settings at Google, under its integration options). You can import that with I/O's built-in iCal format and a URL source, with no Google plugin, no credentials and no connected account.
Set up
-
Install and activate Events Manager I/O - Google. Events Manager I/O must be active with a valid license. The Google plugin has no license of its own.
-
Create an OAuth client in Google Cloud and upload its JSON file to I/O. See Set up Google OAuth credentials. Until this is done, the two Google formats can't be opened.
-
Connect one or more Google accounts at Events I/O then Settings then Service Connections. See Connect accounts.
-
Create an import or export and choose Google Calendar or Google Sheets as the format.
When you connect an account, Google asks you to approve access to both your calendars and your spreadsheets, to view and to edit, along with your name and email address. I/O asks for the same access whichever format you plan to use.