Build a white-space table of what key accounts haven't bought

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from collections import defaultdict
from clickruntime import on_trigger, credentials, http
SHEET_ID = "your-spreadsheet-id"
PRODUCTS = ["Core Platform", "Analytics", "Integrations", "Premium Support", "Training"]
INSTANCE = "https://yourcompany.my.salesforce.com"
API = f"{INSTANCE}/services/data/v61.0"

@on_trigger
def run(event):
    headers = {"Authorization": f"Bearer {credentials.connection('salesforce', 'work')}"}
    q = ("SELECT Opportunity.Account.Name, Opportunity.Account.Owner.Name, Product2.Name FROM OpportunityLineItem "
         "WHERE Opportunity.IsWon = true AND Opportunity.Account.Tier__c = 'Tier 1'")
    resp = http.get(f"{API}/query", headers=headers, params={"q": q}).json()
    owned, owners = defaultdict(set), {}
    for item in resp["records"]:
        account = item["Opportunity"]["Account"]
        owned[account["Name"]].add(item["Product2"]["Name"])
        owners[account["Name"]] = account["Owner"]["Name"]
    table = [["Account", "Owner"] + PRODUCTS + ["Gaps"]]
    for name in sorted(owned):
        marks = ["Yes" if p in owned[name] else "" for p in PRODUCTS]
        table.append([name, owners[name]] + marks + [marks.count("")])
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")),
                   cache_discovery=False).spreadsheets()
    sheets.values().clear(spreadsheetId=SHEET_ID, range="White space!A:Z").execute()
    sheets.values().update(spreadsheetId=SHEET_ID, range="White space!A1", valueInputOption="RAW",
                           body={"values": table}).execute()
    return {"accounts": len(table) - 1}