Perfect, now that we understand how the system works, let’s set it up!
1- Log in to Your Make Account
If you don’t have an account, just sign up and log in.
2- Install the Content Extractor App
It is very simple, click the button below:
You will see this page:
Click “Install,” and you are done!
3- Clone the Google Sheet
As explained before, the system reads and saves data in a Google Sheet. I prepared the sheet to make it easy for you to get started quickly. Just create a clone of it in your Google account.
4- Create a Datastore
Before we set up the system, you need to create a data store.
So head to “Datastores” from the right menu and create a new one.
Call it: SERP_RESULTS
Create a new data structure, which means adding fields to the table. Add the following:
field 1:
Name: link
Type: Text
field 2:
Name: position
Type: Number
field 3:
Name: Parent Keyword
Type: Text
field 4:
Name: Last Updated
Type: Date
Great! We have our data store. We are ready to create the automated system.
5- Import The System Blueprint
Now, go to “Scenarios,” create a new scenario, then click “Import Blueprint.“
🔴 DON’T FORGET TO EXTRACT THE ZIP FILE FIRST
6- Update the Modules
Now that we have the scenario, the database, and the Google Sheet, we just need to update our app modules to match your accounts.
1- Update the Google Sheets Module Authentication
Please update all the Google Sheet modules and the spreadsheet ID, which can be found in the browser URL.
2- Connect OpenAI Module
Click on the OpenAI App to connect with your account using your API key.
3- Set the Serper API Key
Since we are using the Serper API to get Google organic results, get an API key and set it here.
4- Connect with your Datastore.
Make sure all modules are set up correctly and update the datastore module to match the datastore we created in step 4.
5- Set “Extract Web Content” API Key
To use my app for free, make sure to use this API key: HASAN2024
7- Run a Test
Perfect, we have our system ready!
Let’s give it a try!
If you have any problems, you can join us on the forum; it is free!
I will be there almost every day to help.
If you came to this article from my YouTube video, you know I discussed how these systems can be used to build a business in today’s “AI Era.”
One of the most in-demand products in the digital world today is ready-made systems, or what we call “done-for-you” systems.
Businesses and individuals need plug-and-play systems that help them automate or fix a specific problem.
This system is a great example of a “done-for-you” system that you can sell online. You could also use it as a powerful lead agent.
Now, I’m giving it to you for free, yes. But that doesn’t mean you shouldn’t join my newsletter to get my weekly updates and exclusive tips 😅
Anyway, the idea here is to learn and build such systems. This service will make you stand out in the competition today, as it is still new and not many freelancers know about it.
🟢 As a bonus tip, to make your offering even more unique and provide more value to your customers, and help you turn this into a recurring income business:
You can create custom apps in the workflow you are selling. Like the one I shared with you for free, the “Extract Web Content” app.
Yes, I gave it to you for free, but you can create something similar that makes your system unique and helps get your customers attached to the service you provide.
Do it, and thank me later 😉
How did I build the Make Custom App?
Make allows you to build any custom app you want as soon as you have the API endpoint for it.
So what I did simply was create a very basic API in Python. Here is the code:
from fastapi import APIRouter
from SimplerLLM.tools.generic_loader import load_content
router = APIRouter()#extract content from blog post
@router.get("/tools/extract-content-from-page",)
async def extract_content_from_web_page(url: str,):
return load_content(url)
I used SimplerLLM, my free Python library.
You can see how easy it is to read content with the built-in functionalities.
And built the app based on that.
👉 You can learn more about APIs and how to build and sell them in this course here.
You can add an API key as I did, and this app can even be sold independently as a custom app for Make that helps build more complex and customized systems!
Other than building custom Make apps, you can extend this system further to provide more functionalities and value to your customers or your own business.
Here are some ideas:
1- Add AI Analysis
It would be a great addition to the system to have AI analyze the final results and suggest tips based on that.
For example, my AI-powered SEO analyzer extracts an SEO report using an API, and then AI analyzes and creates a detailed report based on that data. You can test it here.
Another example is the AI keyword research tool, where I feed the keywords to the AI, and it suggests a content plan and tips based on that data.
You can even go further with an agentic workflow that automates the entire process.
2- Add Keyword Position Tracking
Since we are already extracting organic Google results with the Serper API and saving them in the database with their positions, you can also track the position of specific domains for each target keyword to see if they rank.
3- Add Keyword Metrics
You can also add more metrics to the keywords, such as search volume, keyword difficulty, CPC, and much more. This will enrich the data for AI analysis or your customers.
You can obtain such data from SEO APIs like Spyfu, Semrush, and others.
4- Optimize the Prompts
When you open the OpenAI modules, you will see I added some prompts to extract content ideas from text.
These are not the best or perfect prompts. They do the job, but you can optimize them to get better results.
If you have taken my prompt engineering course, you know that with some prompting techniques, you can optimize the prompts for better results.
Remember, if you have any problems or want to chat, hop into the forum. I’m there almost every day to answer your queries!
Good Luck!
