README.md

google-sheet

Update Google Sheet

Steps

1. In Intellj IDE, ./gradlew build
2. In Intellj IDE, ./gradlew run

Table

Sample Sheet

More

1. Credential.json added in gradlew

2. Main: SheetsQuickstart.java

3. 调用 SDK 的代码

service.spreadsheets().values()
                    .update(spreadsheetId, range, body)
                    .setValueInputOption(valueInputOption)
                    .execute();
                    
service.spreadsheets().values()
                    .append(spreadsheetId, range, body2)
                    .setValueInputOption(valueInputOption)
                    .execute();