Create AddEvent Events from Google Sheets using Zapier

Overview

With this automation, adding or updating a row in a Google Sheet will trigger Zapier to create a new event in AddEvent using the row’s details.

You’ll need:

• A Google Sheets account
• A Zapier account
• An AddEvent account with API access (available on all paid plans)

Step 1: Prepare Your Google Sheet

Create a Google Sheet that will store your event details. At minimum, we recommend the following columns:

• Event Name
• Start Date
• Start Time
• End Date
• End Time
• Location (optional)
• Description (optional)
• Ready for AddEvent Creation (trigger column)

ISO Date & Time Requirement

Zapier requires event start and end times to be in ISO format when sending data to AddEvent.

To handle this:

• Keep Start Date / Start Time and End Date / End Time
• Create additional columns (for example, ISO Start and ISO End) that concatenate date and time into ISO format using formulas

This ensures Zapier can correctly process the event timing while keeping the sheet easy to use.

⚠️

Important: If dates and times are not in ISO format, the Zap will fail.

Step 2: Create the Zapier Trigger

1. In Zapier, create a new Zap

2. Choose Google Sheets as the trigger app

3. Select the trigger event:

   • New or Updated Spreadsheet Row (Instant)

Connect Google Sheets

• Connect your Google account
• Select the spreadsheet
• Select the worksheet

Configure the Trigger Column

Choose a trigger column (for example: Ready for AddEvent Creation).

How this works:

• When a user finishes entering event details
• They add a value (such as today’s date) to the trigger column
• This action triggers the Zap to run

Test the trigger to confirm Zapier can successfully read rows from your sheet.

Step 3: Connect AddEvent to Zapier

1. Add an Action step

2. Select AddEvent as the app

3. Choose the action event:

   • Create Event

Find Your AddEvent API Token

1. Log in to your AddEvent dashboard
2. Click your profile icon (bottom-left)
3. Go to Account & Settings → Settings
4. Copy your API Token
5. Paste it into Zapier when prompted

Step 4: Configure the AddEvent Action

Map each Google Sheet column to the corresponding AddEvent field.

Required Fields

• Title → Event Name column
• Calendar → Select the target AddEvent calendar
• Start Date & Time → ISO Start column
• End Date & Time → ISO End column
• Time Zone → Select from your AddEvent time zones

Optional Fields

• All-day Event → Set to true if no specific times apply
• Recurring Event → Leave blank unless needed
• Location → Location column
• Description → Description column

Event Color

• Colors are assigned using Color ID numbers (1–20)
• These correspond to your Color Palette in Account & Settings
• Example: 1 applies the first color in your palette

The color affects how the event appears in your AddEvent dashboard.

Landing Page & RSVP Settings

• Landing Page Template → Select an existing design
• RSVP Enabled → Set to true or false
• RSVP Form → Optional; select from existing forms

Organizer Details

• Organizer Name / Email are optional
• If left blank, AddEvent will use your account defaults

Step 5: Test the Zap

Zapier will display:

• Data In (from Google Sheets)
• Data Out (sent to AddEvent)

Run a test to confirm the event is created successfully.

Step 6: Trigger a Live Event Creation

1. Add a new row (or duplicate an existing one) in your Google Sheet
2. Fill in all required event details
3. Enter today’s date (or any value) in the trigger column

This will instantly run the Zap.

Step 7: View Event is in AddEvent

In your AddEvent dashboard, confirm:

• Event date and time are correct
• Time zone is accurate
• Description and location display properly
• Dashboard color is applied as expected

Watch this tutorial!

You’re all set! 🎉 Your team can now create AddEvent events directly from Google Sheets using Zapier. If you have any questions while setting this up or testing your Zap, our team is happy to help. Email: (mailto:[email protected]