The Scenario
You are a content manager at a B2B SaaS company. Your docs site runs on Algolia. Every quarter, the support team flags the same problem: customers are searching for things and finding nothing.
You want a list of the top 200 zero-results queries from the last month so you can brief your writing team on which help articles to create. Your deliverable: a prioritized workbook tab, ready to assign in your project tracker by Thursday morning's planning meeting.
The bad version of this week:
- You log into the Algolia dashboard and find the no-results report shows only the top 20 in the UI
- You email support asking for a full export
- Support says you need to use the analytics API and points you to the docs
- You forward the docs link to a developer and wait
- The developer delivers a CSV on Wednesday afternoon
- You spend Wednesday evening massaging it into the format the writing team needs
- You walk into Thursday's meeting with a list that is one day old and not fully formatted
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the Algolia analytics API and writes the results directly into a tab, formatted for immediate use.
Open the SheetXAI sidebar and type:
Pull the top 200 searches from my Algolia index 'docs_index' that returned zero results last month. Write the search query to column A of the Content Gaps tab and the search count to column B. Sort by count descending.
SheetXAI calls the analytics API, retrieves the no-results queries, and writes them into the Content Gaps tab sorted by volume.
What You Get
A prioritized content gap list with:
- Column A — the exact search query customers typed
- Column B — how many times that query returned nothing last month
- Sort order — highest-volume gaps first, so writers tackle the most impactful ones
Volume is what makes this actionable. A query that failed once is noise. A query that failed 300 times is an article that should have existed months ago.
What If the Data Is Not Quite Ready
The raw gap data is clean but often needs shaping before writers can act on it.
When some queries are clearly bot traffic or test strings
You see entries like "test," "asdfgh," and strings of random characters at the top of the list.
Pull the top 200 zero-results queries from my Algolia index 'docs_index' last month. Filter out any query shorter than three characters or that looks like a test pattern. Write the cleaned results to the Content Gaps tab, sorted by count descending.
When you want to group queries by topic before assigning them
Billing queries go to one writer, onboarding queries to another. A flat list means manual sorting.
Pull the top 200 zero-results queries from my Algolia index 'docs_index' last month. Write query to column A and count to column B of the Content Gaps tab. Infer a topic category for each query and write it to column C. Sort by topic then by count descending within each topic.
When you only want queries above a minimum volume
Your writing team only has capacity for gaps that affect more than 50 users per month.
Pull zero-results queries from my Algolia index 'docs_index' for the last 30 days. Only include queries with a search count above 50. Write query and count to the Content Gaps tab.
When you want to compare this month's gaps to last month's to see which are new
A new feature shipped last week. You want to know which zero-results queries are new versus recurring.
Pull the top 100 zero-results queries from my Algolia index 'docs_index' for the current month and write them to columns A and B of the Content Gaps tab. Pull the top 100 for the prior month and write them to columns D and E. In column G, mark each current-month query as "New" if it did not appear last month, or "Recurring" if it did.
The pattern: pull the gap data and add the analysis layer in the same call. The writing team gets a workbook they can act on, not a raw export to reformat.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask it to pull your zero-results queries from Algolia. The Algolia integration is included in every SheetXAI plan. For related workflows, see how to audit search relevance in Excel or the Algolia in Excel overview.