Python Workflows

Client Initialization

Use this helper function from the AutoKitteh Python SDK:

from autokitteh.google import google_sheets_client

sheets = google_sheets_client("autokitteh_connection_name")

This helper function is documented here: https://autokitteh.readthedocs.io/en/latest/#autokitteh.google.google_sheets_client

The code above uses the AutoKitteh connection's authentication details automatically, and is equivalent to this code snippet

from google.auth.transport.requests import Request
import google.oauth2.credentials as credentials
import google.oauth2.service_account as service_account
from googleapiclient.discovery import build

scopes = [...]

if json_key:
    info = json.loads(json_key)
    creds = service_account.Credentials.from_service_account_info(info, scopes=scopes)
else:
    creds = credentials.Credentials.from_authorized_user_info(...)
    if creds.expired:
        creds.refresh(Request())

sheets = build("sheets", "v4", credentials=creds)

API Reference

Python: https://developers.google.com/resources/api-libraries/documentation/sheets/v4/python/latest/sheets_v4.spreadsheets.html

Code samples:

• https://github.com/autokitteh/kittehub/tree/main/samples/google/sheets
• https://github.com/googleworkspace/python-samples/tree/main/sheets

Overview: https://developers.google.com/sheets/api/guides/concepts

REST: https://developers.google.com/sheets/api/reference/rest