Evaluate KYB risk scores from Google Sheets with Ambriel and save reports to Google Drive
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs on a schedule (every month). Along the way it connects Google Sheets, Google Drive and CUSTOM (community).
How it runs
Trigger: On a schedule (every month).
- Read from Google Sheet (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Assess a company (Ambriel): assess
- Update row in sheet (Google Sheets): update
- Edit Fields (Edit Fields (Set)): sets or maps fields
- Get an assessment report (Ambriel): get report
- If: checks a condition and branches into true / false
- Download Report File (HTTP Request): calls an HTTP API
- Wait: pauses before continuing
- Upload to Google Drive (Google Drive): uses Google Drive
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that CUSTOM is verified or supports 3.0 (used in Assess a company, Get an assessment report).
- Also check Always Output Data on multi-output nodes (If/Switch) now adds an empty item only when every output is empty.
Nodes used (9)
- Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Ambriel
CUSTOM.ambriel - Wait
n8n-nodes-base.wait - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview This workflow runs monthly (choose your own schedule schedule) to read company records from Google Sheets, evaluate each company’s KYB risk using Ambriel, writes the resulting score and risk level back to the sheet, and downloads the generated…