Hi n8n Community! ![]()
Here is a ready-to-use n8n workflow designed to **automatically extract and structure accounting invoices, receipts, and quotes into clean JSON**.
###
What this workflow does:
1. Receives incoming invoice data (from Gmail or Webhooks).
2. Sends it to **DocToJSON API** (`https://91.98.169.170.sslip.io/v1/parse/text\`).
3. Returns deterministic JSON containing supplier name, dates, line items, and total amounts.
4. Outputs the structured data directly into Google Sheets or your CRM.
###
Setup Instructions:
1. Import the workflow JSON file attached below into your n8n instance.
2. Get an API key from [DocToJSON API](https://91.98.169.170.sslip.io/).
3. Set your `X-API-Key` header in the HTTP Request node.
Feel free to test it and share your feedback!
{
“name”: “DocToJSON - Extraire Factures Gmail vers Google Sheets”,
“nodes”: [
{
"parameters": {
"rule": {
"interval": \[
{
"field": "hours",
"hoursInterval": 1
}
\]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.1,
"position": \[
200,
300
\],
"id": "node-schedule-trigger",
"name": "1. Planificateur (Chaque Heure)"
},
{
"parameters": {
"method": "POST",
"url": "https://91.98.169.170.sslip.io/v1/parse/text",
"sendHeaders": true,
"headerParameters": {
"parameters": \[
{
"name": "X-API-Key",
"value": "VOTRE_CLE_API_DOCTOJSON"
},
{
"name": "Content-Type",
"value": "application/json"
}
\]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\\n \\"text\\": \\"Facture N°: INV-2026-101\\\\nFournisseur: Cloud Provider\\\\nMontant Total: 250.00 CAD\\\\nDate: 2026-08-23\\"\\n}",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 3,
"position": \[
450,
300
\],
"id": "node-doctojson-request",
"name": "2. Extraire Données Facture"
}
],
“connections”: {
"1. Planificateur (Chaque Heure)": {
"main": \[
\[
{
"node": "2. Extraire Données Facture",
"type": "main",
"index": 0
}
\]
\]
}
},
“settings”: {
"executionOrder": "v1"
}
}