The Scenario
You are a content manager at a B2B SaaS company. Your docs site runs on Algolia. Every quarter, the support team sends the same complaint: 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 create the missing help articles. The data is in Algolia analytics. Your deliverable is a prioritized list in a Google Sheet, ready to assign to writers.
The bad version of this week:
- You log into the Algolia dashboard and navigate to the analytics section
- You find the no-results report but it only shows the top 20 in the UI
- You contact support to ask how to export more
- Support tells you to use the analytics API
- You paste the API docs into a developer's Slack DM and ask for a script
- The developer gets to it in three days
- You have a content planning meeting Thursday morning and nothing to show
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that can call the Algolia analytics API directly and write the results wherever you point it.
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 and the search count to column B. Sort by count descending so the highest-volume gaps are at the top.
SheetXAI calls the Algolia analytics API, retrieves the no-results queries, and writes them into the sheet sorted by volume. You have your list before lunch.
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 ones that affect the most customers
The volume column is what makes this actionable. A query that returned zero results once is noise. A query that returned zero results 300 times is a content emergency.
Want writer assignments next to each row? Ask SheetXAI to add a column C for "Assigned To" and pre-populate it based on the topic area.
What If the Data Is Not Quite Ready
Zero-results data is usually clean because it comes straight from the Algolia API, but the analysis layer often needs work before you can act on it.
When some queries are clearly bot traffic or test strings
You see entries like "test," "asdfgh," and "xxxx" 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 matching a known test pattern. Write cleaned results to columns A and B sorted by count descending.
When you want to group queries by topic before assigning them to writers
300 queries across billing, onboarding, and API docs should go to different writers, not land in one flat list.
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. Then infer a topic category for each query based on the keywords and write the category to column C. Sort by topic then by count descending within each topic.
When you only want queries above a minimum volume threshold
Your writing team only has capacity for articles that affect more than 50 users.
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 columns A and B.
When you want to compare this month's gaps to last month's to see what changed
New product feature launched, new zero-results queries appeared. You want to know which gaps are new.
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. Then 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 in the prior month list, or "recurring" if it did.
The pattern: pull the raw gap data in one prompt, do the analysis and categorization in the same call. The writers get a sheet they can act on immediately.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, 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 with top queries and top hits or the Algolia in Google Sheets overview.