Supplier register: Kbis and certificates with expiry
Suppliers send their Kbis extract or vigilance certificate. The AI reads the document type, company, registration number and issue date, a validity end date is computed (6 months), and your suppliers table is updated (columns: company, siren, document, issued_on, expires_on). Filter this table by expiry to chase renewals in time.
- By
- Loop & Roll team · Official
- Copied
- 0 times
- Steps
- 5
- Version
- 1 · 18 October 2026
- Requires
- Loop & Roll 1.0.0 or later
Workflow graph
How it works
-
1
Certificate received
trigger.email -
2
Read the document
attachment.extract_text -
3
Identify the document
ai.extract -
4
Compute the expiry date
date.compute -
5
Update the register
table.upsert
What you will fill in after import
Nothing personal travels with a template: connections, mailboxes, tables and recipients are left blank for you to pick in your instance.
- Tables to choose
- Update the register · table
- Connections to choose
- OpenAI · connection (llm_provider)
See also
More in Data extraction
- Data extraction Official Turn website form emails into Airtable CRM leads Contact-form notifications from your website are parsed: name, company, email, phone, request type and message are extracted and a lead reco... Airtable OpenAI
- Data extraction Official Add hotel and travel bookings to Google Calendar Booking confirmations (hotel, train, flight, rental car) are read by the AI, which extracts the title, start and end date-time, place and co... Google Calendar OpenAI
- Data extraction Official Track tender and RFP announcements with their deadlines Tender alerts, RFPs and consultation notices received by email are read by the AI: buyer, subject, reference, estimated value if stated, sub... Google Sheets OpenAI