Verify French suppliers before payment with Google Sheets, Sirenic, and Slack
Go to Workflow
Sirenic
Description
Quick overview
This workflow watches a Google Sheets payment list for new French suppliers, checks each SIREN (and optional IBAN) with the Sirenic French Pack, then logs approved suppliers or alerts Slack.
How it works
Triggers every minute when a row is added to the source worksheet.
Sends the SIREN and optional IBAN to the Sirenic French Pack: legal identity, VAT number checked live against VIES, IBAN and bank.
Reads the verdict field (pret_a_facturer): is the supplier ready to invoice?
If yes, appends a "ready to invoice" entry (supplier name, timestamp, VIES VAT status) to a Google Sheets verification log.
If not, posts the supplier to Slack with the closed-list reasons returned by Sirenic, plus VAT and IBAN hints when available.
Setup
Self-host n8n, install the n8n-nodes-sirenic community node and create Sirenic credentials.
Add Google Sheets credentials, then set the document and sheet in both Google Sheets nodes (source and verification log).
Add Slack credentials and choose the channel for blocked suppliers.
Give the source sheet a SIREN column and, optionally, an IBAN column, named as in the Sirenic step.
Additional info
What the check catches and what it cannot, step by step: verify a supplier before payment: identity, VAT, IBAN.
This workflow was created by Sirenic and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.