AutomationMart
Home/Browse/Automating SAP B1 journal entries using JSON, Google Sheets, and GPT-4o
n8n

Automating SAP B1 journal entries using JSON, Google Sheets, and GPT-4o

n8nn8n21 modulesv1.0
Google SheetsOpenAI

HOW IT WORKS: This workflow automates the creation of Journal Entries in SAP Business One (SAP B1). Depending on the source of the input data, it dynamically transforms and sends accounting records in the appropriate format using the Service Layer API. It supports three input types: - πŸ“¦ JSON payloads - πŸ“Š Google Sheets data - πŸ§‘β€πŸ’» Manual structured entries (via prompt + LLM) Each transaction is logged to Google Sheets for traceability. πŸ”Ή 1. Webhook Input Reception A Webhook node waits for a POST r

At a glance

Automating SAP B1 journal entries using JSON, Google Sheets, and GPT-4o 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
21
Price
Free
Version
v1.0
Automating SAP B1 journal entries using JSON, Google Sheets, and GPT-4o workflow diagram

About this workflow

HOW IT WORKS: This workflow automates the creation of Journal Entries in SAP Business One (SAP B1). Depending on the source of the input data, it dynamically transforms and sends accounting records in the appropriate format using the Service Layer API. It supports three input types: - πŸ“¦ JSON payloads - πŸ“Š Google Sheets data - πŸ§‘β€πŸ’» Manual structured entries (via prompt + LLM) Each transaction is logged to Google Sheets for traceability. πŸ”Ή 1. Webhook Input Reception A Webhook node waits for a POST request containing accounting data and metadata: The origen field determines the data source (JSON, GoogleSheets, or Manual) The sapurl, username, password, and companydb are used to connect to SAP B1 Payload can be a JSON list or tabular data (e.g., from Google Sheets) πŸ”Ή 2. SAP B1 Login Credentials are securely injected from the request body. A login request is sent to SAP B1's Service Layer to retrieve a valid session cookie (B1SESSION). πŸ”Ή 3. Dynamic Branching via Switch Node Depending on the value of origen, one of the following branches is activated: - JSON: Sends the JSON payload directly to SAP after restructuring - GoogleSheets: Loads rows, builds JSON, and merges context - Manual: Transforms data via OpenAI LLM prompt and generates SAP-compatible format πŸ”Ή 4. Data Transformation via LLM In Manual and GoogleSheets flows, the workflow uses an OpenAI node to: Parse line entries and convert them to JournalEntryLines[] Format the final JSON structure required by SAP LLM prompts are carefully crafted to return only clean JSON β€” no code blocks, comments, or explanations. πŸ”Ή 5. POST to SAP B1 Data is sent to {{SAPURL}}/JournalEntries using the Service Layer's POST method with the B1SESSION cookie attached. The body includes all JournalEntryLines. πŸ”Ή 6. Logging Success & Errors Each result (success or failure) is logged into a centralized Google Sheets log document: - βœ… Success: Includes HTTP status, source URL, and JSON payload - ❌ Failure: Logs the error code and message for review and traceability SETUP STEPS: 1. Create Required Credentials: - Google Sheets OAuth2 API (to log all responses and fetch data) - OpenAI API Key (used with the LangChain OpenAI node) - SAP Service Layer login data is passed securely via body parameters. 2. Use These Environment Variables (Recommended) or replace the data in the corresponding container: - SAPUSER, SAPPASSWORD, SAPCOMPANYDB - SAPURL 3. Prepare Google Sheets: - πŸ“„ Sheet 1: For source entries (e.g., for GoogleSheets origin) - 🧾 Sheet 2: For logging execution results Make sure the logging spreadsheet contains these columns: workflow, method, url, json, statuscode, message EXTRA NOTES: 🧠 Uses OpenAI GPT-4o for natural language transformation of accounting rows 🧩 Modular logic with error-handling for all branches πŸ“ Can be reused across multiple accounting integrations by changing the data source

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

Create Zoho Books vendors from a Google Sheets spreadsheet

Import your list of vendors from a Google Sheets spreadsheet and Make will automatically create a vendor contact in Zoho Books for each row. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1GP9tpQ-R8yKY0BM3Pgs-svt4C7vW0j0LcnqT-ZwumQ0/edit?ts=5e4f0895#gid=0).

Free

Create a link for a new file in Egnyte and share it with specified people from list stored in Google Sheets

When a new file is saved in Egnyte, Make checks which people should have access to the file in Google Sheets. [This template](https://docs.google.com/spreadsheets/d/1aLhpyhKiE9iTni4Op8UNiRY3NskTRw4EUtFefPLdMJQ/edit?usp=sharing) in Google Sheets was used. All the files must have the naming convention "nameOfTheProject_nameOfTheFile". After the list of filtered people is retrieved, the file links are created for the people and the links are sent to their e-mails. The generated password is then se

Free

Filter breaking geopolitical news with AI scoring & Telegram alerts

Geopolitics Breaking News Alert System Workflow Name: Geopolitics Breaking News Alert System Author: Devjothi Dutta Category: Productivity, News & Media, AI/Machine Learning Complexity: Medium Setup Time: 45-60 minutes --- --- πŸ“– Description An intelligent geopolitical monitoring system that filters 200+ daily news articles down to only the critical breaking news that matters to you. This workflow uses smart keyword filtering and

Free

Add rows to Google Sheets from Netlify form submissions

Every time a new Netlify form is submitted, Make will automatically add a new row to a Google Sheet. This example uses [this sheet](https://docs.google.com/spreadsheets/d/1KGDXEcM2tkplGyzDfJJ16G_pYkSXPNawnnNcjN7kWl0/edit#gid=0).

Free

Automate lead generation with Apollo, AI scoring and Brevo email outreach

AI Scoring, Personalized Email Creation and Outreach Overview This comprehensive automation flow helps you scale your outreach to potential customers through intelligent personalized email campaigns. The system combines web scraping, AI-powered lead scoring, and automated email sequences to maximize your conversion rates. Key Features - Intelligent Website Analysis with automated scraping - AI-Powered Lead Scoring for prioritization - Personalized Email Generation using AI - Automated Email Outr

Free

AI-Powered RAG Document Processing & Chatbot with Google Drive, Supabase, OpenAI

Who is this for? This workflow is perfect for: Businesses and teams who need an automated solution to organize, analyze, and retrieve insights from their internal documents. Researchers who want to quickly analyze and query large collections of research papers, reports, or datasets. Customer support teams looking to streamline access to product documentation and support resources. Legal and compliance professionals needing to reference and query legal documents with confidence.

Free

Evaluate AI workflows using Google Sheets, Gemini, Claude, GPT, and Perplexity

This template and YouTube video goes over 5 different implementations of evaluations within n8n. - Categorization - Correctness - Tools used - String similarity - Helpfulness You’ll learn when to use each type, how to set up test datasets in Google Sheets or data tables, and how to track your results over time. I also explain best practices like only changing one variable at a time, documenting your prompts and model settings, and building proper training datasets with enough examples to confi

Free

Automate social media content with AI for Instagram, Facebook, LinkedIn & X

AI Social Media Content Automation – n8n Workflow This workflow is built for creators, solopreneurs, SaaS founders, and agencies looking to automate their social media content process from idea to publication. It combines the power of OpenAI, Google Sheets, and official APIs for Instagram, Facebook, X (Twitter), and LinkedIn to deliver fully automated, brand-consistent social media posts β€” including text, images, hashtags, CTAs, and scheduling. No more switching tools, rewriting content, or forg

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