Skip to main content
Integrate with Google Sheets

Connect your Google Sheets account to Accelevents to add attendee information to a sheet

Ariane Ramirez avatar
Written by Ariane Ramirez
Updated over 3 weeks ago

Add Attendees to Google Sheet Rows

You can integrate Google Sheets with Accelevents to automatically create rows for new registrations. When the order is updated the mapped data will also update in Google Sheets.

Note: This integration is only available for Scale/Business, Professional, Enterprise, and White Label accounts.


Connect the Integration

  1. Go to your Organizer Portal by clicking the Manage Organization found on the bottom left corner of the event admin console.

  2. Go to the Integrations tab and click Connect under Google Sheets to begin.

    If you're not seeing the Integrations tab, you'll need to access your Enterprise or White Label Dashboard to see the Integrations tab. Click My Enterprise from the Organizer Portal to take you to your Enterprise or White Label Dashboard, where you should find the Integrations tab.

    You can also access the direct Enterprise or White Label Dashboard URL to see the Integrations tab. The URL would look something like this:

  3. Select the organizer you want to connect by clicking the circle next to the organizer's name. Then, click Connect Now.

  4. Another pop-up will appear where it will ask you for authentication. This is required to push data to your integration.

    • Click on New Authentication

    • Name the authentication, then click Create.

    • On the next pop-up, log in to your Google account.

    • Allow all the permissions.

    • Note: If the pop-up to sign in appears again, go ahead and log in again until you get to the end where you can click the Finish button.

  5. Click Finish

  6. After clicking Finish, return to the Integrations tab and wait for the integration to enable. The green button under Google Sheets will turn red once enabled and connected.


Select the Google Sheet File and Map Fields

  1. Go back to the event's admin console, then go to Settings > Integrations, then click Configure under the Google Sheet automation. It may take a few seconds for the menu to load as it's connecting to your Google Drive.

  2. Choose where the Google Sheet rows will be created

    • Auto-generated Google Sheet - Accelevents will generate a Google Sheet file which will be saved in the connected Google Drive with the last part of the event URL as the file name. You can move the file to another folder but do not rename the file or the sheet to ensure that it does not generate another file.

    • Existing Google Sheet - A new sheet (tab) will be created in the selected file with the last part of the event URL as the sheet name. Do not rename the sheet tab to ensure it does not generate another one.

  3. Select the fields you want to show in the sheet and click Save. If the mapping fields are not showing, exit from the configure menu and open it again to reload.

    • The data that will be exported will come from the ticket holder's information

    • By default, the ticket holder's name and email will always be included so it's not part of the selection

    • The Ticket ID is enabled and cannot be turned off as this is required as this will be the identifier when cells are to be updated when changes are done in the order

    • The fields available are the default & custom order form fields and other auto-generated fields:

      • Order ID

      • Ticket ID

      • Ticket Type

      • Barcode ID

      • Tracking Link

      • Ticket Status

      • Coupon Code

      • Access Code

      • Limited Display Code

      • Paid Amount

      • Magic Link

  4. Enable the ticket holder order form fields you selected in the mapping

    • Go to Registration > Order Form

    • Select Ticket Holder

    • Enable the order form fields included in the mapping

That's it! Test this by registering for the event. A new Google Sheet row will be created for the purchase. If there are multiple tickets or add-ons in the order, it will create multiple rows for each line item. When updates are done in Accelevents, the Google Sheet rows will be updated too.

  • You can change the order of the columns after the sheet is generated

  • Additional mapping after generating the sheet will appear at the end of the sheet when a new registration comes in

Did this answer your question?