Flexible currency rate uploads for SAP B1 with AI validation & multiple sources
This workflow automates currency rate uploads into SAP Business One via Service Layer, using flexible input sources such as JSON (API), SQL Server, Google Sheets, or manual values. It leverages logic branching, AI validation, and logging for complete control and traceability. ++βοΈ HOW IT WORKS:++ πΉ 1. Receive Data via Webhook The workflow listens on the endpoint /formulario-datos via HTTP POST. The request body should include: origen: one of JSON, SQL, GoogleSheets, or Manual Depending on the va
At a glance
Flexible currency rate uploads for SAP B1 with AI validation & multiple sources is a ready-made n8n workflow you import as a workflow JSON file β no build required. It connects Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, OpenAI
- Modules
- 22
- Price
- Free
- Version
- v1.0

About this workflow
This workflow automates currency rate uploads into SAP Business One via Service Layer, using flexible input sources such as JSON (API), SQL Server, Google Sheets, or manual values. It leverages logic branching, AI validation, and logging for complete control and traceability. ++βοΈ HOW IT WORKS:++ πΉ 1. Receive Data via Webhook The workflow listens on the endpoint /formulario-datos via HTTP POST. The request body should include: origen: one of JSON, SQL, GoogleSheets, or Manual Depending on the value, the flow branches accordingly. πΉ 2. Authenticate with SAP Business One A POST request is sent to SAP B1βs Login endpoint. A session cookie (B1SESSION) is retrieved and used in all subsequent API calls. πΉ 3. Switch by Origin The flow branches into four processing paths based on origen: - JSON: The payload is normalized using OpenAI to extract an array of rates. Each rate is sent to SAP individually after parsing. - SQL: The SQL query provided in the payload is executed on a connected Microsoft SQL Server. The results are checked by AI to validate the date format. If valid, rates are sent to SAP. - GoogleSheets: Rates are pulled from a connected spreadsheet. Each entry is sent to SAP in sequence. - Manual: Uses currency, rate, and rateDate directly from the webhook payload. Sends the result directly to SAP. πΉ 4. AI-Powered Enhancements (Optional but enabled) - Normalize JSON: Uses OpenAI (LangChain node) to convert any messy structure into a uniform array under the key rate. - Date Formatting: Another OpenAI call ensures RateDate is in yyyyMMdd format (required by SAP), converting from ISO, timestamp, or other formats. πΉ 5. Send to SAP Business One (Service Layer) All paths send a POST request to: /SBOBobServiceSetCurrencyRate With a payload such as: { "Currency": "USD", "Rate": "0.92", "RateDate": "20250612" } πΉ 6. Log Results All success/failure results are appended to a Google Sheets log (LOGSN8N) The log includes method, URL, sent payload, status code, and message. ++π SETUP STEPS:++ 1οΈβ£ Create Required Credentials: Go to Credentials > + New Credential and configure: - SAP Business One (Service Layer) Type: HTTP Request Auth or Token Base URL: Provide Username, Password, and CompanyDB via variables or fields - Google Sheets OAuth2 connection to a Google account with access - Microsoft SQL Server SQL login credentials and host - OpenAI API key with access to models like GPT-4o 2οΈβ£ Environment Variables (Recommended) Set these variables in n8n β Settings β Variables: SAPURL= SAPUSER=yourusername SAPPASSWORD=yourpassword SAPCOMPANYDB=yourcompanyDB 3οΈβ£ Prepare Google Sheets - Sheet 1: RATE (for charging the data) Columns: Currency, Rate, RateDate - Sheet 2: LOGSN8N (to save the logs, success or failed) Columns: workflow, method, url, json, statuscode, message 4οΈβ£ Activate and Test Deploy the webhook and grab the URL. ++β BONUS++ - Built-in AI assistance for input validation and structure - Logs all results for compliance and audit - Flexible integration paths: perfect for hybrid or transitional systems
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n β click the menu β Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Payment processing and order tracking with YooKassa and Google Sheets
Manage WooCommerce store with natural language using GPT-4.1 and MCP server
Generate & auto-post social videos to multiple platforms with GPT-4 and Kling AI
Add Google Sheets rows for new affiliates in Tapfiliate
Create engaging Pinterest pins from Google Sheets data using ChatGPT
Save new Superfaktura invoices to a Google Sheets spreadsheet
π€ AI-powered prompt enhancement assistant using Google Sheets
Singapore university eligibility analyzer with GPT-4o-Mini, WordPress and Slack notifications
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint β instant download
- Setup guide PDF included
- 5 downloads Β· valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you