Verify French suppliers before payment with Google Sheets, Sirenic, and Slack

Quick Overview

This workflow monitors a Google Sheets payment list for new French suppliers, verifies each supplier’s SIREN (and optional IBAN) with Sirenic’s French Pack checks, then logs approved suppliers back to Google Sheets or posts a detailed block alert to a Slack channel.

How it works

1. Triggers every minute when a new row is added to a specified Google Sheets worksheet.
2. Sends the row’s SIREN and optional IBAN to Sirenic (French Pack) to validate company and invoicing-related registry signals.
3. Checks Sirenic’s verdict field (pret_a_facturer) to determine whether the supplier is ready to invoice.
4. If approved, appends a “ready to invoice” entry (including supplier name, timestamp, and VIES VAT status) to a Google Sheets verification log.
5. If blocked, posts a Slack message to the chosen channel with the supplier details and the closed-list reasons returned by Sirenic (plus VAT/VIES and IBAN/bank hints when available).

Setup

1. Self-host n8n, install the n8n-nodes-sirenic community node, and create Sirenic credentials.
2. Add Google Sheets credentials and select the source sheet (trigger) and the destination sheet (verification log) by setting the document and sheet values in both Google Sheets nodes.
3. Add Slack credentials and choose the target channel for blocked-supplier alerts in the Slack node.
4. Ensure your source sheet includes a SIREN column and optionally an IBAN column that matches the field names used in the Sirenic step.