Eventfinity Dashboard Helpsite Dashboard Help Site

Contact Us

Using the Eventfinity Google Sheets Plugin

Created March 13, 2024

Overview

Our Google Sheets plugin is an internal tool that allows Gramercy Tech employees the ability to download specific event and attendee data into Google Sheets rather than individual manual exports from the dashboard. This plugin is still in development so only select aspects of Eventfinity can be imported at the moment.

This article will cover

Requirements

Back to Top

How to Install the Plugin in Google Sheets

1. Make sure you are logged in to your Gramercy Google drive account and create a new Google Sheet. The Google users avatars should match in Chrome and Sheets.

2. Click on Extensions >  Add-ons > Get add-ons

3. This will open a modal. Click the hamburger menu button on the top left in the modal.

4. Scroll down and click on Internal Apps

5. You should see the Eventfinity Plugin by Gramercy Tech. Click into it and then click Individual Install / Install. 

6. Give the plugin permissions.

7. After the plugin is installed, please refresh the page. After refreshing you should see Eventfinity Plugin under Extensions in your sheet’s menu.

Back to Top

Plugin Setup

Things you will need for the setup:

1. Click on Extensions > Eventfinity Plugin > Eventfinity to bring up the settings window. Enter the required information , click the Submit

 button to save. After saving, refresh the page.

2. Click on Extensions > Eventfinity Plugin > Eventfinity to bring up the settings window again, but now there is a new Data Connectors view. Click the plus button to add a new Data Connector.  

3. Select the Data Connector and add a new one.

 

Once the configuration data has been entered, hit the Submit button to save the Connector.

Back to Top


Data Source Specific Configurations

Attendees

This Data Source type has an optional field for Saved Search ID. Saved Search is a feature in the Eventfinity dashboard that allows users to filter down attendee data based on specific parameters in the Saved Search.

If you enter a Saved Search ID in the configuration this will limit the attendees imported into the spreadsheet to attendees only in that saved search. 

If this field is left blank, all attendees from the event will be pulled into the sheet.


Back to Top


Scans Specific Configurations

This Data Source allows you to enter an optional start time. If this is filled out, the import will only pull in scans that have been created after this start time.

Back to Top

DataDog Configurations

DataDog is a 3rd party monitoring and analytics service we use with our product. It can provide sessions and page views of specific pages over a specific date range. This Connector allows the user to build RUM queries for DataDog. Here is an explanation of what RUM queries are. 

This connector has the potential to import in millions of rows. Unless the data is selected in a specific and targeted way, this can be too much for a Google Spreadsheet to import. It is recommended that you contact the Product & Development team to help assist in setting this connector up.

Back to Top

Setting Up the Spreadsheet

Now you have to set up the column headers for the spreadsheet. Depending on which Data Source was selected depends on what your sheet column headers should be.

Attendees

Required column headers

Valid column headers can include any other event attendee field names. 

The column names must match exactly as they appear in Eventfinity for the data to be validated for import.



Scans

 Required column headers

 Valid column headers

DataDog

Required column headers:

 Valid column headers

Back to Top

Running the Import

Once your Connector and the spreadsheet headers have been set up and saved, you are ready to run your first import. Click on the blue download button for your Connector to import data.

Troubleshooting

Make sure your API token has the correct permissions and is for the correct event. If you are getting an error pulling data, try removing any extra columns that are not necessary for your import

Back to Top