Ambriel KYB Risk Scoring in Google Sheets (n8n) + Drive

Automate Ambriel KYB Risk Scoring for Every Company in Your Google Sheet—Then Store the Reports in Google Drive

This n8n workflow reads your company list from Google Sheets, runs an Ambriel KYB assessment for each registration number, writes the KYB score and risk level back to the same rows, and downloads the generated report to upload into a Google Drive folder—on a monthly schedule you control.

What this workflow does

• Runs on a schedule (monthly by default) to keep your KYB risk scoring up to date.
• Reads all company rows from your chosen Google Sheets spreadsheet and tab.
• Processes each row one at a time, sending the company’s registration number to Ambriel to run a KYB assessment and force report generation.
• Updates the same row with the returned KYB score and risk level.
• Requests the Ambriel report download link and proceeds only when the report is successfully available.
• Downloads the report via HTTP and uploads it to a specified Google Drive folder.

Use cases

• Monthly KYB monitoring: automatically reassess company risk and keep your scoring fields current in Google Sheets.
• Compliance reporting workflows: generate Ambriel KYB reports and archive them in Google Drive for audit-ready documentation.
• SaaS back-office automation: centralize KYB scoring updates by writing results back to the same sheet row using a unique row_number column.

Technical details

• n8n scheduler: runs once every month (adjustable interval).
• Google Sheets: reads company records and updates KYB score/risk fields by row number.
• Ambriel integration: sends company registration numbers to compute KYB risk and generate the report.
• HTTP Request: downloads the report file from the Ambriel-provided link.
• Google Drive: uploads the downloaded report to your destination folder.
• Workflow components include: if, Ambriel, sticky note, google drive, http request, and google sheets.

Setup note: connect Ambriel API credentials, confirm the workflow’s country code and registration number field mapping, configure Google Sheets (spreadsheet ID + tab), and set the Google Drive destination folder.