使用Java将数据写入Google Sheets

import com.google.api.client.googleapis.auth.oauth2.GoogleCredential;
import com.google.api.client.googleapis.javanet.GoogleNetHttpTransport;
import com.google.api.client.http.HttpTransport;
import com.google.api.client.json.JsonFactory;
import com.google.api.client.json.jackson2.JacksonFactory;
import com.google.api.services.sheets.v4.Sheets;
import com.google.api.services.sheets.v4.model.*;

import java.io.IOException;
import java.security.GeneralSecurityException;
import java.util.Arrays;
import java.util.List;

public class GoogleSheetsWriter {

    private static final String APPLICATION_NAME = "Google Sheets Writer";
    private static final String SPREADSHEET_ID = "your-spreadsheet-id";
    private static final String RANGE = "Sheet1!A1:B2";

    public static void main(String[] args) throws GeneralSecurityException, IOException {
        HttpTransport httpTransport = GoogleNetHttpTransport.newTrustedTransport();
        JsonFactory jsonFactory = JacksonFactory.getDefaultInstance();

        GoogleCredential credential = GoogleCredential.fromStream(
                GoogleSheetsWriter.class.getResourceAsStream("/path/to/your-service-account-key.json"))
                .createScoped(Arrays.asList("https://www.googleapis.com/auth/spreadsheets"));

        Sheets sheetsService = new Sheets.Builder(httpTransport, jsonFactory, credential)
                .setApplicationName(APPLICATION_NAME)
                .build();

        List<List<Object>> data = Arrays.asList(
                Arrays.asList("Name", "Age"),
                Arrays.asList("John Doe", 30),
                Arrays.asList("Jane Smith", 25)
        );

        ValueRange valueRange = new ValueRange().setValues(data);
        UpdateValuesResponse response = sheetsService.spreadsheets().values()
                .update(SPREADSHEET_ID, RANGE, valueRange)
                .setValueInputOption("RAW")
                .execute();

        System.out.println("Data written to Google Sheets.");
    }
}