Google Sheets to API for Webflow and Framer

Both tools let you add custom code. Fetch the rows and fill the page.

<ul id="list"></ul>
<script>
fetch("https://sheetlatch-api.quietlathe.com/v1/SHEET_ID/Products?limit=20", { headers: { "x-api-key": "tr_live_..." } })
  .then((r) => r.json())
  .then((rows) => {
    const ul = document.getElementById("list");
    rows.forEach((r) => {
      const li = document.createElement("li");
      li.textContent = r.name + ": " + r.price;
      ul.appendChild(li);
    });
  });
</script>

This puts the key in page source, so anyone can read it. Use a free key on a sheet that is public anyway, and revoke it if it is abused. Keep private sheets behind a server.

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.