将生成的csv从Laravel导入Google Sheets

composer require google/apiclient:^2.0

'google' => [
    'client_id' => env('GOOGLE_CLIENT_ID'),
    'client_secret' => env('GOOGLE_CLIENT_SECRET'),
    'redirect' => env('GOOGLE_REDIRECT_URI'),
    'service_account_credentials' => env('GOOGLE_SERVICE_ACCOUNT_CREDENTIALS'),
    'spreadsheet_id' => env('GOOGLE_SPREADSHEET_ID'),
],

GOOGLE_CLIENT_ID=YOUR_GOOGLE_CLIENT_ID
GOOGLE_CLIENT_SECRET=YOUR_GOOGLE_CLIENT_SECRET
GOOGLE_REDIRECT_URI=YOUR_GOOGLE_REDIRECT_URI
GOOGLE_SERVICE_ACCOUNT_CREDENTIALS=/path/to/service_account_credentials.json
GOOGLE_SPREADSHEET_ID=YOUR_GOOGLE_SPREADSHEET_ID

use Google_Client;
use Google_Service_Sheets;
use Google_Service_Sheets_ValueRange;

public function importCSVToGoogleSheets()
{
    $client = new Google_Client();
    $client->setAuthConfig(config('services.google.service_account_credentials'));
    $client->setScopes([Google_Service_Sheets::SPREADSHEETS]);
    $client->fetchAccessTokenWithAssertion();
    
    $service = new Google_Service_Sheets($client);
    $spreadsheetId = config('services.google.spreadsheet_id');
    
    // 读取CSV文件内容
    $csvFile = public_path('path/to/your/csv/file.csv');
    $csvData = file_get_contents($csvFile);
    $csvData = explode("\n", $csvData);
    
    $values = [];
    
    // 将CSV数据转换为Google Sheets的ValueRange格式
    foreach ($csvData as $row) {
        $values[] = explode(',', $row);
    }
    
    $body = new Google_Service_Sheets_ValueRange([
        'values' => $values
    ]);
    
    // 将CSV数据写入Google Sheets
    $range = 'Sheet1!A1';
    $options = [
        'valueInputOption' => 'RAW'
    ];
    
    $service->spreadsheets_values->update($spreadsheetId, $range, $body, $options);
    
    return "CSV文件已成功导入到Google Sheets！";
}