Skip to content

Latest commit

 

History

History
71 lines (45 loc) · 1.55 KB

README.md

File metadata and controls

71 lines (45 loc) · 1.55 KB
Raw

n8n Workflow Manager

A simple web page to ON and OFF n8n Workflow using webhook Trigger.

n8n-workflow-manager

Usage

  • PHP for API
  • n8n webhook GET for trigger the workflow
  • n8n API for GET the workflow status (IS ACTIVE OR INACTIVE)
  • MYSQL PDO database for ON and OFF conditon validation
  • Bulma CSS Framework

Setup

  • Create a database setup table and connect it with api
  • add the webhook URL and database credentials in .env File
  • Done
ACTIVATE=https://n8n.example.com/webhook/xxxxxxxxxxxxxxxxxXXXXXX
DEACTIVATE=https://n8n.example.com/webhook/xxxxxxxxxxxxxxxXXXXXX

DBHOST=YOURDBHOST
DBNAME=YOURDBNAME
DBUSERNAME=YOURDBUSERNAME
DBPASSWORD=YOURDBPASSWORD

APIURL=https://n8n.example.com/api/v1/workflows/<WOKRFLOW ID>
APIKEY=n8n_api_XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

CREATE TABLE `n8n` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user` varchar(500) NOT NULL,
  `status` varchar(500) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user` (`user`),
  UNIQUE KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Still it's on ⚠ WIP if you have any ideas your PR's are Welcome 😊

Note: Don't use this on Production server or any other online platforms use it locally and manage it via localhost server

# Localhost server using PHP

php -S localhost:5001
  • Now open your browser with the following URL
http://localhost:5001

LICENSE

MIT