CSV Data as a JSON API (Free)

Google Sheets allow JSON API GET endpoints

You can allow JSON API access to your Google Sheets.

This short article explains how.

The steps are as follows:

1. Create a Google project, and an API key
2. Ensure your Google Sheet is public
3. Enter the correct URL for JSON API access
4. Enable Google Sheets API access
5. Refresh

1. Create a Google project, and an API key

First you need to set up a Google project, and an API key,
follow the steps in this Google support article:

Setting up API keys

2. Ensure your Google Sheet is public