Tools Development and AI Projects

I watched and tried out HTML, CSS and JS but never dedicated my time to master these in the past. Then I met a few guys, who were hobby automating their work.

That was my first A-HA moment. This is what I want to learn. I dedicated my time, thosands of hours to automate processes with Autohotkey. Check out my Linkedin Group for some demo videos, articles and posts about my automation projects.

Then a year ago everything changed.

Personal Website Development

I started to create tools, websites and I am using HTML, CSS, Javascript, php and Python. I created my own interactive CV website and many more.

Added there all the needed analytics, some functionalities with php; managed .htacess commands, created sitemaps, robots.txt and so on.

Made an email sending functionality with php. Added an AI search bar on the top of the homepage to have visitors enter their questions about me and receive answers without reading through my website.

Marketing Agency Website

Then I started to make a showcase website for an fictional marketing agency, I also added the AI search bar.

I styled that one and made it responsive and interactive.

Later on, created a minimalistic server side analytic tool and the database to see my own data by myself without any 3rd party filtering in and out visitors.

I learnt that I can email myself any search queries entered to the AI search bar so I can see what people are interested about. Try out all the features.

Product Translation Tool

Download the tool for Product Translation in zip folder and .exe file. In addition there is a system prompt, which serve the AI agent for better outlining the process and the output file.

Google Search Console Indexation API GUI made with python

You need to make an API authentication with downloadable JSON verification file, because this is the key for running the script.

Download the GUI here.
It will prompts a suspicious file warning. I can't help it, just go ahead and save it into a dedicated folder and to start it just double click on the .exe file. Save the JSON authentication file to the same directory.

After starting the .exe file, you will see the GUI menu, where you upload the JSON file and press the Authentication button. Follow up the next steps in your browser despite the warnings and continue the process till you receive the successful authentication message. Once you did it, you can select from the dropdown the website, which Indexation you want to obtain. After that you provide the sitemap or the urls list and set the limit for the urls. Finally set the excel file where the result will be saved.

After you started the .exe file, the informative messages will guide you through the process to successfully fetch all the indexation data for the given website.

Google Search Console Indexation API GUI made with python

You need to make an API authentication with downloadable JSON verification file, because this is the key for running the script.

Download the GUI here.
It will prompts a suspicious file warning. I can't help it, just go ahead and save it into a dedicated folder and to start it just double click on the .exe file. Save the JSON authentication file to the same directory.

After starting the .exe file, you will see the GUI menu, where you upload the JSON file and press the Authentication button. Follow up the next steps in your browser despite the warnings and continue the process till you receive the successful authentication message. Once you did it, you can select from the dropdown the website, which Indexation you want to obtain. After that you provide the sitemap or the urls list and set the limit for the urls. Finally set the excel file where the result will be saved.

After you started the .exe file, the informative messages will guide you through the process to successfully fetch all the indexation data for the given website.

AI Integration Projects - Gave voice to my AI tool

This AI topic made me excited.

I use 2 AI tools. One locally to test out capabilities and the other one for daily work and also to power my tools.

None of the AI tools can hear and translate my prompts and definitely not say them. So I prompted AI to write with Python a code to be able to hear me and read the answer out loud. Then I learnt that I can clone my voice and use it to read the answers.

It cost some money but my daughter was shocked when she heard it. My wife was not so shocked, but impressed.

Check out how the version works without inbuilt voice agent:

Product Advisor Tool

Then I made a tool with AI, which scraped a segment from the website of my wife's employer and downloaded the products onto a JSON file and could ask AI any complex question about the products.

My wife is working in sales and creating offers takes time. With this script she could save time as AI has all the data and answers queries like best prices, light colour product with the fastest availability.. And the answer comes instantly.

Check it out how it works:

Image SEO Automation Tool

Another day in 13 different prompt versions I tried out python's OCR, llava image recognition feature and my favorite AI tool's capabilities to write a GUI to upload image urls in an excel file and next to the urls add SEO alt text. The record processing speed is 2 seconds per image url and generates pretty descriptive texts for the images.

Check it out how it works:

Automation Tools Summary

But from the many dozens of tools I created, the most useful are for monitoring competition, scraping web content and even automating repetitive cursor moves, windows changing and string modification. These tools are sometimes not beautiful, but do the work I need. I started to create many more tools to replace 3rd party vendors and to save the monthly fees.