Google Sheets

This integration offers a wealth of benefits

AEvent avatar
Written by AEvent
Updated over a week ago

Teaming up AEvent with Google Sheets simplifies the process of gathering event registrant data. No more manual downloads or CSV sheets; as registrants sign up, their information is instantly transferred to a Google Sheet.

With AEvent's Custom Fields, you can collect not only standard data like names and emails but also tailored details such as join dates and custom information specific to your event.

In short, AEvent and Google Sheets work seamlessly together to make event management more efficient and data-driven.

Timeline Actions:

Adding your Google Sheets Account to AEvent

When someone registers for your webinar, AEvent communicates this to Google API and allows you to capture registrants info on registration to a Google Sheet.

SO, as a Best Practice, we recommend utilizing a Google Account that is NOT tied to a Phone, a Computer, etc. (Can you imagine getting 500 alerts?).

Either use a Google account that has no other uses (than Calendar), or open a new Google Account for this integration.

  • To add your Google Sheets Integration you will need to first navigate to Integrations within AEvent, click Add Integration and then select Google Sheets

  • Then name your integration as you see fit, and click 'Add'

  • Next, select the Google account that you plan to use for this integration.

  • And click on 'Allow'

  • Once your Google Sheets account has been successfully added, you will be see it's Connected state, and you are able to click on 'Test'.

  • A successful connection will yield a positive test result.

Congratulations, your Google Sheets account is now successfully connected to AEvent!

Configuring your Google Sheets Integration within a Timeline

In order to utilize your Google Sheets Integration within AEvent, you need to activate it within the timeline you are working with. To do this, open the timeline you are working on.

Then select Integrations, set your Google Sheets Integration as Active.

If you click on the Settings Cog Wheel, you'll see there where we can connect your Spreadsheet and Worksheet you want to use for this event.

For best results use a new Spreadsheet per timeline/event

Way No. 1 Pre-Existing Header Names

  • Now you can have the header names in your Google Sheet 1st and if you do that will auto populate so you can connect the data

  • Once you do this is what the Pre-Existing Header Names connected will look like

Way No. 2 No Prefilled Header Names

Now you do not need to have the headers pre-filled out.

  • You create a Spreadsheet and a Workbook and that workbook is blank, we can create the Header Names right from the Integration setting right there in AEvent

  • To add the header from here you will need to click the Add Header Name button

  • You cannot edit the Headers from here. Make sure you enter the text the way you want it

  • And once your registration page gets its 1st registrant the Header Names will populate in your google sheet

That is how to set up Google sheets to capture Registrant info from registration. You have two ways you can achieve this above to follow.

How to reconnect your Google Sheets Integration

If you are encountering issues with your Google Sheets integration it is possible that your login information has changed from Google Sheets, has been reset, or has been closed.

  • If you click 'Test' and it is NOT successful, first step we recommend is reconnecting your integration.

  • Click Re-Connect you will need to re-login to your Google Sheets account

  • And choose the account

  • Now click Continue when this popup comes up

Once your Google Sheets account has been successfully Re-Connected, you will be see it's Connected state, and you are able to click on 'Test'.

A successful connection will yield a positive test result.

Congratulations, your Google Sheets account is now successfully connected to AEvent!

How to remove your Google Sheets Integration from AEvent

If you want to remove your SlickText integration from AEvent,

  • You need to navigate to Integrations,

  • Locate your Google Sheets integration and click on the Trashcan icon.

  • You then will be prompted to confirm deletion

⚠️ NOTE: ⚠️

Removing this integration will immediately effect

it's use with any timelines that it is active in.

IF you are experiencing issues with this integration, but do not desire to REMOVE it, we recommend on reconnecting it instead.

This will allow it's configuration to continue as set within your timelines.

NOTICE: Google Sheets does not have a daily limit to the number of requests you can make per day as long as you stay within the per minute quotas

🆘 Troubleshooting

If you have any problems with your integration:

  • The first thing to do is press the "Test" button on the Integration.

    • This will confirm if the connection to the integration is valid.

    • If you continue to have problems, delete and re-add the integration.

Did this answer your question?