Online Reputation Report n8n Workflow: SearchAPI + GPT-4o + Outlook

Generate an Online Reputation Report with SearchAPI + GPT-4o, then email it via Microsoft Outlook

This n8n workflow automatically researches an attorney, law firm, or local business’s online presence, summarizes findings with an OpenAI GPT-4o agent, scores visibility and review signals, and sends a formatted HTML reputation report through Microsoft Outlook—either on demand (webhook) or on a daily schedule (SharePoint).

What this workflow does

• Triggers from either:
  • a POST webhook for a single subject, or
  • a daily schedule that pulls active, due clients from a Microsoft SharePoint list using Microsoft Graph.
• Validates and normalizes inputs (e.g., name, firm, category, location, domains to check, competitors, recipients). Webhook requests are rejected if the requestor email or subject name is missing.
• Builds search queries including results from Google, Bing, Google News, and Google Images, plus optional site-specific queries.
• Fetches SERP results from SearchAPI.io and aggregates visibility/platform presence signals and extracted review indicators into a single analysis payload.
• Summarizes with GPT-4o to generate a structured JSON reputation report, with validation and a minimal fallback report if the JSON is invalid.
• Emails an HTML report to the requestor (optional CC) using Microsoft Outlook.
• When run from SharePoint, updates the list item with the latest report date and score, then proceeds through the client batch.

Use cases

• Attorney marketing teams needing consistent online reputation monitoring.
• Law firms generating visibility and review-focused updates for locations or practice areas.
• Automation engineers deploying an online reputation report pipeline in n8n for recurring outreach and internal dashboards.

Technical details

• n8n workflow nodes/logic: if, set, code, no op, merge, webhook
• Search: SearchAPI.io SERP endpoint (Google, Bing, Google News, Google Images; optional site queries)
• AI analysis: OpenAI GPT-4o (structured JSON → HTML email formatting)
• Email delivery: Microsoft Outlook
• Batch scheduling: Microsoft SharePoint via Microsoft Graph (daily runs)