The Events Calendar Automations
How to Log Event Attendees to a Google Sheet When They Register in The Events Calendar
A shared spreadsheet is still the easiest guest list for a team to use at the door. Zapify can add a row for each person as they register, with no exporting and no copying, using the An attendee registers for an event trigger and the Add a row to a spreadsheet action. The Events Calendar and Google Sheets are Zapify PRO integrations.
What this automation does
The automation is one trigger plus one action:
- Trigger: An attendee registers for an event (
TEC_ATTENDEE_REGISTERED, The Events Calendar) - Action: Add a row to a spreadsheet (
GOOGLESHEETS_APPEND_ROW, Google Sheets)
Each time somebody registers, Zapify adds one row to your sheet with their name, email, ticket and the event they signed up for.
PRO feature
The Events Calendar and Google Sheets are Zapify PRO integrations. Both the trigger and the action used in this automation need an active Zapify PRO licence, and Google Sheets needs a Connection.
Needs Event Tickets
Attendees, RSVPs, check-ins and ticket orders come from Event Tickets, a separate free plugin from the makers of The Events Calendar. Without it, the trigger stays greyed out in the Zapify builder and says it requires Event Tickets.
Before you start
- The Events Calendar and Event Tickets installed and active.
- A Google Sheet with a row of column headings, such as Name, Email, Ticket, Event, Date.
How to build the automation
Step 1: Connect Google Sheets
Google Sheets connects by signing in rather than pasting a key.
- Go to Settings → Connections and click Add New.
-
Choose Google Sheets and click Connect.
-
Sign in with the Google account that has access to your sheet, and approve the permissions Google asks for.
See Connections for more on how this works and how to reconnect one that expires.
Step 2: Create a new automation
- In the WordPress admin, go to Zapify → Automations.
- Click Add New to open the builder.
- Name it clearly, such as Log event attendees to a sheet.
Step 3: Add the "An attendee registers for an event" trigger
- Click Add Trigger.
- Choose The Events Calendar as the app.
- Select the trigger An attendee registers for an event.
- Configure the trigger:
| Field | Required | What it does |
|---|---|---|
| Event | Yes | Pick the event to watch, or leave it on Any event. The list shows upcoming events and those from the last 90 days; type to search for an older one. |
| Ticket provider | No | Leave on Any provider to log RSVPs and ticket buyers together. |
Step 4: Add the "Add a row to a spreadsheet" action
- Click Add Action.
- Choose Google Sheets as the app.
- Select Add a row to a spreadsheet.
Step 5: Configure the action
| Field | Required | What it does |
|---|---|---|
| Connection | Yes | The Google account you connected in Step 1. |
| Spreadsheet ID | Yes | The long ID from your sheet's web address. |
| Sheet name | No | The tab to add to. Defaults to the first one. |
| Columns | Yes | One entry per column, left to right. |
Add these tokens as the Columns, in the same order as your sheet's headings: Attendee name, Attendee email, Ticket name, Event title, Event start.
Add extra columns for Order ID or Attendee custom fields if you ask attendees questions at sign-up.
Values that look like formulas are escaped
A value that starts with =, +, - or @ would otherwise be read by Sheets as a formula. Zapify escapes these automatically so it lands in the sheet as text.
Step 6: Set the steps Live and save
Each trigger and action has its own Live / Off / Draft switch. A new automation starts as a Draft and does nothing until its steps are Live.
- Set the trigger and every action to Live.
- Click Save.
Step 7: Test it
Register for the event with a test email address. A new row should appear in the sheet within a minute, or open Zapify → Logs to see the response.
Tokens you can use
| Token | What it holds |
|---|---|
| Attendee name / Attendee email | Who registered or checked in. |
| Ticket name / Ticket ID | Which ticket they hold. |
| Order ID | The RSVP or order the attendee belongs to. |
| Ticket provider | How they registered: RSVP, Tickets Commerce, WooCommerce, Easy Digital Downloads or PayPal (legacy). |
| Attendee custom fields | Any extra questions you ask attendees (Event Tickets Plus), as a ready-to-read list. |
| Event title / Event URL | The event and a link to it. |
| Event start / Event end | When it begins and ends. |
| Venue name / Venue address | Where it takes place. |
| Organizer name | Who is running it. |
| Event ID / Attendee ID | Numeric IDs, for advanced use. |
Conclusion
With the An attendee registers for an event trigger and the Add a row to a spreadsheet action, you get a live guest list that never needs exporting. For the same idea with WooCommerce sales, see logging WooCommerce purchases to a Google Sheet.
FAQs
Is this free in Zapify?
No. Both the Events Calendar trigger and the Google Sheets action need an active Zapify PRO licence, and Google Sheets also needs a Connection.
Do I need Event Tickets as well as The Events Calendar?
Yes, for anything to do with attendees, RSVPs, check-ins and ticket orders. The Events Calendar only manages the events themselves; Event Tickets is the free companion plugin that adds tickets and RSVPs. Without it, those triggers and actions show as unavailable in the builder.
Can I add a header row?
Add it by hand once in the sheet. Zapify only adds new rows beneath what is already there.
Can one sheet hold several events?
Yes. Leave Event on Any event and include the Event title token as a column, then filter the sheet by event.
Do I need to write any code?
No. Everything is configured visually in the Zapify builder.