{"product_id":"ambriel-kyb-risk-scoring-in-google-sheets-n8n-drive","title":"Ambriel KYB Risk Scoring in Google Sheets (n8n) + Drive","description":"\u003ch3\u003eAutomate Ambriel KYB Risk Scoring for Every Company in Your Google Sheet—Then Store the Reports in Google Drive\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule (monthly by default)\u003c\/strong\u003e to keep your KYB risk scoring up to date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all company rows\u003c\/strong\u003e from your chosen Google Sheets spreadsheet and tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses each row one at a time\u003c\/strong\u003e, sending the company’s registration number to Ambriel to \u003cem\u003erun a KYB assessment\u003c\/em\u003e and \u003cem\u003eforce report generation\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the same row\u003c\/strong\u003e with the returned \u003cstrong\u003eKYB score\u003c\/strong\u003e and \u003cstrong\u003erisk level\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequests the Ambriel report download link\u003c\/strong\u003e and proceeds only when the report is successfully available.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the report via HTTP\u003c\/strong\u003e and \u003cstrong\u003euploads it to a specified Google Drive folder\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonthly KYB monitoring:\u003c\/strong\u003e automatically reassess company risk and keep your scoring fields current in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompliance reporting workflows:\u003c\/strong\u003e generate Ambriel KYB reports and archive them in Google Drive for audit-ready documentation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS back-office automation:\u003c\/strong\u003e centralize KYB scoring updates by writing results back to the same sheet row using a \u003cstrong\u003eunique row_number\u003c\/strong\u003e column.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n scheduler:\u003c\/strong\u003e runs once every month (adjustable interval).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e reads company records and updates KYB score\/risk fields by row number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAmbriel integration:\u003c\/strong\u003e sends company registration numbers to compute KYB risk and generate the report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request:\u003c\/strong\u003e downloads the report file from the Ambriel-provided link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive:\u003c\/strong\u003e uploads the downloaded report to your destination folder.\u003c\/li\u003e\n  \u003cli\u003eWorkflow components include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eAmbriel\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003egoogle drive\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, and \u003cstrong\u003egoogle sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45742783758515,"sku":"N8N-17626","price":18.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/6W2yDbxswfOUKXFdsA7w4_UR8Z1Fr5.png?v=1785402533","url":"https:\/\/buyflowscripts.com\/products\/ambriel-kyb-risk-scoring-in-google-sheets-n8n-drive","provider":"N8N Commerce","version":"1.0","type":"link"}