# Vendor risk assessment via form: AI analysis and report in Google Sheets
This workflow automates vendor due diligence — from web form intake to structured reporting in Google Sheets. Uses AI to assess reputation, financial stability, cybersecurity posture, and regulatory compliance. Designed for security, compliance, and risk management teams.
## Who it´s for
- Information security specialists conducting vendor due diligence
- Procurement and risk managers in IT companies
- Compliance analysts evaluating vendor regulatory alignment
- GRC (Governance, Risk, Compliance) teams in mid-to-large organizations
## What the automation does
- Receives vendor details (name, data type, industry) via web form
- Triggers Google Gemini to research company background and classify risks
- Extracts URLs from responses and fetches content via Jina AI
- Analyzes web pages (official site, trust center, reviews) and summarizes findings
- Aggregates results into a comprehensive risk score across domains
- Exports structured data to Google Sheets and returns a summary to the user
## What´s included
- Ready-to-use n8n workflow with LangChain and Python logic
- Trigger handling (form_submit via HTTP webhook)
- Integrations with Google Gemini, Jina AI, and Google Sheets
- Basic text guide for setup and adaptation
## Requirements for setup
- n8n instance with Python and external API access enabled
- Google Gemini API key
- Jina AI API key
- Google account with Google Sheets editing permissions
## Benefits and outcomes
- Reduces due diligence time from hours to minutes
- Eliminates subjectivity with standardized AI-driven analysis
- Centralizes results in Google Sheets for audit and tracking
- Enables scalable assessment of multiple vendors
- Supports decision-making for SaaS and third-party vendor selection
- Automatically documents sources and conclusions
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet