n8n worklflow automation

Currently reading
n8n worklflow automation

2,486
840
NAS
Synology, TrueNAS
Operating system
  1. Linux
  2. Windows
today I played with n8n workflow automation:

It's a nice tool and still meets my expectations in the area I was planning to use it. If it helps you, I am attaching a functional compose (I will tune final secure version):
YAML:
version: '3.1'

services:
  n8n:
    image: n8nio/n8n
    restart: always
    volumes:
       - ./n8n:/home/node/
    ports:
      - <port>:5678
    environment:
      DB_TYPE: mysqldb
      DB_MYSQLDB_DATABASE: <scheme name>
      DB_MYSQLDB_HOST: <host>
      DB_MYSQLDB_PORT: <db port>
      DB_MYSQLDB_USER: <scheme user>
      DB_MYSQLDB_PASSWORD: <scheme psw>
      N8N_BASIC_AUTH_ACTIVE: "true"
      N8N_BASIC_AUTH_USER: <up to you>
# this is system user. You will be prompted to create App user, when sys will run
      N8N_BASIC_AUTH_PASSWORD: <up to you>
    command: /bin/sh -c "n8n start"


It contains everything necessary, including ENV for the type of security levels (system usr/psw).
System is running as expected and first workflows were tested. Useful tool.

At the end:
  • this is deployment with external MySQL DB
  • you can use simple version based on SQLite, but … I like more control about the environment
  • there is also possible use Maria and Postgres … more here
enjoy
 
@jeyare - V interesting. Would love to have more details on what your intended end use for this will be 👍
 
one project needs to check a new registration entry (google drive sheet source)
read data from the sheet
send the data to invoice channel
read data about payment finishing
create certification based on the registration, create log
send the certification, create log
Several similar tasks ahead

well documented:
-- post merged: --

well this is what I’m thinking about:

 
Thanks :cool:
Where are you running the n8n tool? On a local machine / syno / docker or in the cloud / VPS etc??
 
Hey there! Thanks for sharing your experience with n8n workflow automation. I'm new to this forum and was just browsing through some threads when I stumbled upon this one. It's great to hear that n8n met your expectations and that you were able to use it for your project.
 
Last edited by a moderator:
Hey,

I also want to automate a process for my client's website.

The process he is looking for is something like this:
When a Reddit post is published, then a new user with the same username is created, and after that Reddit post data gets saved to a Google sheet, and from that Google sheet chat gpt will be linked and the data will be rewritten with a special prompt. After that, the data will again saved to a new sheet, and from that Google sheet, the new data will be published in a forum.

So this automation possible with N8N or do I have to choose zappier or Pabbly?

If possible, can you guide some?
 

Create an account or login to comment

You must be a member in order to leave a comment

Create account

Create an account on our community. It's easy!

Log in

Already have an account? Log in here.

Welcome to SynoForum.com!

SynoForum.com is an unofficial Synology forum for NAS owners and enthusiasts.

Registration is free, easy and fast!

Back
Top