How to fix “openai.error.RateLimitError: The server had an error”
If you’re a regular user of the OpenAI GPT API, you might have recently faced a very annoying issue, causing your Python script to fail 👇 There’s no rational reason explaining this “RateLimitError” (except of course if you’re actually flooding the OpenAI server with tons of requests). The error is probably caused by the intense […]
How to export all your blog posts as a CSV using Python and SQLite.
A friend asked me if I could help him export all of his blog posts in a CSV format as he was considering migrating his content to another platform. The example in this article explains how to export content created on Bloggi.co but you can apply the same basic principles to any blogging platform accessible […]
I asked ChatGPT to fix a nasty bug: broken images not showing up in Safari
Recent changes in my website’s implementation, now serving WebP images by default to improve its loading speed, had caused a very nasty issue: all the images on my website were broken in Safari, none was showing up. 😢 Everything was fine in Chrome, Brave, FireFox and other browsers but when I tried to open my […]
Transform any website into an API with Python / BeautifulSoup
I love APIs. They’re an amazing source of data for all kinds of creative projects. But what if a website doesn’t provide an official API? Can you still collect some data programmatically on a regular basis? If you want to transform (almost) any public-facing website into an API, you can leverage the power of Python, […]
How to create dynamic images for your WordPress posts using Python
You know the importance of having a nice featured image for your WordPress posts. That’s how those articles will be previewed on social media and it’s also a smart way to get traffic from Google Images. You can create dynamic images with SaaS such as Bannerbear, which does a great job in offering you no-code […]
How to find related entities to expand your blog posts?
When you’re writing an article, a good SEO practice is to cover the semantic field around the topic you’re addressing, i.e. broaden the scope of your research while staying on topic. You should include and develop relevant entities related to your subject. Using Google Search to find related queries & questions Let’s say for instance […]
How to create your own ChatGPT with OpenAI + Google Sheets + Kaggle Notebooks
BREAKING NEWS: There is now an official API for ChatGPT. You can follow the steps in this tutorial and replace the call to GPT-3 by a call to the ChatGPT API. ChatGPT is all the rage. Everyone has started using the conversation AI interface released in November 2022 by OpenAI. While it provides a great […]
How to start using Python on your Mac
Despite the tremendous advances in the no-code scene, I’ve been noticing an interesting trend: more and more people want to start using Python to enhance their automation skills. I’ve already published a few tutorials explaining how to connect Python to Google Sheets or to WordPress but I thought it would be worth spending some time […]
How to connect Python to Google Sheets
You might be using Make (formerly Integromat) – as I also do – to manage your sales & marketing automations. It’s a great no-code solution, for sure. But if you want to develop more sophisticated automation scenarios, you should explore Python. I started coding in Python a few months ago and I’m now using .py […]
In Google Sheets, how to transform a list in a cell into a series of rows
You might have pasted a list (ordered or not) into a single cell of your Google Sheets. Now you’re wondering how to transform it into a series of rows to append some data to each entry in the list. Here’s a detailed tutorial showing you how to do it in 2 (+1) easy steps. Step […]
