Sheet-Sync | Simple Data API

A Simple API which can get data from a Published (CSV) Google Sheet and return the data in JSON format. This is an example and a working prototype. Anyone can customize it as per their needs.

You Can

• Run in server / client side
• Use environment variables and secrets for security
• Return only required data
• Customize

---

How to Run

• Get a Google Sheet and publish the sheet as CSV. The sheet may have such data:

Date        Text                              Link            Status
04/02/2025  This announcement is ONE          example.com     Published
04/02/2025  This announcement is without link                 Published
04/02/2025  This announcement is published    example.com     Published
02/02/2025  This is a DrAft annoucement                       Draft

• Get the published link
• Open api/fetch.js
• Find const PUBLISHED_URL = ""; and place the link inside the quotes " "
• Open index.html and see your data! (Note: index.html needs formatting as per the data your Google Sheet has)

---

Workflow Diagram