Java实现Google Sheets服务账户无弹窗授权问题求助

你遇到的IllegalArgumentException是因为误用了OAuth2授权码流程的代码（即官方Quickstart里的GoogleAuthorizationCodeFlow），而ServiceAccount属于服务到服务的无交互授权，二者实现逻辑完全不同。以下是Java版的正确实现方案：

核心思路 #

ServiceAccount通过私钥直接生成凭证，无需用户登录弹窗，只需将服务账号邮箱共享到目标Google Sheet即可获得访问权限。

Java实现代码 #

1. 依赖配置（Maven） #

<dependencies>
    <dependency>
        <groupId>com.google.api-client</groupId>
        <artifactId>google-api-client</artifactId>
        <version>2.0.0</version>
    </dependency>
    <dependency>
        <groupId>com.google.oauth-client</groupId>
        <artifactId>google-oauth-client-java6</artifactId>
        <version>1.34.1</version>
    </dependency>
    <dependency>
        <groupId>com.google.apis</groupId>
        <artifactId>google-api-services-sheets</artifactId>
        <version>v4-rev20240512-2.0.0</version>
    </dependency>
</dependencies>

2. 授权与服务初始化代码 #

import com.google.api.client.googleapis.javanet.GoogleNetHttpTransport;
import com.google.api.client.json.gson.GsonFactory;
import com.google.api.services.sheets.v4.Sheets;
import com.google.api.services.sheets.v4.SheetsScopes;
import com.google.auth.http.HttpCredentialsAdapter;
import com.google.auth.oauth2.GoogleCredentials;

import java.io.FileInputStream;
import java.util.Collections;

public class SheetsServiceAccountExample {
    private static final String APPLICATION_NAME = "Sheets Service Account Demo";
    // 替换为你的ServiceAccount密钥文件路径
    private static final String SERVICE_ACCOUNT_KEY_PATH = "/path/to/your/service-account-key.json";
    // 所需权限范围
    private static final String[] SCOPES = {SheetsScopes.SPREADSHEETS, SheetsScopes.DRIVE};

    public static void main(String[] args) throws Exception {
        // 加载ServiceAccount凭证
        GoogleCredentials credentials = GoogleCredentials.fromStream(new FileInputStream(SERVICE_ACCOUNT_KEY_PATH))
                .createScoped(Collections.singletonList(SheetsScopes.SPREADSHEETS));

        // 构建Sheets服务
        Sheets sheetsService = new Sheets.Builder(GoogleNetHttpTransport.newTrustedTransport(),
                GsonFactory.getDefaultInstance(), new HttpCredentialsAdapter(credentials))
                .setApplicationName(APPLICATION_NAME)
                .build();

        // 后续即可用sheetsService调用Sheets API，比如读取数据
        // String spreadsheetId = "你的表格ID";
        // String range = "Sheet1!A1:B5";
        // ValueRange response = sheetsService.spreadsheets().values().get(spreadsheetId, range).execute();
    }
}

关键注意事项 #

• 必须将ServiceAccount的client_email（即test@mytestproject-2.iam.gserviceaccount.com）共享到目标Google Sheet，赋予编辑/查看权限，否则会返回权限错误。
• 确保密钥文件路径正确，且程序有读取该文件的权限。

内容的提问来源于stack exchange，提问作者Vladislava Soboleva