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 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 and run only selected apps the Marketplace is selected.
    Allow Install Setting from the  Admin Console
  3. In the left navigation pane, click Apps list.
  4. Click Allowlist App at the top right. The Add an app to the allowlist stepper opens.
  5. Search for Event-o-Matic.
  6. Click Select.
    Add an app to the allow list stepper showing step 1, select an app
  7. Select Allow users to install this app.
    Add an app to the allow list stepper showing step 2, select teh access setting
  8. Click Continue.
  9. Select Everyone or Specific groups or organizational units.
    Add an app to the allow list stepper showing step 3, select the users
  10. Click Finish.
  11. At the parental consent prompt, click Confirm.

Step 2: Add Event-O-Matic for Users Client Id’s to the Trusted List of API Access

See Client IDs: Add Labs tools to the trusted list of API access for the full list of scopes.

Step 3: Install the Sheets Extension From the Google Workspace Marketplace.

  1. In Google Sheets, open a sheet.
  2. Navigate to Extensions > 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.

Install page for Event o matic in Workspace-Marketplace.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 Extensions > Event-o-Matic. 

Creating an example

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

  1. Navigate to Extensions > Event-o-Matic > create an example. That this will create another tab in the spreadsheet.
  2. Click Create Example at the bottom of the Popup. When the process completes you will have created two calendar events.
    Interface showing the Create Example button

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

 

 

Comments

0 comments

Article is closed for comments.

Articles in this section