Find prospects' emails and send a personal intro each day

import base64
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai

SHEET_ID, DAILY = "your-spreadsheet-id", 20

def send(to, subject, body):
    raw = f"To: {to}\r\nSubject: {subject}\r\nContent-Type: text/plain; charset=utf-8\r\n\r\n{body}"
    build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).users() \
        .messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(raw.encode()).decode()}).execute()

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")),
                   cache_discovery=False).spreadsheets().values()
    rows = sheets.get(spreadsheetId=SHEET_ID, range="Prospects!A2:D").execute().get("values", [])
    queue = [(i + 2, r) for i, r in enumerate(rows) if len(r) == 3][:DAILY]
    for n, (first, last, domain) in queue:
        f = http.get("https://api.hunter.io/v2/email-finder", params={"domain": domain, "first_name": first, "last_name": last,
                     "api_key": credentials.secret("HUNTER_API_KEY")}).json().get("data") or {}
        if f.get("email"):
            body = ai.generate(f"Write a 60-word intro email to {first}, {f.get('position') or 'a leader'} at {domain}, from a "
                               "studio that builds Shopify stores. Specific, friendly, one question. No subject line.",
                               max_output_tokens=180).text.strip()
            send(f["email"], f"Quick question for {first}", body)
        sheets.update(spreadsheetId=SHEET_ID, range=f"Prospects!D{n}", valueInputOption="RAW",
                      body={"values": [["Sent " + event.get("scheduled_time", "")[:10] if f.get("email") else "Not found"]]}).execute()
    return {"processed": len(queue)}