The Scenario
You inherited the shortlist from the campaign manager who just went on parental leave. It's eighty Instagram handles in column A, collected from three different agencies over the past month. There are no metrics attached — just the handles, a few notes in column B, and the brief says the list needs to be scored and cut to thirty before the kickoff call on Thursday.
The bad version:
- Open HypeAuditor, search the first handle, read the follower count, engagement rate, and audience quality score, then type each number into columns C, D, and E — one handle at a time.
- Realize at handle thirty-four that you've been putting the audience quality score in the fake follower column, which means you need to go back and re-pull the first thirty-three reports.
- Spend the rest of Tuesday catching up, then discover that six of the handles have been deactivated and HypeAuditor returns no data — which you only find out by checking each one individually.
You were handed a list and asked to score it. Nobody asked you to become a data entry clerk, and the kickoff call is in forty-eight hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the handles in your sheet and talks to HypeAuditor on your behalf — pulling the analytics for every row in one pass and writing the results into the columns you specify.
For each Instagram username in column A, fetch the HypeAuditor report and fill in follower count, engagement rate, audience quality score, fake follower percentage, and top audience country to columns C–G. If a handle returns no data, write "NOT FOUND" in column C.
What You Get
- Column C: follower count, formatted as a number
- Column D: engagement rate as a percentage
- Column E: audience quality score (0–100)
- Column F: fake follower percentage
- Column G: top audience country by follower share
- Any handle with no HypeAuditor data gets "NOT FOUND" in column C so you can see the gaps immediately
What If the Data Is Not Quite Ready
The handles have mixed formatting — some with @, some without
For each Instagram username in column A, strip any leading @ before fetching the HypeAuditor report. Fill in follower count, engagement rate, audience quality score, fake follower percentage, and top audience country to columns C–G.
Some handles might be TikTok accounts mixed into an Instagram list
For each handle in column A, attempt to fetch the HypeAuditor Instagram report. If the account isn't found on Instagram, try TikTok and write the platform it was found on to column H. Write "NOT FOUND" if neither returns data.
You only want to pull data for handles that haven't been scored yet
For each Instagram username in column A where column C is empty, fetch the HypeAuditor report and fill in follower count, engagement rate, audience quality score, fake follower percentage, and top audience country to columns C–G.
You need the full qualification pass — score, flag, and rank in one shot
For each Instagram username in column A, fetch the HypeAuditor report and fill columns C–G with follower count, engagement rate, audience quality score, fake follower percentage, and top audience country. Then in column H, write "QUALIFIED" if the audience quality score is above 60 and fake follower percentage is below 20%; otherwise write "DISQUALIFIED". Sort the sheet by column E descending when done.
One prompt, one pass — the enrichment and the scoring happen together.
Try It
If you have a Google Sheet with a column of Instagram handles waiting to be scored, Get the 7-day free trial of SheetXAI and ask it to pull the HypeAuditor metrics in one shot. Then check out how to search HypeAuditor for new influencer prospects or return to the HypeAuditor overview.