Append to Spreadsheet

append_to_spreadsheet.dart

final _credentials = new ServiceAccountCredentials.fromJson(r'''
{
  "private_key_id": "***",
  "private_key": "***",
  "client_email": "***",
  "client_id": "***",
  "type": "***"
}
''');

const _SCOPES = const [SheetsApi.SpreadsheetsScope];

clientViaServiceAccount(_credentials, _SCOPES).then((httpClient) {
      var sheetsApi = new SheetsApi(httpClient);
      sheetsApi.spreadsheets.values.append(
        ValueRange.fromJson({"values": [["QR", "Авангард",  "цвет формы", "#игрока", "фамилия игрока"]]}), 
        "<spreadsheet_id", 
        "A1:Z998",
        valueInputOption: "USER_ENTERED").then((response){
          print('it works!');
      });
    });