You can sync your attendee data directly to a Google Sheets file, giving you a live, shareable data portal you can tailor to your audience, without sharing access to Humanitix directly. Sync only necessary ticket types, or remove financial or checkout question data for those who don't need to see it.
Avoid repetitively - and manually - exporting and trimming your data every time something changes, so your door staff, vendors, or venue coordinator always have exactly what they need.
How the Google Sheet integration works
The Google Sheet integration on Humanitix syncs your attendee list to a newly created Google Sheet managed by your Google account. Data is saved to a sheet named "HUMANITIX ATTENDEES".
Syncs are performed manually, not automatically.
All ticket types, attendee and financial data from the attendees report can be synced. You can choose not to sync:
Checkout question data
Answers to your custom checkout questions
Attendee names and buyer details, including name, email, and mobile, are still synced
Financial data
All ticket-level financial data, including price paid, fees, earnings, taxes, etc.
If you edit your sync settings, the synced data in your Google Sheet will be added or removed. For example, syncing a new ticket type or removing financial data will update your existing linked Google Sheet.
You can create and sync to multiple Google Sheets independently, if you would like to create different ticket types or sync setting configurations.
The power of Google Sheets
Once your attendee data has been synced to your Google Sheet, you can create your own additional sheets to create custom views using formulas or pivot tables.
Create custom ticket sale counts or checkout question views, then share access to specific sheets with your team and stakeholders.
Syncing data
Syncing a Google sheet will update it with all new attendees and any changes to your sync settings.
If you have made any manual changes to the data in the "HUMANITIX ATTENDEES" sheet in the Google Sheet, these will be overridden.
We recommend copy+pasting the data into a new sheet to prevent any data loss or creating a new spreadsheet.
How to create and sync your Google Sheet
Manage your event
Navigate to advanced > integrations (left-hand menu)
Select the Google sheets tab
Click connect Google account and follow the prompts
Once connected, click + create new spreadsheet configuration
Enter a name for the spreadsheet that will be created
Select the ticket types that will be synced
Toggle ON/OFF to:
Include checkout questions
Include financial data
Once your sheet has been created, click sync attendees
Attendee data won't be synced automatically.Click open spreadsheet to view your connected Google Sheet
Data is stored in a sheet called "HUMANITIX ATTENDEES"
