test.py

import json
from google.oauth2 import service_account
import pygsheets

GOOGLESHEETS_CREDENTIALS = json.dumps({"type": "service_account","project_id": "spendstracker-457904","private_key_id": "91bb3866226ab9f6734aa3fcc861faf17897d79d","private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCy2v9irZ+/f+hF\nGUW/ikqnQUGMTapLulH3I6+vdDoQBtFa3tNc5BcK991Qbbk8NG2Iv6Ni7H/dY4jv\nWlBr//WTcThKSa23HzjztDxFtCbw5BsaNcXzt3HlAb/ldZNjZkt8CJdzLDpDuiLc\n9PbJEUxNZZYZcGrY7rhse1Z5QCn/gX1GlTCqMORPoEcrCmjklabjht4le9SoUaCA\n9qABNt8SXaTPw1l4HxxxtMEQE466COxWn89lEDh+DqDjU+oXVwXUFscDUSrKtDFt\nNNjIy0yMlKTtLwtMaHMK6DdT+hqAjs4xaOFF2YQFDPLuXAX1PaLEi7J/ircese1s\nlQAcxrThAgMBAAECggEAAIvnQl2t8oeZRdbHLgfl5P9vzBYzqkISPItVHtff0os2\nygyKwEqpIF00BaokKgEuAYA2Z1e6J0rF0RdpTf8s+KucpKt3dqsHgUUgdwUPJmbI\nB2s5JN6/YBgChli239Og8OrUzaMJtYnE0ACGnYQqQ8VG8WJ0zR9jnF8/GyU9S5zQ\nGlUO04y6ftetQCaFaVIxxy9B/pOtSuIZi4qoJjGuOebMAcYWusrAWID3uewhsZJW\nqCQUMLyADK5ujEAybo7dpohph6YYwV/6bmCl/8rfnBiXn8NsuFfE9m/B7W9TBXku\n0AB/EF8rnjI2kEMXgUogLUj1DBm4pkVEpce+vd2LzQKBgQD7UJg35cLFCcjylumP\n/5f7d4V25ryWpfHMYSs9zefkRDnVrmwumanHy+IOSLgOMUC5dIcJOjQPutaUnKN5\nH4oW2q4K6Pmp4vlDeTNp9bHaZMokuQPVhMZvsWWcpFe3v6nMHA3tvshiWKiPVApo\nHaaXeNETateCpwGBn+9Eu5VAtQKBgQC2MJbQ/85DndSnk3YZ+aEtp2fEJABJwfPl\nM6vRnKy5gHKMPk1BZLb+B4osr+OA6eZEzp6VL2kOpI+lIZ9E20uMWOOzZUk+du6i\nEpXimHSoNPS56pksfS3tWoHRuyM9nm+rPEV0LPWotyenEfhtGE1CYZwnef1aMNfW\nKhui8uH6/QKBgQCLvoMGAhLNseU1T8lMMxn10L48IY2YT2om9Zkv4sEhYvat5TFu\nsC+CU9K9kp4V9jlBZpR4Aw9T99a+CGO2RF1q2+qPUoERgI6OgGSgdOiSwhzNUrvZ\nDN2y2ffgpFnKaR8nyinMm5udZCNGn7qxrlsmOx43J9/yXJ8vzxkjJROXSQKBgGsW\n4G91DU7dZPQjT1YxTzZAolO+PZUdNjlRR/trtnNLNwmMTWjUxGNJF0TxFi7eTYXA\nVaKnPX9n5y9PNgkJRbz3OtBmBsl6qwYFGqkYp+l/RyJI7UQjSG2tt4UKFMrRaB4k\nzUZebv9+uQYRIA8wK6mLKnhh0jPDZfrywU/kqEQZAoGAbywkV/FjFeAhmqY/yLQo\nho3E5T5jEc45kDadsK2OHVnCRb0tWh6VTdr93XQ9z5mygub7Wu16jp/FnHtA7f+E\no743SU8sYHxPGbVavlM/iRzbzhaF8o5lTHqqzLqrPvMOBbUpP/cRXugoxt7m7o4v\nvcRikUgNG7O8ipxnN28L8dg=\n-----END PRIVATE KEY-----\n","client_email": "spendstracker@spendstracker-457904.iam.gserviceaccount.com","client_id": "117285083911847446748","auth_uri": "https://accounts.google.com/o/oauth2/auth","token_uri": "https://oauth2.googleapis.com/token","auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs","client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/spendstracker%40spendstracker-457904.iam.gserviceaccount.com","universe_domain": "googleapis.com"})
sheet_url = "https://docs.google.com/spreadsheets/d/1t4bOM4fULdaVsjDDnqEG1g8Zey6M00UuFhTZC03_4xo/edit?gid=0#gid=0"

SCOPES = ('https://www.googleapis.com/auth/spreadsheets', 'https://www.googleapis.com/auth/drive')
service_account_info = json.loads(GOOGLESHEETS_CREDENTIALS)
my_credentials = service_account.Credentials.from_service_account_info(service_account_info, scopes=SCOPES)
client = pygsheets.authorize(custom_credentials=my_credentials)

print("Writing transaction message to Google Sheets...")
worksheet = client.open_by_url(sheet_url)

print(worksheet)