Install Event-o-Matic

Step 1: Confirm that Event-o-Matic is an allowed app on your domain and that your user accounts are authorized to install it.

As a Google Workspace super admin, under Apps > Google Workspace Marketplace apps > Settings > Manage access to apps, confirm that users in your domain are allowed to install allowed apps from the Google Workspace Marketplace.

  1. Navigate to Manage access to apps, Apps > Google Workspace Marketplace apps > Settings.
  2. Verify that Allow users to install only allowed applications from Google Workspace Marketplace is selected.
    AllowInstallMarketplaceHL.png
  3. Click Manage allowed list.
  4. Click Add app to allow list.
  5. Search for Event-o-Matic.
  6. Click Add to allowlist.
    AllowListHL.png

Step 2: Install the Sheets add-on from the Google Workspace Marketplace.

  1. In Google Sheets, open a sheet.
  2. Navigate to Add-ons > Get add-ons
  3. Search for Event-o-Matic.
  4. Click on the Event-o-Matic tile.
  5. Select Individual Install.

Note: Domain administrators will see the Domain Install and Individual Install buttons. It is important that you do NOT install the Add-on domain-wide as it will appear for ALL users. 

Or, cut to the chase and install it directly from here.

Individual_InstallHL.png

Opening Event-o-Matic

Once installed, you can open Event-o-Matic for Users from any Google Spreadsheet.

  1. In Google Sheets, open a sheet.
  2. Navigate to Add-ons > Event-o-Matic

Creating an example

Just starting with Event-o-Matic? You can have it create an example for you. 

  1. Hover over the Add-on menu.
  2. Click Create an Example. That this will create another tab in the spreadsheet. 
  3. Click Create Example at the bottom of the Popup. When the process completes you will have created two calendar events.

The calendar events are accessible by clicking on the Event Link provided in the spreadsheet, or by going directly to the user’s calendar.