{"product_id":"microsoft-365-smtp-auth-finder-w-graph-openai-google-sheets","title":"Microsoft 365 SMTP AUTH Finder w\/ Graph, OpenAI \u0026 Google Sheets","description":"\u003ch3\u003eMicrosoft 365 SMTP AUTH Finder w\/ Graph, OpenAI \u0026amp; Google Sheets — Weekly risk detection for authenticated SMTP\u003c\/h3\u003e\n\u003cp\u003eAutomatically find Microsoft 365 accounts that are sending email via \u003cb\u003eSMTP AUTH (Basic auth)\u003c\/b\u003e, analyze the evidence with Microsoft Graph sign-in logs, generate an \u003cb\u003eOpenAI remediation plan\u003c\/b\u003e, and keep an always-updated inventory in \u003cb\u003eGoogle Sheets\u003c\/b\u003e—with a weekly status digest to \u003cb\u003eTelegram\u003c\/b\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns weekly\u003c\/b\u003e: scheduled for every Monday at 08:00 (or can be tested manually using built-in sample data).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePulls evidence from Microsoft Graph\u003c\/b\u003e:\n    \u003cul\u003e\n      \u003cli\u003eRetrieves the \u003cb\u003eMicrosoft Graph email app usage user detail report\u003c\/b\u003e (CSV).\u003c\/li\u003e\n      \u003cli\u003eRetrieves \u003cb\u003eEntra ID sign-in events\u003c\/b\u003e filtered to the “\u003cb\u003eAuthenticated SMTP\u003c\/b\u003e” client app.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCorrelates and scores accounts\u003c\/b\u003e: parses the usage report and aggregates sign-ins per account (counts, failures, last seen time, and sending IP addresses), then merges both sources into \u003cb\u003eone record per account\u003c\/b\u003e with a verdict (e.g., \u003cb\u003eBREAKS end of Dec 2026\u003c\/b\u003e, \u003cb\u003eCHECK\u003c\/b\u003e, or \u003cb\u003eNo SMTP use seen\u003c\/b\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates remediation guidance with OpenAI\u003c\/b\u003e for accounts that need action—returning a structured device guess, a single recommended fix path, short steps, and a risk rating.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpdates Google Sheets\u003c\/b\u003e: appends or updates all account rows with the latest findings and actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends a Telegram digest\u003c\/b\u003e: while any accounts need attention, it posts a weekly summary status.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators and IT teams hunting for legacy SMTP AUTH usage across Microsoft 365.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers validating risky email flows before enforcement deadlines.\u003c\/li\u003e\n  \u003cli\u003eSecurity teams correlating Entra sign-ins with email app usage and tracking remediation progress.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eMicrosoft Graph\u003c\/b\u003e: uses OAuth2 client credentials with application permissions \u003cb\u003eReports.Read.All\u003c\/b\u003e and \u003cb\u003eAuditLog.Read.All\u003c\/b\u003e, calling Graph HTTP requests for the CSV usage report and Entra sign-in events.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI\u003c\/b\u003e: invoked to produce a structured remediation plan for flagged accounts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e: stores and maintains the account inventory.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNodes\/logic used\u003c\/b\u003e: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003emerge\u003c\/b\u003e, \u003cb\u003etelegram\u003c\/b\u003e, plus supporting workflow steps.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326525526195,"sku":"N8N-21809","price":15.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Y0sHbWwk99KJGGPClf3IJ_uEsookmf.png?v=1793351596","url":"https:\/\/buyflowscripts.com\/products\/microsoft-365-smtp-auth-finder-w-graph-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}