SheetLatch / Guides

Connect Bolt.new to a Google Sheet

Give Bolt a URL and a header instead of asking it to set up Google credentials.

Prompt

Replace the hard-coded product data with rows from this JSON API.

GET https://sheetlatch-api.quietlathe.com/v1/SHEET_ID/Products?limit=20
Header: x-api-key, read from an environment variable named SHEET_API_KEY on the server.

Each row is an object keyed by the column names in row 1. Numbers and booleans are typed.
Call the API from a server route, never from browser code. Show loading and error states.

Check the result

Open the browser network tab. The page should call your own server route, and that route should call the API. If the key shows up in a browser request, ask the builder to move the call to the server.

Look at the x-cache response header while you test. After the first call it should say HIT for the next minute.

Early access. SheetLatch opens soon. Join the early-access list and we will email you once when it does. Planned free plan: 1,000 requests a month. SheetLatch is not affiliated with Google.