Organizing an event with a lot of attendees? Use Google Calendar and Google Sheets to effectively manage events of any size. When you create an event for a large group, you can see and download guest replies, email addresses, and any added notes.
Invite a large group to an event
Note: Later, click the Down arrow next to the group’s name to see who has responded. Depending on the group’s settings, you may not have permission to see the group's member list.
View and export an RSVP list for a large group
To export an RSVP list, you need to have edit rights to a group of 200 people or more.
Note: You will only see the RSVP status of group members that you have permission to see.
- On your computer, open the event on the original calendar where the event was created.
- Select Export guest responses to Sheets.
Sheets makes a list from the current RSVP list.
- (Optional) To update the list later in the same sheet, repeat the steps.
The up-to-date responses appear on a new tab in the sheet.