from datetime import datetime, timezone def execute_send_summary_email(row, settings): '''Send summary email of overdue invoices to internal team''' overdue = row.get_field("overdue_invoices", []) spreadsheet_url = row.get_field("spreadsheet_url", "") overdue_count = row.get_field("overdue_count", 0) today = datetime.now(timezone.utc).strftime("%Y-%m-%d") total_amount = sum(inv.get("amount_due", 0) for inv in overdue) # Build HTML table of invoices table_rows = "" for inv in overdue: table_rows += ( f"" f"{inv.get('invoice_id', '')}" f"{inv.get('customer_name', '')}" f"{inv.get('currency', '')} {inv.get('amount_due', 0):.2f}" f"{inv.get('days_overdue', 0)} days" f"" ) body = ( f"

Overdue Invoices Report — {today}

" f"

There are {overdue_count} overdue invoices with a total outstanding amount of ${total_amount:,.2f}.

" f"

View full details in Google Sheets

" f"" f"" f"" f"" f"" f"" f"" f"{table_rows}" f"

Invoice ID	Customer	Amount	Days Overdue

" ) result = call_user_tool("__UTOOL_SLOT_gmail_GMAIL_SEND_EMAIL__", { "recipient_email": "kenobiwala@gmail.com", "subject": f"Overdue Invoices Report — {today}", "body": body, "is_html": True }) email_id = result.get("id", "") if isinstance(result, dict) else "" return {"email_status": "sent", "email_id": email_id, "summary": f"{overdue_count} overdue invoices totaling ${total_amount:,.2f}"}

Stripe Outstanding Invoices Email

Stripe Outstanding Invoices Email

Ready to Automate?