Use Google Spreadsheets for events

You can export captured events directly to a Google spreadsheet and edit them immediately.

With COREDINATE, you can export certain recorded events to a Google spreadsheet, which can then be edited or evaluated immediately by other people who have the authorization. This article explains how to set up the Google spreadsheets.

Please log in to the portal with the appropriate rights. Click on Reporting -> Notification rules in the main menu on the left.

 

 

Now click on the blue + Create notification rule button at the top right.

This takes you to the following view, where you must give the notification rule a name.

In the next step, please select Incident with event type reported.

 

Now click Continue at the bottom right to select the event types to be recorded in the next step.

Click on Apply to get an initial overview of the monitored event types. Then click Continue and select the Google spreadsheets field and click Continue again at the bottom right.

 

In the next step, click on the Request access button on the left.

You will be redirected to your Google accounts, where you can select which Google account should be used for the table(s).

 

 

After selecting your account, you must allow the security query from Google.

 

 

Click on Continue. It is possible that a code will be requested here to ensure security. If everything went well, the link to the Google account has been successfully completed and you can close the tab.

Back in the COREDINATE portal, in the next step enter a name for the Google spreadsheet in the Name field on the left, then click Create New below.

 

The table ID is displayed here and on the right-hand side you will see worksheet1.

 

Click on Save at the bottom right to complete the setup in the portal.

Now you need to log in to your Google account and click on Google Spreadsheets (the small, square icon with the 9 dots at the top right) and select Spreadsheets further down. The table created in the portal will appear in your list, which you can click on.

 

If you have clicked on the name of the table, the table is displayed in the browser and when an event is recorded, it appears immediately in the table.

 

Please note that you must first release the table if it is to be edited by other users. To download the table or send it by e-mail, simply click on File in the top left-hand corner and select what you want to do next from the menu.