Automate SAP B1 Journal Entries via JSON, Sheets & GPT-4o

This workflow streamlines the creation of Journal Entries in SAP Business One (SAP B1) by accepting inputs from multiple sources: JSON payloads, Google Sheets data, or manual structured entries via LLM prompts. It begins with a webhook receiving POST requests containing data and SAP credentials, followed by secure login to retrieve a session cookie. A switch node then branches based on the 'origen' field to handle each input type appropriately.

For JSON inputs, it restructures and sends directly to SAP. Google Sheets data is loaded, merged with context, and transformed via OpenAI GPT-4o into SAP-compatible JSON. Manual entries use LLM prompts to parse and format lines into JournalEntryLines arrays, ensuring clean JSON output without extras. All paths culminate in a POST to the SAP Service Layer /JournalEntries endpoint, with transactions logged to Google Sheets for audit trails.

Benefits include reduced manual data entry errors, flexible multi-source integration, and time savings for accounting teams. Use cases span finance automation, reconciling sheet-based records with ERP, or ad-hoc journal creation via chat-like inputs, ideal for SMBs leveraging SAP B1.