Complexity:
Medium
Useful links:
How to export event attendees and status from Salesforce using Workbench
This guide explains how to pull a list of event attendees and their RSVP status from Salesforce — useful for tracking attendance-based payments or participation records.
Background
Salesforce stores event attendee data in an object called EventRelation. Every time someone is invited to a calendar event, a record is created in EventRelation linking that person to the event along with their current response status (Accepted, Declined, Tentative, or Not Responded).
Steps:
1. Go to workbench.developerforce.com and log in with your Salesforce credentials.
2. In the top navigation, go to Queries → SOQL Query.
3. Paste the following query into the text field:
SELECT
Event.Subject,
Event.StartDateTime,
Relation.Name,
Relation.Email,
Status
FROM EventRelation
WHERE Event.StartDateTime >= 2025-01-01T00:00:00Z
AND IsInvitee = TRUE
ORDER BY Event.StartDateTime DESC, Relation.Name ASC
4. Adjust the date in the WHERE clause to match your desired time range.
5. Set View as to Bulk CSV if you want to download the results as a spreadsheet.
6. Click Query.
Notes
The
Statusfield always reflects the attendee's current response — there is no need to filter for the latest update.IsInvitee = TRUEensures you only see invited attendees and not the event organizer, who would otherwise appear as a duplicate row.If you need to filter for a specific event, add
AND Event.Subject = 'Your Event Name'to the WHERE clause.