This repo connects Google Sheet data to an Astro website using opensheet.
To get started, clone fork or download this repo and run npm install in the directory to install dependencies.
To build the project run locally npm run dev and open localhost:4321 in your browser.
For further info and documentation on Astro, check out the Astro docs.
The sheet ID is the long string of characters in the URL of your Google Sheet.
Note that you will need headers in your sheet for the data to render properly. Drag the first row down to the second row to create headers.
The content on the index page is rendered via the src/Sheets.astro component. Edit the response URL like so:
"https://opensheet.elk.sh/[GOOGLESHEET-ID-HERE]/1"