Turn order rows in a sheet into Stripe invoices

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
import stripe
from clickruntime import on_trigger, credentials, report_fetched

SHEET_ID = "your-sheet-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Orders!A2:G").execute().get("values", [])
    todo = [(i + 2, r) for i, r in enumerate(rows) if len(r) >= 6 and (len(r) < 7 or not r[6])]
    report_fetched(len(todo))
    if not todo:
        return {"invoiced": 0}
    stripe.api_key = credentials.secret("STRIPE_API_KEY")
    for row_no, (email, company, item, qty, price, currency, *_) in todo:
        found = stripe.Customer.list(email=email, limit=1).data
        customer = found[0] if found else stripe.Customer.create(email=email, name=company)
        inv = stripe.Invoice.create(customer=customer.id, collection_method="send_invoice", days_until_due=30, currency=currency.lower())
        stripe.InvoiceItem.create(customer=customer.id, invoice=inv.id, description=item, quantity=int(qty),
                                  unit_amount=round(float(price) * 100), currency=currency.lower())
        inv = stripe.Invoice.finalize_invoice(inv.id)
        sheets.values().update(spreadsheetId=SHEET_ID, range=f"Orders!G{row_no}", valueInputOption="RAW",
                               body={"values": [[inv.hosted_invoice_url]]}).execute()
    return {"invoiced": len(todo)}