Automate Anything on your PC for free, using Local LLM’s and open-soure no-code tools

Sjoerd Tiemensma
7 min readJan 19, 2024

Summarize emails, batch process anything, extract information or generate knowledge graphs and score your diary entries, all on your PC at home by using open-source models and automation software, a comprehensive guide with the automations pre-built. You don’t have to write a single line of code.

By the way, if you found this interesting and would like to learn more, discuss potential projects, or just connect, feel free to reach out to me on LinkedIn.

  • Connect to me on LinkedIn
  • Check out my Webshop here
  • Any clap/follow for this article helps me out!

The shift to local solutions

In January of last year, I set up an automation in Zapier to summarize my incoming emails into Google Sheets using GPT-3, so that I could have a neat overview of my incoming emails and easily find things. This was fun to set up, but I couldn’t just send all of my e-mails to OpenAI. After testing that it worked on a small subset of spam I received, I shut it down for that reason.

Over the past year, the world of open-source AI hasn’t been sitting still and I felt it was time to revisit this — but do it better by running everything locally, from my PC at home. Keep all the data to myself, and show that we can build useful things without having to send our own data over to some of the big tech companies.

--

--