Last week I automated much of the back office work for a small design studio in less than 8hrs and I am still mind-blown about it.
n8n is a game-changer and should be known by all SMBs and even enterprise companies.
Back to Integrations
Integrate Execute Command with 500+ apps and services
Unlock Execute Command’s full potential with n8n, connecting it to similar Development apps and over 1000 other services. Automate productivity workflows by scheduling tasks, managing project timelines, and tracking progress across platforms. Create adaptable and scalable workflows between Execute Command and your stack. All within a building experience you will love.
Popular ways to use Execute Command integration
Git backup of workflows and credentials
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.
Allan Daemon
N8N Español - Tratamiento de textos
Este workflow es para trabajar con tratamiento de texto usando n8n y poder iniciarte en como funciona.
How To, Paso a Paso: https://comunidad-n8n.com/tratamiento-de-textos/
Comunidad de telegram: https://t.me/comunidadn8n
The { AI } rtist
Report phishing websites to Steam and CloudFlare
Webhook to report through Mailgun phishing websites to Steam and CloudFlare (if the domain is on CloudFlare)
You have to set the Credentials for webhook and Mailgun.
You have to set the email from for Mailgun.
This assumes it is running in n8n's Docker image where bind-tools is not readily available but installable.
chaufnet
N8N Español - Bot Multi Idioma NoCode
Tutorial: https://comunidad-n8n.com/bot-multi-idioma-no-code/
Comunidad de telegram: https://t.me/comunidadn8n
BOT: https://t.me/NocodeTranslateBot
The { AI } rtist
+8
Scrape and store data from multiple website pages
This workflow allows extracting data from multiple pages website.
The workflow:
1) Starts in a country list at https://www.theswiftcodes.com/browse-by-country/.
2) Loads every country page (https://www.theswiftcodes.com/albania/)
3) Paginates every page in the country page.
4) Extracts data from the country page.
5) Saves data to MongoDB.
6) Paginates through all pages in all countries.
It uses getWorkflowStaticData('global') method to recover the next page (saved from the previous page), and it goes ahead with all the pages.
There is a first section where the countries list is recovered and extracted.
Later, I try to read if a local cache page is available and I recover the cached page from the disk.
Finally, I save data to MongoDB, and we paginate all the pages in the country and for all the countries.
I have applied a cache system to save a visited page to n8n local disk. If I relaunch workflow, we check if a cache file exists to discard non-required requests to the webpage.
If the data present in the website changes, you can apply a Cron node to check the website once per week.
Finally, before inserting data in MongoDB, the best way to avoid duplicates is to check that swift_code (the primary value of the collection) doesn't exist.
I recommend using a proxy for all requests to avoid IP blocks. A good solution for proxy plus IP rotation is scrapoxy.io.
This workflow is perfect for small data requirements. If you need to scrape dynamic data, you can use a Headless browser or any other service.
If you want to scrape huge lists of URIs, I recommend using Scrapy + Scrapoxy.
Miquel Colomer
Load More Workflows
Documents
Execute Command Node Docs + Examples
Over 3000 companies switch to n8n every single week
Connect Execute Command with your company’s tech stack and create automation workflows
Cris
aaron
@acar321
in other news I installed @n8n_io tonight and holy moly it’s good
it’s compatible with EVERYTHING
qupaya technologies
@qupaya
We're using the @n8n_io cloud for our internal automation tasks since the beta started. It's awesome! Also, support is super fast and always helpful. 🤗
