AutomationMart
Home/Browse/Flexible currency rate uploads for SAP B1 with AI validation & multiple sources
n8n

Flexible currency rate uploads for SAP B1 with AI validation & multiple sources

n8nn8n22 modulesv1.0
Google SheetsOpenAI

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
Flexible currency rate uploads for SAP B1 with AI validation & multiple sources workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n β†’ click the menu β†’ Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Accept YooKassa payments and log transactions in Google Sheets 🧾 Summary This workflow allows you to accept online payments via YooKassa and log both orders and transactions in Google Sheets β€” all without writing a single line of code. It supports full payment flow: product selection, payment initiation, webhook processing, refund updates, and payment status checks. --- πŸ‘₯ Who is this for? This template is ideal for: Online stores with simple checkout flows Sellers of digital products or info-c

Free

Manage WooCommerce store with natural language using GPT-4.1 and MCP server

WooCommerce AI Agent β€” n8n Workflow (Overview) Description: Turn your WooCommerce store into a conversational AI assistant β€” create products, place orders, run reports and manage coupons using natural language via n8n + an MCP Server. Key features - Natural-language commands mapped to WooCommerce actions (products, orders, reports, coupons). - Structured JSON outputs + lightweight mapping to avoid schema errors. - Calls routed through your MCP Server for secure, auditable tool execution. - Mi

Free

Generate & auto-post social videos to multiple platforms with GPT-4 and Kling AI

AI-Powered Social Video Generator with Auto-Posting to Instagram, TikTok, YouTube, Facebook, LinkedIn, Threads, Pinterest, Twitter (X), and Bluesky Who is this workflow for? This workflow is ideal for content creators, marketers, social media managers, and automation enthusiasts who want to generate, customize, and publish short-form videos across multiple platforms without manual editing or posting.

Free

Add Google Sheets rows for new affiliates in Tapfiliate

Every time a new affiliate appears in your Tapfiliate, Make will add a row with information on them. Make sure your sheet has got the same fields as this (one)[https://docs.google.com/spreadsheets/d/1pdGqo0GrGwR4gV32x-bgRdK4IR_PHaI40Irdo3UOUG8/edit?usp=sharing].

Free

Create engaging Pinterest pins from Google Sheets data using ChatGPT

Automatically transform Google Sheets data into engaging Pinterest pins using ChatGPT then update your spreadsheet with the pin details.

Free

Save new Superfaktura invoices to a Google Sheets spreadsheet

Every time a new invoice is created in Superfaktura, Make will automatically add a new row to your Google Sheets spreadsheet.

Free

πŸ€– AI-powered prompt enhancement assistant using Google Sheets

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Introduction Tired of spending time crafting the perfect AI prompt? This workflow takes your simple ideas like "write a blog post" and automatically transforms them into detailed, structured prompts that actually work. 🎯 What This Does Automatically converts simple user prompts like "write a blog post" into structured, professional AI prompts with metadata, variables, and clear instructions. Perf

Free

Singapore university eligibility analyzer with GPT-4o-Mini, WordPress and Slack notifications

Introduction Automates scholarship tracking by scraping university sites, assessing eligibility via AI, and publishing results to WordPress or Slack. Eliminates manual searches for students, counselors, and education platforms, enabling scalable curation and timely notifications. How it Works Webhook triggers parallel scraping of NUS, NTU, SIT, SUTD β†’ merge data β†’ AI evaluates eligibility β†’ aggregate qualified scholarships β†’ generate summaries β†’ post to WordPress/Slack β†’ send email notifi

Free

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.

Log in to review
Free
No ratings yet

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.

β‚Ή2,499/ session
3 hrs Β· video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free