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
Go to your Organizer Portal by clicking the Manage Organization found on the bottom left corner of the event admin console.
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:
Select the organizer you want to connect by clicking the circle next to the organizer's name. Then, click Connect Now.
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.
Click Finish
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
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.
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.
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
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