The Scenario
The creative director sent a message this morning: before the brief goes to the design team, she wants to know which content formats are actually driving engagement across the fifteen Instagram accounts you're planning to partner with. Reels? Carousels? Static? She needs the last twenty posts from each creator analyzed and a summary ready for the 2pm sync.
It's 10am.
The bad version:
- Open HypeAuditor, pull the account media for the first creator, scroll through the recent posts, note the content type, likes, comments, and engagement rate for each one — manually — then tab to the sheet and start entering rows.
- Repeat for all fifteen creators. Each account is a separate report page. Some creators post Reels, some carousels, some a mix — and HypeAuditor surfaces them differently depending on the account tier.
- By 1:30pm you have six accounts done, forty rows of data with inconsistent formatting, and no time to write the content format summary the creative director actually asked for.
You were supposed to be doing analysis. Instead you spent three hours being a data transcription service.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the Instagram usernames in your sheet, retrieves the account media data from HypeAuditor for each, and writes the post-level records — content type, performance, and metadata — into rows in your sheet.
For each Instagram username in column A, retrieve the recent post media from HypeAuditor and write post type, likes, comments, engagement rate, and post date to separate rows in this sheet. Add the account username in a new column so each row is labeled.
What You Get
- One row per post, with the source account username labeled in column A
- Column B: post type (Reel, carousel, static image, or video)
- Column C: like count
- Column D: comment count
- Column E: engagement rate for that post
- Column F: post date
- Posts are written in chronological order per account, so you can scan by creator
What If the Data Is Not Quite Ready
You want only the last 20 posts per creator, not the full media history
For each Instagram username in column A, retrieve the 20 most recent posts from HypeAuditor and write post type, likes, comments, engagement rate, and post date to separate rows. Include the account username in column A for each row.
You want a summary row per creator after the post-level rows
For each Instagram username in column A, retrieve the 20 most recent posts from HypeAuditor and write post type, likes, comments, engagement rate, and post date to separate rows. After each creator's posts, add a summary row showing the account username, total posts pulled, average engagement rate, and the most common post type.
You only care about Reels — filter out static and carousel posts
For each Instagram username in column A, retrieve recent posts from HypeAuditor. Write only Reels to the sheet — post date, like count, comment count, engagement rate, and video thumbnail URL to columns B–F. Label each row with the account username in column A.
Full content audit — pull posts, flag top performers, and summarize format breakdown in one pass
For each Instagram username in column A, retrieve the 20 most recent posts from HypeAuditor and write post type, likes, comments, and engagement rate to separate rows, labeled with the username. Mark any post with an engagement rate above 5% as "TOP PERFORMER" in a new column. At the bottom of each creator's section, add a summary row with the breakdown of post types (how many Reels, carousels, and static posts) and the average engagement rate per type.
The full creative audit — data, flagging, and format summary — in a single ask.
Try It
If you have a Google Sheet with a list of Instagram accounts and need post-level media data pulled in before a creative brief, Get the 7-day free trial of SheetXAI and ask it to pull the HypeAuditor account media in one pass. You can also bulk-enrich influencer profiles with audience quality data or return to the HypeAuditor overview.