marcustansoon/php-google-spreadsheet-data-extractor

Extract Google Sheet data via QUERY link method

PHP Google Sheet Data Extractor

Extract Google Sheet data via QUERY link method (without any Google Sheets API)

(Requires PHP 7.X)

Make sure to set your sheet to be public viewable

Sample usage

// Instantiate 'GoogleSheetDataExtractor' object
$googleSheetDataExtractor = new GoogleSheetDataExtractor();

// Extract data from sheet
$rows = $googleSheetDataExtractor->getData('<YOUR_SHEET_ID>', '<SHEET_NAME>', 'B5:D10', 'SELECT *');

// Display fetched per row data
var_dump($rows);

Result