Google客户端API-缺少require参数:redirect_uri

只需在客户端对象上使用方法setRedirectUri($absoluteUrl)：

$client = new Google_Client();
$client->setRedirectUri('http://' . $_SERVER['HTTP_HOST'] . '/oauth2callback.php');

通过：

https://developers.google.com/api-client-library/php/auth/web-app

我开始工作了。我要做的就是回到谷歌开发者控制台，删除我创建的项目。然后，在制作一个新项目时，它允许我保存本地主机url。出现的问题是，当我去将我的本地主机url添加到重定向url时，它会说此时不可能。当我在点击创建按钮之前设置重定向url时，它会很好地接受它。

Google针对Sheet API的"PHP快速入门"文档似乎在https://developers.google.com/sheets/api/quickstart/php.

为了让他们的演示与PHP 7.2+一起工作，我不得不修改了很多，但还不清楚发生了什么。下面是他们快速入门的评论更新版本，这可能对其他在使用Google Sheets API和PHP时有困难的人有帮助。

<?php
/**
 * Updated Google Sheets Quickstart
 *
 * https://developers.google.com/sheets/api/quickstart/php
 */
require __DIR__ . '/vendor/autoload.php';
/**
* Appends one slash at the end, and removes any extra slashes
* https://stackoverflow.com/a/9339669/812973
*
* @return string $path with the slash appended
*/
function addTrailingSlash ($path)
{
    return rtrim ($path, '/') . '/';
}
/**
 * Returns an authorized API client.
 * @return Google_Client the authorized client object
 */
function getClient() {
     // Change this to a secure location where you'll save your config *.json files
     // Make sure it isn't publicly available on the web
    $configPath = addTrailingSlash (getcwd());
    // This get's generated by the script, so don't create it
    $credentialsPath = $configPath . 'credentials.json';
    $client = new Google_Client();
    // Matches the "Application Name" you enter during the "Step 1" wizard
    $client->setApplicationName( 'API App Name' );
    $client->setScopes( Google_Service_Sheets::SPREADSHEETS_READONLY );
    // You need to go through "Step 1" steps to generate this file: https://developers.google.com/sheets/api/quickstart/php
    $client->setAuthConfig( $configPath . 'client_secret.json' );
    $client->setAccessType( 'offline' );
    // This must match the "callback URL" that you enter under "OAuth 2.0 client ID" in the Google APIs console at https://console.developers.google.com/apis/credentials
    $client->setRedirectUri( 'https://' . $_SERVER['HTTP_HOST'] . '/' . basename( __FILE__, '.php' ) );
    // We have a stored credentials file, try using the data from there first
    if ( file_exists( $credentialsPath ) ) {
        $accessToken = json_decode( file_get_contents( $credentialsPath ), true );
    }
    // No stored credentials found, we'll need to request them with OAuth
    else {
        // Request authorization from the user
        $authUrl = $client->createAuthUrl();
        if ( ! isset( $_GET['code'] ) ) {
            header( "Location: $authUrl", true, 302 );
            exit;
        }
        // The authorization code is sent to the callback URL as a GET parameter.
        // We use this "authorization code" to generate an "access token". The
        // "access token" is what's effectively used as a private API key.
        $authCode = $_GET['code'];
        $accessToken = $client->fetchAccessTokenWithAuthCode( $authCode );
        // Create credentials.json if it doesn't already exist (first run)
        if ( ! file_exists( dirname( $credentialsPath ) ) ) {
            mkdir( dirname( $credentialsPath ), 0700, true );
        }
        // Save the $accessToken object to the credentials.json file for re-use
        file_put_contents( $credentialsPath, json_encode( $accessToken ) );
    }
    // Provide client with API access token
    $client->setAccessToken( $accessToken );
    // If the $accessToken is expired then we'll need to refresh it
    if ( $client->isAccessTokenExpired() ) {
        $client->fetchAccessTokenWithRefreshToken( $client->getRefreshToken() );
        file_put_contents( $credentialsPath, json_encode( $client->getAccessToken() ) );
    }
    return $client;
}
// Get the API client and construct the service object.
$client = getClient();
$service = new Google_Service_Sheets( $client );
// Get values from a spreadheet and print
// https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get
$spreadsheetId = '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms';
$range = 'Class Data!A2:E';
$response = $service->spreadsheets_values->get($spreadsheetId, $range);
$values = $response->getValues();
if (empty($values)) {
    print "No data found.'n";
} else {
    print "Name, Major:'n";
    foreach ($values as $row) {
        // Print columns A and E, which correspond to indices 0 and 4.
        printf("%s, %s'n", $row[0], $row[4]);
    }
}

这个答案可能不能完全满足您的需求，但是：

如果您只需要读取对工作表的访问权限，那么您只需要一个Google服务帐户凭据文件（credentials.json）。

可以简单地将示例中的令牌检索部分分为如下部分：

<?php
require __DIR__ . '/vendor/autoload.php';
if (php_sapi_name() != 'cli') {
    throw new Exception('This application must be run on the command line.');
}
/**
 * Returns an authorized API client.
 * @return Google_Client the authorized client object
 */
function getClient()
{
    $client = new Google_Client();
    $client->setApplicationName('Google Sheets API PHP Quickstart');
    $client->setScopes(Google_Service_Sheets::SPREADSHEETS_READONLY);
    $client->setAuthConfig('credentials.json');
    $client->setAccessType('offline');
    $client->setPrompt('select_account consent');
    return $client;
}

// Get the API client and construct the service object.
$client = getClient();
$service = new Google_Service_Sheets($client);
// Prints the names and majors of students in a sample spreadsheet:
// https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
$spreadsheetId = '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms';
$range = 'Class Data!A2:E';
$response = $service->spreadsheets_values->get($spreadsheetId, $range);
$values = $response->getValues();
if (empty($values)) {
    print "No data found.'n";
} else {
    print "Name, Major:'n";
    foreach ($values as $row) {
        // Print columns A and E, which correspond to indices 0 and 4.
        printf("%s, %s'n", $row[0], $row[4]);
    }
}

谷歌应该在他们的示例IMO.中提到这一点。

我的问题是我没有在谷歌控制台中初始化URI解决问题：

1-转到您的项目https://console.cloud.google.com/（从顶部选择项目）

2-搜索"；Google表单API"；确保已启用

3-在左侧菜单上单击"；凭证"；

4-如果您已经创建了"；OAuth 2.0客户端ID"；只需点击编辑并添加URI，否则创建新的"URI"；OAuth 2.0客户端ID"；

5-记得重新下载"OAuth 2.0客户端ID"；它将是类似于"；client_secret_XXX.apps.googleusercontent.com"；将其重命名为credentials.json，并在您的项目中设置它

只是改进了@kevinLeary的答案，使代码看起来更模块化：

<?php
    if (!file_exists(__DIR__ . '/vendor/autoload.php')) {
        throw new Exception(sprintf('Please run "composer require google/apiclient:~2.0" in "%s"', __DIR__));
    }
    require_once __DIR__ . '/vendor/autoload.php';
    $redirect_url = 'http://' . $_SERVER['HTTP_HOST'] . '/mydrive/index.php'; // <--- Change it to your web application path, host will be detected automatically  
    $auth_file = __DIR__ . DIRECTORY_SEPARATOR . 'drive-auth.json'; // <--- Your auth2 settings
    $auth_file = str_replace('''', '/', $auth_file);
    $configPath = addTrailingSlash(getcwd());
    $credentials_file = $configPath . 'credentials.json'; // <--- This will generated automatically

    $app_name = 'MY APP NAME';
    $scopes = [
                Google_Service_Sheets::SPREADSHEETS_READONLY, 
            ];
    /**
     * Returns an authorized API client.
     * @return Google_Client the authorized client object
     */
    function getClient($app_name, $auth_file, $credentials_file, $redirect_url, $scopes = array()) {
        // This get's generated by the script, so don't create it
        $credentialsPath = $credentials_file;
        $client = new Google_Client();
        // Matches the "Application Name" you enter during the "Step 1" wizard
        $client->setApplicationName( $app_name );
        $client->setScopes( $scopes );
        // You need to go through "Step 1" steps to generate this file: https://developers.google.com/sheets/api/quickstart/php
        $client->setAuthConfig( $auth_file );
        $client->setAccessType( 'offline' );
        // This must match the "callback URL" that you enter under "OAuth 2.0 client ID" in the Google APIs console at https://console.developers.google.com/apis/credentials
        $client->setRedirectUri( $redirect_url );
        // We have a stored credentials file, try using the data from there first
        if ( file_exists( $credentialsPath ) ) {
            $accessToken = json_decode( file_get_contents( $credentialsPath ), true );
        }
        // No stored credentials found, we'll need to request them with OAuth
        else {
            // Request authorization from the user
            $authUrl = $client->createAuthUrl();
            if ( ! isset( $_GET['code'] ) ) {
                header( "Location: $authUrl", true, 302 );
                exit;
            }
            // The authorization code is sent to the callback URL as a GET parameter.
            // We use this "authorization code" to generate an "access token". The
            // "access token" is what's effectively used as a private API key.
            $authCode = $_GET['code'];
            $accessToken = $client->fetchAccessTokenWithAuthCode( $authCode );
            // Create credentials.json if it doesn't already exist (first run)
            if ( ! file_exists( dirname( $credentialsPath ) ) ) {
                mkdir( dirname( $credentialsPath ), 0700, true );
            }
            // Save the $accessToken object to the credentials.json file for re-use
            file_put_contents( $credentialsPath, json_encode( $accessToken ) );
        }
        // Provide client with API access token
        $client->setAccessToken( $accessToken );
        // If the $accessToken is expired then we'll need to refresh it
        if ( $client->isAccessTokenExpired() ) {
            $client->fetchAccessTokenWithRefreshToken( $client->getRefreshToken() );
            file_put_contents( $credentialsPath, json_encode( $client->getAccessToken() ) );
        }
        return $client;
    }
    // Get the API client and construct the service object.
    $client = getClient();
    $service = new Google_Service_Sheets( $client );
    // Get values from a spreadheet and print
    // https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get
    $spreadsheetId = '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms';
    $range = 'Class Data!A2:E';
    $response = $service->spreadsheets_values->get($spreadsheetId, $range);
    $values = $response->getValues();
    if (empty($values)) {
        print "No data found.'n";
    } else {
        print "Name, Major:'n";
        foreach ($values as $row) {
            // Print columns A and E, which correspond to indices 0 and 4.
            printf("%s, %s'n", $row[0], $row[4]);
        }
    }

    function addTrailingSlash ($path)
    {
        return rtrim ($path, '/') . '/';
    }   
?>