Parsing Google Sheets using PHP and JSON

Parsing public and shared Google Sheets as JSON with PHPJSON Web

// Parsing this spreadsheet:
$url = '';
$file= file_get_contents($url);
$json = json_decode($file);
$rows = $json->{'feed'}->{'entry'};
foreach($rows as $row) {
$title = $row->{'gsx$title'}->{'$t'};
$author = $row->{'gsx$author'}->{'$t'};
$review = $row->{'gsx$review'}->{'$t'}; 
echo $title . ' by ' . $author . ' ' . $review; 
echo '
'; } // See this here:

Getting data from other Google Sheets URLs

For sheet 2
For sheet 3

[ Original Spreadsheet


Visit sunny St. George, Utah, USA

Get In Touch

We would love to hear from you.

Please enter your email address.
Please enter a valid email address.
Please enter a message.
Please check your message for any errors.
Your message has been sent successfully.
Sorry, an error occured sending your message.
* required