Google Sheets

Simplify the process of gathering event registrant data

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 the registrant's 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 (other 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 see its connected state, and you will be 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 and set your Google Sheets Integration as Active.

If you click on the Settings Cog Wheel, you'll see where we can connect the spreadsheet and worksheet that 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 FIRST, and if you do, that will auto-populate so you can connect the data.

  • Once you do this, connecting the Pre-Existing Header Names will look as follows:

Way No. 2 No Prefilled Header Names

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

  • If you create a blank Spreadsheet and a Workbook, we can create the Header Names directly from the Integration setting 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.

  • Once your registration page gets its first registrant, the Header Names will populate in your Google sheet.

That is how to set up Google Sheets to capture Registrant info from registration. Above are the two ways you can achieve this.

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, the first step we recommend is reconnecting your integration.

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

  • Choose the account.

  • Now click Continue when this popup comes up.

Once your Google Sheets account has been successfully Re-Connected, you will see its Connected state and can 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 integration from AEvent:

  • You need to navigate to Integrations.

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

  • You will then be prompted to confirm the deletion.

⚠️ NOTE: ⚠️

Removing this integration will immediately affect its 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 reconnecting it instead.

This will allow its configuration to continue as set within your timelines.

AEvent's Google Sheet Template

We made a Google sheet template here that you can use. To use it, you need to copy it and edit it to the way you need it.

To copy it, you will need to select:

  • File

  • Make a Copy

  • Name it something that is related to your event.

Once you make the copy, you can use it as is and integrate it into your Event, or you can add or remove the Headers and Sheets.

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?