Git backup of workflows and credentials
Published 3 years ago
Created by
Allan Daemon
Categories
Template description
This creates a git backup of the workflows and credentials.
It uses the n8n export command with git diff, so you can run as many times as you want, but only when there are changes they will create a commit.
Setup
You need some access to the server.
Create a repository in some remote place to host your project, like Github, Gitlab, or your favorite private repo.
Clone the repository in the server in a place that the n8n has access. In the example, it's the ., and the repository name is repo. Change it in the commands and in the workflow commands (you can set it as a variable in the wokflow). Checkout to another branch if you won't use the master one.
cd .
git clone repository
Or you could git init and then add the remote (git remote add origin YOUR_REPO_URL), whatever pleases you more.
As the server, check if everything is ok for beeing able to commit. Very likely you'll need to setup the user email and name. Try to create a commit, and push it to upstream, and everything you need (like config a user to comit) will appear in way. I strong suggest testing with exporting the commands to garantee it will work too.
cd ./repo
git commit -c "Initial commmit" --allow-empty
-u is the same as --set-upstream
git push -u origin master
Testing to push to upstream with the first exported data
npx n8n export:workflow --backup --output ./repo/workflows/
npx n8n export:credentials --backup --output repo/credentials/
cd ./repo
git add .
git commit -c "manual backup: first export"
git push
After that, if everything is ok, the workflow should work just fine.
Adjustments
Adjust the path in used in the workflow. See the the git -C PATH command is the same as cd PATH; git ....
Also, adjust the cron to run as you need. As I said in the beginning, you can run it even for every minute, but it will create commits only when there are changes.
Credentials encryption
The default for exporting the credentials is to do them encrypted. You can add the flag --decrypted to the n8n export:credentials command if you need to save them in plain. But as general rule, it's better to save the encryption key, that you only need to do that once, and them export it safely encrypted.
Share Template
More Engineering workflow templates
Creating an API endpoint
Task:
Create a simple API endpoint using the Webhook and Respond to Webhook nodes
Why:
You can prototype or replace a backend process with a single workflow
Main use cases:
Replace backend logic with a workflow
Jonathan
Joining different datasets
Task:
Merge two datasets into one based on matching rules
Why:
A powerful capability of n8n is to easily branch out the workflow in order to process different datasets. Even more powerful is the ability to join them back together with SQL-like joining logic.
Main use cases:
Appending data sets
Keep only new items
Keep only existing items
Jonathan
+11
Back Up Your n8n Workflows To Github
This workflow will backup your workflows to Github. It uses the public api to export all of the workflow data using the n8n node.
It then loops over the data checks in Github to see if a file exists that uses the workflow name. Once checked it will then update the file on Github if it exists, Create a new file if it doesn't exist and if it's the same it will ignore the file.
Config Options
repo_owner - Github owner
repo_name - Github repository name
repo_path - Path within the Github repository
>This workflow has been updated to use the n8n node and the code node so requires at least version 0.198.0 of n8n
Jonathan
More DevOps workflow templates
+4
Host your own Uptime Monitoring with Scheduled Triggers
This n8n workflow demonstrates how to build a simple uptime monitoring service using scheduled triggers.
Useful for webmasters with a handful of sites who want a cost-effective solution without the need for all the bells and whistles.
How it works
Scheduled trigger reads a list of website urls in a Google Sheet every 5 minutes
Each website url is checked using the HTTP node which determines if the website is either in the UP or DOWN state.
An email and Slack message are sent for websites which are in the DOWN state.
The Google Sheet is updated with the website's state and a log created.
Logs can be used to determine total % of UP and DOWN time over a period.
Requirements
Google Sheet for storing websites to monitor and their states
Gmail for email alerts
Slack for channel alerts
Customising the workflow
Don't use Google Sheets? This can easily be exchanged with Excel or Airtable.
Jimleuk
+10
π¦ Get a bird's-eye view of your n8n instance with the Workflow Dashboard!
Using n8n a lot?
Soar above the limitations of the default n8n dashboard! This template gives you an overview of your workflows, nodes, and tags β all in one place. πͺ
Built using XML stylesheets and the Bootstrap 5 library, this workflow is self-contained and does not depend on any third-party software. π It generates a comprehensive overview JSON that can be easily integrated with other BI tools for further analysis and visualization. π
Reach out to Eduard if you need help adapting this workflow to your specific use-case!
π Benefits:
Workflow Summary** π: Instant overview of your workflows, active counts, and triggers.
Left-Side Panel** π: Quick access to all your workflows, nodes, and tags for seamless navigation.
Workflow Details** π¬: Deep dive into each workflow's nodes, timestamps, and tags.
Node Analysis** π§©: Identify the most frequently used nodes across your workflows.
Tag Organization** ποΈ: Workflows are grouped according to their tags.
Visually Stunning** π¨: Clean, intuitive, and easy-to-navigate dashboard design.
XML & Bootstrap 5** π οΈ: Built using XML stylesheets and Bootstrap 5, ensuring a self-contained and responsive dashboard.
No Dependencies** π: The workflow does not rely on any third-party software. Bootstrap 5 files are loaded via CDN but can be delivered directly from your server.
β οΈ Important note for cloud users
Since the cloud version doesn't support environmental variables, please make the following changes:
get-nodes-via-jmespath node. Update the instance_url variable: enter your n8n URL instead of {{$env["N8N_PROTOCOL"]}}://{{$env["N8N_HOST"]}}
Create HTML node. Please provide the n8n instance URL instead of {{ $env.WEBHOOK_URL }}
πExample:
Check out our other workflows:
n8n.io/creators/eduard
n8n.io/creators/yulia
Eduard
+2
Streamline data from an n8n form into Google Sheet, Airtable and Email Sending
Streamline data from an n8n form into Google Sheet Airtable and and Email Sending
Video for workflow process
This workflow facilitates efficient data collection and management by leveraging the capabilities of various nodes within the n8n platform. It commences with the n8n Form Trigger node, where users provide their name, location, and email address. Subsequently, the data seamlessly flows through nodes like Google Sheets, Code, Set, Airtable, Gmail, and Gmail1 for processing and storage.
n8n Form Trigger:** Gathers user input data, including Name, City, and Email.
Google Sheets:** Manages data operations related to Google Sheets.
Code:** Executes JavaScript code to manipulate data fields.
Set:** Formats and sets data values for further processing.
Airtable:** Facilitates data operations specific to Airtable.
Gmail:** Sends custom emails to the provided Email address.
Gmail:** Sends additional emails using different templates.
Each node within the workflow performs specialized tasks such as extracting date and time fields, formatting data, appending it to Google Sheets and Airtable, and sending personalized emails to the submitter. This streamlined process ensures effective handling of collected information and enhances overall data management efficiency.
Workflow Description:
n8n Form Trigger:
A trigger node that initiates the workflow upon form submission.
Captures essential user details like Name, City, and Email.
Extracting Date and Time Fields from 'submittedAt' Field:
Utilizes a code node to extract Date and Time information from the submitted data.
Format the Fields:
Standardizes the format of extracted fields (Name, City, Date, Time, Email) for consistency.
Airtable:
Creates a new record in Airtable with the formatted data.
Includes columns for Name, City, Email, Time, and Date.
Google Sheets:
Appends the formatted data to a designated Google Sheet.
Includes columns for Name, City, Email, Date, and Time.
Gmail:
Sends an email to the provided Email address with a customized message.
Subject: "Testing Text Message Delivery"
Message: Personalized content with a Name placeholder.
Gmail1:
Sends another email using a different template.
Subject incorporates the Date field for variation.
Message content tailored to the subject line.
Workflow Connections:
n8n Form Trigger -> Extracting Date and Time Fields -> Format the Fields -> Google Sheets & Airtable -> Gmail
Google Sheets -> Gmail1
This comprehensive workflow efficiently collects user data, processes it to extract Date and Time fields, stores the formatted information in Google Sheets and Airtable, and delivers tailored emails to the recipients.
Copy these templates to get started :
Google Sheet
Airtable
Links to Node Documentation:
n8n Form Trigger Documentation
Code Node Documentation
Set Node Documentation
Airtable Node Documentation
Google Sheets Node Documentation
Gmail Node Documentation
AlQaisi
