All use cases
Founders & makers

A product waitlist with GKit SheetsAPI

Build a product launch waitlist with GKit SheetsAPI - capture email signups straight into a Google Sheet via REST, then export the list as CSV when you launch.


Capture launch signups into a Google Sheet

Building toward a launch and want to collect interested emails without wiring up a database or a signup service? Point your landing page at GKit SheetsAPI and every "notify me" form turns into a new row in a Google Sheet you already control.

The sheet is your waitlist. No dashboards to learn, no exports to schedule - the list lives somewhere you and your teammates can read, sort, and share instantly.

Set it up in three steps

  1. Make a sheet with a header row - for example email, name, referrer. The first row defines your JSON field names.
  2. Connect your Google account and copy your endpoint.
  3. POST the signup from your landing page when someone joins:
await fetch(
  "https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/Waitlist",
  {
    method: "POST",
    headers: { "Content-Type": "application/json" },
    body: JSON.stringify({ email, name, referrer }),
  },
);

That single request appends a row. You can also send an array of objects in one POST if you ever need to import signups in bulk. While SheetsAPI is in beta, your endpoint is public by default - create an API key when you want to lock writes down, then send Authorization: Bearer sk_... with each request.

Watch the list grow

Because every signup is a row, you can keep an eye on momentum without any extra tooling. Read the current list back with a simple GET:

const res = await fetch(
  "https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/Waitlist?sort=-email&limit=50",
);
const recent = await res.json();

List requests support handy query params: limit and offset for paging, search=field:value for a case-insensitive lookup (say, finding a specific signup by email), sort (prefix with - for descending), and fields to return just the columns you care about.

Export as CSV on launch day

When you are ready to send your launch announcement, you do not have to copy-paste anything. Ask the same list endpoint for CSV and pipe it straight into your email tool:

curl "https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/Waitlist?format=csv" \
  -o waitlist.csv

The format param also supports tsv, xml, and jsonp if your downstream tool prefers a different shape. Your whole waitlist drops into a clean CSV, ready to import.

That is the entire stack: a Google Sheet, one POST per signup, and a CSV export when it counts. SheetsAPI is free while in beta.

Connect a sheet and start your waitlist today.