Как получить примечания (Notes) из Google Sheet, используя Python?

Question

[Emil Revencu]

Значения ячеек я получаю вот так:

import httplib2
import apiclient.discovery
from oauth2client.service_account import ServiceAccountCredentials

CREDENTIALS_FILE = 'credentials.json'
credentials = ServiceAccountCredentials.from_json_keyfile_name(CREDENTIALS_FILE, ['https://www.googleapis.com/auth/spreadsheets', 'https://www.googleapis.com/auth/drive'])
httpAuth = credentials.authorize(httplib2.Http())
SHEETS = apiclient.discovery.build('sheets', 'v4', http = httpAuth)
SHEET_ID = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
result = SHEETS.spreadsheets().values().batchGet(spreadsheetId=SHEET_ID, ranges='Sheet1!A:F').execute()
print result

А как получить примечания (notes) ячеек?

Answer 1

[Alexander Ivanov]

from googleapiclient.discovery import build
service = build('sheets', 'v4')

response = service.spreadsheets().get(spreadsheetId = spreadsheetId,
    fields = 'sheets(data.rowData.values.note)').execute()

print(response)

Запустить код "здесь и сейчас" можно по ссылке https://colab.research.google.com/drive/1dbUChgxPF...