The flow
Starts it 1Model 5Logic 9Service 6
The steps in the order they run, from what starts it.
- 1Structured Output ParserOutput Parser StructuredModel
- 2Intake formForm triggerStarts it
- 3Gemini - Risk AssessmentLm Chat Google GeminiModel
- 4Gemini - Link SummarizerLm Chat Google GeminiModel
- 5Summarize Web ContentAgentModel
- 6Build Research PromptsSetLogic
- 7Calculate Risk ScoreInformation ExtractorModel
- 8Merge Content DataAggregateLogic
- 9Research Company BackgroundHttp RequestService
- 10Format Assessment ResultsCodeLogic
- 11Sanatize URL DataCodeLogic
- 12Delay1: 1 secondWaitLogic
- 13Export to Google SheetGoogle SheetsService
- 14Determine Vendor ClassificationHttp RequestService
- 15Display Assessment SummaryFormService
- 16Delay2: 1 secondWaitLogic
- 17Answer risk questionsHttp RequestService
- 18Extract Reference URLsCodeLogic
- 19Validate URL ExtractionIfLogic
- 20Fetch Web ContentJina AiService
- 21Handle No URLs FoundSetLogic
How it's built
- Starts on
- Someone submitting a form
- Steps
- 21, with 1 branch, 2 loops or waits
- Size
- Large: read it before trusting it with anything live
- Connects to
- Google Sheets
- Model
- Gemini
Questions
What does it need to run?
An n8n account, plus your own Google Sheets account, and a key for Gemini. You connect your own accounts after importing it; none are included.
What starts it?
It starts on someone submitting a form.
Does it use AI?
Yes. It calls Gemini. Model calls are billed by the provider, not by n8n.
How long does it take to set up?
Take your time. At 21 steps it is large: read it before trusting it with anything live.
How do I import it?
Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.
Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 21 steps before you point it at anything that matters.