import gspread
from google.oauth2 import service_account
S = ['https://www.googleapis.com/auth/spreadsheets','https://www.googleapis.com/auth/drive']
c = service_account.Credentials.from_service_account_file('/workspace/.secrets/gsa_safronov.json', scopes=S)
sh = gspread.authorize(c).open_by_key('1WhRdain7yiMVrI9yACjkpOMaJ5LPRQjbB6IYfV6INhQ')
ws = sh.worksheet("Посты")
ws.update(values=[["опубликован t.me/safronov_ads/360"]], range_name="D6")
print(ws.get('A6:D6'))