How to get list of sheets from google spread sheet in php

Question

I am using php-google-spreadsheet-client library. I don't know how to get list of sheets available in google sheets. Thanks in advance.

score 5 · Answer 1 · answered Apr 04 '18 at 20:46

<?php

function sheets($spreadsheetID) {
    $sheets = array();    
    // Load Google API library and set up client
    // You need to know $spreadsheetID (can be seen in the URL)
    $sheetService = new Google_Service_Sheets($client);   
    $spreadSheet = $sheetService->spreadsheets->get($spreadsheetID);
    $sheets = $spreadSheet->getSheets();
    foreach($sheets as $sheet) {
        $sheets[] = $sheet->properties->sheetId;
    }   
    return $sheets;
}
?>

score 2 · Answer 2 · edited May 23 '17 at 12:32

You can get a list of sheets by using the get method on spreadsheets:

sheet_metadata = service.spreadsheets().get(spreadsheetId=spreadsheet_id).execute()
sheets = sheet_metadata.get('sheets', '')
title = sheets[0].get("properties", {}).get("title", "Sheet1")
sheet_id = sheets[0].get("properties", {}).get("sheetId", 0)

You can also check the PHP Quickstart for a PHP command-line application that makes requests to the Google Sheets API.

References:

How to get list of sheets from google spread sheet in php

2 Answers2