Event RSVP backend with GKit SheetsAPI

Collect RSVPs straight into a Google Sheet

Running a meetup, workshop, or party and need somewhere to put the "yes, I'm coming" replies? Skip the booking platform. Point your RSVP form at GKit SheetsAPI and every response lands as a new row in a Google Sheet you already control.

The first row of your sheet defines the fields. Make a tab called RSVPs with a header row like name, email, guests, attending, and you are ready to collect.

POST a response from your form

When someone submits your RSVP form, send their details to your endpoint. The shape is /api/spreadsheets/{userKey}/{sheetName}, and the body can be a single object (one RSVP) or an array (a batch):

await fetch(
  "https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/RSVPs",
  {
    method: "POST",
    headers: { "Content-Type": "application/json" },
    body: JSON.stringify({
      name: "Ada Lovelace",
      email: "ada@example.com",
      guests: 2,
      attending: "yes",
    }),
  },
);

That POST appends a row. Because the field names come from your header row, the JSON keys map directly to the columns - no schema to configure, no migration to run. CORS is enabled, so you can call the endpoint straight from the browser on your event page.

See attendees live in the spreadsheet

The best part for an organizer: there is no separate dashboard to learn. As RSVPs come in, they appear in the spreadsheet in real time. Sort by date, filter the attending column, sum the guests column for a headcount, or share the sheet with a co-host - all the things you already do in Sheets.

When you need responses back out of the API, the same endpoint lists rows and supports handy query params:

• search=attending:yes - case-insensitive substring match to pull confirmed guests.
• sort=-guests - order by party size, descending.
• fields=name,email - return just the columns you need for a check-in list.
• format=csv - export the guest list for printing or a badge tool.

A single GET like https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/RSVPs?search=attending:yes&fields=name,guests gives you a clean confirmed-attendee list.

Lock it down when you go live

While you are building, the API is public so you can test without friction. When your event page is live and you would rather not leave the endpoint open, create an API key and send it with each request:

Authorization: Bearer sk_...

You can also delete a duplicate or test row with DELETE /api/spreadsheets/{userKey}/RSVPs/{row} (rows are 1-based), or correct an entry with PUT to the same path.

GKit SheetsAPI is in beta and free while in beta, which makes it a low-commitment way to run a one-off event without signing up for yet another paid tool.

Connect a sheet and start collecting RSVPs today.