Generate TypeScript types from a Google Sheet

How to generate types from a Google Sheet

1. 1 In Google Sheets, click Share, then set General access to Anyone with the link (Viewer is enough). If you skip this, the tool cannot read the sheet — check whether yours is public.
2. 2 Copy the sheet URL from your browser's address bar. To use one specific tab, open that tab first so its gid ends up in the URL.
3. 3 Paste it above. Each header becomes a property; each column's values are scanned to infer its type.
4. 4 Copy the interface into your project.

What the output looks like

export interface SheetRow {
  name: string;
  role: string;
  headcount: number;
  active: boolean;
  "Start Date": string;
}

How the types are inferred

The same column-type inference PasteSheet runs when you connect a sheet as an endpoint:

• Every value in the column parses as a number → number.
• Every value is a boolean-ish token (true/false, yes/no, 1/0) → boolean.
• Every value parses as a date → string, because a date crossing JSON is a string, not a Date.
• Anything else, or a mixed column → string.
• A header that is not a valid TypeScript identifier is emitted as a quoted property — Start Date becomes "Start Date" rather than a syntax error. The header is never renamed for you, because the key you get back in the JSON is the header.

Types describe a shape — they do not fetch it

An interface tells your compiler what a row looks like. It does not get you the rows. For that you still need something to read the sheet at runtime, which is the part that normally means a Google Cloud project and a service account.

A PasteSheet endpoint gives you a plain JSON URL to fetch(), so the interface above and the data it describes come from the same place — and the endpoint watches the sheet's schema, so if someone renames a column the types you generated do not silently start lying. See the React guide.

What a live endpoint costs

Nothing, to start. The Free plan gives you 3 endpoints and 2,000 requests a month, with MCP included and no credit card. The tool above stays free and unlimited either way.

Frequently asked questions

Sources

• Authorize requests — Google Sheets API — Google
• Usage limits — Google Sheets API — Google
• Publish a file from Google Docs, Sheets, Slides or Forms — Google Docs Editors Help

Related tools