Send your outreach only to verified addresses

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

SHEET_ID = "your-spreadsheet-id"

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="Outreach!A2:E").execute().get("values", [])
    ready = [(i + 2, r) for i, r in enumerate(rows) if len(r) == 4]
    skipped = []
    for n, (name, email, subject, body) in ready:
        v = http.get("https://api.hunter.io/v2/email-verifier", params={"email": email,
                     "api_key": credentials.secret("HUNTER_API_KEY")}).json().get("data") or {}
        ok = v.get("status") == "valid"
        send(email, subject, body.replace("{name}", name)) if ok else skipped.append(f"{email}: {v.get('status', 'unknown')}")
        sheets.update(spreadsheetId=SHEET_ID, range=f"Outreach!E{n}", valueInputOption="RAW",
                      body={"values": [["Sent" if ok else f"Skipped ({v.get('status')})"]]}).execute()
    sent = len(ready) - len(skipped)
    if ready:
        notify.email_me(f"Outreach: {sent} sent, {len(skipped)} skipped", "\n".join(skipped) or "All addresses valid.")
    return {"sent": sent, "skipped": len(skipped)}