vendor-verification

par google-gemini

Vérifier si les vendeurs/commerçants issus des relevés de dépenses sont des entités commerciales réelles et enregistrées en interrogeant l'API ouverte gratuite Wikidata.

npx skills add https://github.com/google-gemini/gemini-managed-agents-templates --skill vendor-verification

Télécharger ZIP GitHub

Vendor Verification

Verify whether merchants or vendors from expense records are real, registered business entities by querying the free, open Wikidata API (no key required). This skill helps identify potentially fraudulent or unverified merchants.

Embedded Script

python3 skills/vendor-verification/scripts/verify_vendors.py --workspace .agents/workspace

Arguments

Argument	Default	Description
`--workspace`	`.agents/workspace`	Workspace directory containing expenses.csv or reconciliation_data.json

What it does

Loads expense records from .agents/workspace/reconciliation_data.json (if available from a prior reconciliation run) or directly from .agents/workspace/expenses.csv.
Identifies all unique vendor/merchant names.
For each unique merchant, queries the free Wikidata Entity Search API: https://www.wikidata.org/w/api.php?action=wbsearchentities&search={merchant_name}&language=en&format=json
Analyzes the search results:
- Verified: If a matching entity exists on Wikidata. Extracts the description (e.g. “American multinational technology company”) and entity ID (e.g., Q95).
- Unverified: If no match is found on Wikidata.
Generates .agents/workspace/vendor_verification_report.md with:
- Verification summary statistics.
- A detailed status table for all unique vendors.
- Flagged unverified vendors requiring secondary research.
Generates .agents/workspace/vendor_verification_data.json containing the structured JSON results.

Licensing & Usage

This skill queries Wikidata, which is licensed under Creative Commons CC0 1.0 Universal Public Domain Dedication.
It is 100% free of charge, requires no API token/key, has no commercial restrictions, and requires no attribution.

Output

File	Path	Description
Verification Report	`.agents/workspace/vendor_verification_report.md`	Human-readable markdown report listing verified and unverified merchants with official descriptions.
Verification Data	`.agents/workspace/vendor_verification_data.json`	Structured JSON containing merchant verification statuses, descriptions, and Wikidata entity URIs.