Building Automations: Keyword Research
How to use MAKE and OpenAI to automatically build lists of semantically relevant keywords on autopilot.
I am always on the hunt for ways to be more productive without having to outsource or hire virtual assistants, and we, right now, are in a golden age of AI and automation, so in today’s article, I want to show you how to build an automation that will take a list of keywords in a Google sheet and generate relevant LSI keywords automatically.
What is great about this method is that you can either start with a list of keywords to process or just add keywords when you think of them and the LSI keywords will be automatically generated for you.
There are also multiple ways you can use this such as generating a list of sub-topic for a given topic, asking for search queries based on a topic, or generating titles and meta-descriptions for a keyword… it’s up to your imagination.
This article is going to focus on using MAKE to build a list of semantically relevant keywords for a given keyword phrase.
Let’s get started.
To begin, you will need to create a Google Sheet with two columns.
Keyword
LSI Keywords
Save this sheet as Keyword Research. I also like to name the sheet as Keywords (click the arrow next to the sheet1 tab at the bottom of the sheet and select rename).
I also usually add Keyword and LSI Keywords to the first column.
Your document should look something like this.
That’s it. Google Sheets is all set and ready to
Now we need to build the automation in MAKE. If you haven’t created an account yet then you will need to head on over there and create one. It is free for up to 1,000 processes a month, which is more than sufficient for what you need.
Once in MAKE you will need to select scenarios on the left-hand side and create a new one.
Hit the big purple + sign in the middle of the screen.
Then type Google Sheets into the search bar at the bottom of the list that pops up.
You will then see this.
Choose Watch New Rows at the top. Then you should see this…
Click on the Click here to choose file and select the spreadsheet you previously created. If you have a lot of documents, it might be easier to start typing the name of the sheet to find it.
Once you have selected your sheet, a new option will appear asking for the sheet name. Click on the dropdown box, if you previously renamed it then choose Keywords otherwise choose Sheet1.
I use one spreadsheet for multiple research automation and I like having each sheet set up for that automation hence why I rename the sheet.
Make sure your values are like mine and select OK.
You are now all done, the first part of the automation is complete. Now on to the clever bit.
Click on the Add Automation link
Then search for OpenAI and choose this one…
Once you have done that, choose the Create A Completion option.
You will now have to enter your open AI API key. You can get this here. If you haven’t got an account then you will need to sign up for one.
You will now have to choose which model you want to use. GPT 3.5 is a lot cheaper, but to be fair it only costs pennies for the research so I usually choose GTP4
Now for the clever bit…