KoalaChat – VBA Code To Make Queries from Excel & Access

0 Shares

Speaking as a Gen X dinosaur, I pretty much live in Microsoft Excel and Access these days. Google Sheets is nice, but Excel is still Gen X’s go-to tool.

So for those of you with fond memories of the eighties, here’s some VBA code which you can use to pull KoalaChat results into an Excel spreadsheet.

Add a module to your Excel Spreadsheet and copy the following function.

Public Function GetKoala(prompt)
    Dim xhr As Object
    Dim strURL As String
    Dim strResponse As String
    Dim htmlDoc As Object
    Dim strTitle As String
    Dim apiKey As String
    
    apiKey = "Your_API_Key_Here"
    
    Set xhr = CreateObject("MSXML2.XMLHTTP")
    
    ' Define the URL of the website to extract data from
    strURL = "https://koala.sh/api/gpt/?input=" & prompt & "&key=" & apiKey
    
    ' Send a GET request to the website
    xhr.Open "GET", strURL, False
    xhr.send
    
    ' Get the response text
    strResponse = xhr.responseText
    
    ' Create an HTML document object and load the response text
    Set htmlDoc = CreateObject("htmlfile")
       
    GetKoala = strResponse
    
End Function

To use this, simply call the GetKoala function via a formula in Excel:

**KoalaChat – for the Important Questions in Life…**

There are some fun things you can do with this…

First, this is awesome for programmatic SEO. Need to saturate a topic with a bunch of related research requests? Enter a list of keywords in a spreadsheet and copy-paste the formula down the page to get first draft copy.

In fact, you can even concatenate additional instructions onto your prompt through Excel’s string concatenate feature, as demonstrated by the literary masterpiece below (my most sincere apologies to Douglas Adams).

**Ahoy! Add More Instructions to the Prompts!**

For the truly lazy SEO, here’s another idea from MarketMuse. You can use the topic research function in MarketMuse to generate a list of questions related to a specific topic…

**Market Muse Generates Questions Related To A Specific Topic**

These can be exported as an Excel Spreadsheet…

Topics, Exported To Excel… Hmm, Wonder What happens Next?

Which you can feed into KoalaChat with some additional prompt guidance to generate a whole bunch of small articles… These can be uploaded to WordPress via a template.

For more ideas on getting the most out of KoalaWriter, KoalaChat, and AI Assisted content tools (including Market Muse, ChatGPT, and Co-Schedule), see our list of KoalaWriter Workflow Tips.

For a Free Trial of MarketMuse, sign up through this link.

For a Free Trial of Koala Writer, sign up through this link

0 Shares