Sync currency rates to SAP B1 from JSON, SQL, Google Sh

This workflow automates the transfer of up-to-date currency exchange rates into SAP Business One from multiple sources: JSON, SQL queries, Google Sheets, or manual entry. Data is normalized using OpenAI for consistent date formatting and logged in Google Sheets for audit purposes. Designed for finance professionals and ERP integrators needing reliable, multi-source synchronization.

## Who it´s for
- Finance specialists working with SAP B1 and external data sources
- ERP system integrators requiring automated currency rate sync
- Accounting departments using diverse data sources for current rates

## What the automation does
- Receives data via HTTP webhook from various sources (JSON, SQL, Google Sheets, manual input)
- Processes JSON payloads using OpenAI for cleaning and structuring
- Executes SQL queries against Microsoft SQL Server, limiting results to 10 rows
- Reads new rates from Google Sheets
- Normalizes date format to yyyyMMdd using GPT
- Sends processed data to SAP Business One
- Logs successes and errors in Google Sheets for audit tracking

## What´s included
- Ready-to-use n8n workflow
- Trigger and conditional logic handling
- Integrations with n8n, OpenAI API, Google Sheets API, Microsoft SQL, and HTTP API
- Basic text guide for setup and adaptation

## Requirements for setup
- n8n account with workflow import capability
- OpenAI API key
- Google account with edit access to target sheet
- Microsoft SQL Server connection details
- SAP Business One API access credentials

## Benefits and outcomes
- Saves time on manual currency rate entry
- Reduces risk of data processing errors
- Ensures consistent date formatting across systems
- Centralized operation logging for audits
- Supports multiple input sources in one workflow
- Flexible input method selection

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.