Skip to content
Create Google Calendar Events and Send Gmail Invites
Share
Explore

Google Calendar Events and Gmail Invites

Create, Update, and Track events all from a Coda doc!
This template will walk you through creating an event, emailing invites, and retrieving the status of each attendee. There is only one table for this template which is then split into various views to better focus on the relevant columns for each step.

Copy this doc



Add Event Info
Here we can add all necessary event info. Our
Attendees
column is a
People
column type and will give us a dropdown option to choose people from our contacts. If you have a list of people, perhaps more of a CRM that’s you’re working from, you can have this column lookup to your list instead.
Summary
Description
Attendees
Start Date/Time
End Date/Time
1
Coda Meetup!
A gathering of great makers from all over the world!
AC
Alan Chowansky
LT
Lola Tseudonym
MM
Maria Marquis
PR
Polly Rose
FM
Felix Marlin
JD
Joel Davis
8/12/2020, 12:00 PM
8/12/2020, 2:00 PM
There are no rows in this table

Create the Event
Now we can create the event with the
Create Event
button. And if the event is already created, we can use the
Update Event
button to update any changed info. The
Event
column records the Event URL once its created with the button. This is also updated when the event is updated. This is also the Google Calendar Pack column and if you hover over a value here, you will see all of the event info being pulled in.

💡
If you update the event dates or times, all attendee statuses will be removed and your attendees will have to re-accept the invite.
Create Event
Update Event
Event
1
Create Event
Update Event
Coda Meetup!
There are no rows in this table

Send a Gmail Invite
If you’d like to send a custom invite to your attendees, you can do so with Coda’s Gmail Pack. You can customize the message per event or use a formula for the relevant columns to auto-create a message. This will only send an invite to each attendee once, so if you add people and update the event, the button will check to see if an email has already been sent and skip that person if it has. You can see who has already received an invite email in the
Emailed Invite
column.
Send Invite
Email Subject
Email Message
Emailed Invite
1
Send Invite
Invitation: Coda Meetup! -
8/12/2020, 12:00 PM
Hi,

I've scheduled a time for us to meet from
8/12/2020, 12:00 PM
to
8/12/2020, 2:00 PM
. Looking forward to chatting!

Sincerely,

System Writer
There are no rows in this table

Attendees by Status
With your event created and invites sent out, it’s time to track RSVP’s. We’re able to pull data from the Google Calendar Pack
Event
column and sort it in various ways. There are 4 statuses that Google Calendar uses and we can separate the attendees by how they’ve replied. Below is an example of a bulleted list pulling in both the name and the status of each attendee. This is a more complex formula to have the email address and the status listed. If you’re looking for just a list of emails, see the next section,
Email Lists by RSVP Status
.
RSVP - Accepted
RSVP - Needs Action
RSVP - Declined
RSVP - Tentative
1
maria@codadoc.io - accepted
al@codadoc.io - accepted
shishir@codadoc.io - needsAction
molly@codadoc.io - needsAction
laura@codadoc.io - needsAction
joe@codadoc.io - declined

There are no rows in this table

Email Lists by Status
If you’re looking for a list of just the email addresses of those that have accepted or are still thinking about accepting the invite, you can configure that as well. This is particularly useful when you want to send another email to a group either thanking them for signing up or reminding them to check their calendar and sign up.
Accepted Email List
Needs Action or Tentative Email List
Emailed Invite
1
maria@codadoc.ioal@codadoc.io
shishir@codadoc.iomolly@codadoc.iolaura@codadoc.io
There are no rows in this table

Calendar View
Would you rather create, update, and track events in an actual calendar view? That’s no problem with Coda’s calendar layout type. Click on any event to view or update it or right click on a day to create a new event!
Today
January 2022
MonthWeekDay


Questions?
If you have questions, please check out this topic on the

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.