Reading a Google Sheet in JSON

Using a Google Sheet as a data source is sometimes extremely helpful especially if it's the client who is maintaining the information.

The following table is an example of one.

ONE3 Website
Google Search


It reads from this Google Sheet. It doesn't require Google Sheet APIs. Obviously it takes some coding in PHP to read the file and extract the information. But once done, the client just needs to update the Google Sheet.

This is a Joomla article that you are reading. The PHP code to extract the Google Sheet information is embedded into the Joomla article. So no need to include PHP files.