Overview

The Public Google Sheet Library in allows you to fetch and use data from any publicly shared Google Sheet in your project. It's ideal for dynamic content that's managed externally in spreadsheets—like lists, tables, or lightweight CMS-style data.

Purpose

This library provides a simple way to connect a Clutch project to Google Sheets without authentication, using only the spreadsheet's public URL. It fetches data server-side using a helper function and returns structured JSON for use in your components or queries.

Why It Exists

Connecting to Google Sheets programmatically can be complex due to authentication requirements and APIs. This library removes that barrier by:

• Fetching data from a public Google Sheet with just a spreadsheet ID.
• Supporting optional configuration like targeting a specific sheet or preserving formatting.
• Letting non-technical users manage content via Google Sheets while developers fetch it easily in Clutch.

It's a lightweight solution for projects that need simple, collaborative data management without needing a full CMS or backend.