Generate online reputation reports with SearchAPI, GPT-4o, SharePoint and Outlook
Needs changesWhat this workflow does
This AI workflow has 22 nodes and runs on a schedule (every day at 06:00) (plus 1 other trigger). Along the way it connects OpenAI Chat Model and Microsoft Outlook. It also calls graph.microsoft.com and searchapi.io over HTTP.
How it runs
Trigger: On a schedule (every day at 06:00) (plus 1 other trigger).
- Retrieve Client List (HTTP Request): calls graph.microsoft.com
- Normalize Requestor Details (Edit Fields (Set)): sets 20 fields: requestorEmail, requestorName, subjectName…
- Map and Filter Clients (Code): runs custom JavaScript code
- Check If Email Provided (If): checks a condition and branches into true / false
- Batch Process Each Client (Loop Over Items (Split in Batches)): loops over the items in batches
- Send Acceptance Response (Respond to Webhook): sends the response back to the webhook caller
- Send Error if Missing Email (Respond to Webhook): sends the response back to the webhook caller
- Compile Search Queries (Code): runs custom JavaScript code
- Acquire SearchAPI Results (HTTP Request): calls searchapi.io
- Merge: merges the data from its input branches
…plus 8 more steps. See the full node list below.
Services it uses
HTTP calls to: graph.microsoft.com, searchapi.io
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Reputation Report AI Agent (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Reputation Report AI Agent (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (13)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - No Operation, do nothing
n8n-nodes-base.noOp - Microsoft Outlook
n8n-nodes-base.microsoftOutlook
From the author
Quick overview This workflow generates an online reputation report for an attorney, law firm, or local business by querying SearchAPI.io, summarizing and scoring the results with an OpenAI GPT-4o agent, and emailing a formatted HTML report via Microsoft…