spreadsheet_logging.py

#!/usr/bin/python
# -*- coding: utf-8 -*-
import os.path
from googleapiclient.discovery import build
from google_auth_oauthlib.flow import InstalledAppFlow
from google.oauth2 import service_account
from google.auth.transport.requests import Request

SCOPES = ['https://www.googleapis.com/auth/spreadsheets']


def logToSpreadsheet(spreadsheet_id, spreadsheet_range, entry):
    creds = service_account.Credentials.from_service_account_file(
        'service_account.json',
        scopes=SCOPES
    )
    service = build('sheets', 'v4', credentials=creds, cache_discovery=False)

    sheet = service.spreadsheets()
    result = sheet.values().get(
        spreadsheetId=spreadsheet_id,
        range=spreadsheet_range
    ).execute()
    list = [entry]

    resource = {'majorDimension': 'ROWS', 'values': list}

    sheet.values().append(
        spreadsheetId=spreadsheet_id,
        range=spreadsheet_range,
        body=resource,
        valueInputOption='USER_ENTERED').execute()