The Scenario
You are a product manager. You need the 200 most recent Google Play reviews for three competitor apps before the product strategy meeting on Wednesday at 10 AM.
You want star rating, review text, and date in one Excel workbook so your team can tag themes during the meeting.
It is Monday afternoon.
The bad version:
- You search Google Play on the web and scroll reviews for app one
- You copy reviews into Excel one at a time
- You find a third-party scraper that returns a CSV but includes ten columns you do not need
- You spend 30 minutes deleting columns and re-sorting the date format to match Excel's expectation
- You are done with app one. Two more to go.
- You walk into Wednesday with one app's reviews and two hours of wasted formatting work.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your app ID list, calls DataForSEO's app reviews endpoint for each one, and writes every review into a structured tab.
Open the SheetXAI sidebar and type:
Fetch the 100 most recent Google Play reviews for app IDs listed in column A of my Competitor Apps tab and paste all reviews into a new tab called Reviews with columns for app_id, rating, review text, and date.
SheetXAI calls DataForSEO for each app ID, creates the Reviews tab, and writes every review as a structured row. Three apps, up to 300 rows, ready before Tuesday morning.
What You Get
A structured Reviews tab with one row per review:
- app_id — which competitor the review belongs to
- rating — star rating 1 through 5
- review_text — the full review text
- date — when the review was posted
All three competitors in one tab, sortable by date or rating. Filter to 1-star reviews to find pain points, or build a PivotTable to compare average ratings by competitor.
What If the Data Is Not Quite Ready
Review research requests arrive in different formats. SheetXAI handles the variations inline.
When you only have app names and not Play Store IDs
You know the competitor apps by name but not their internal Play Store IDs.
For each app name in column A of my Competitor Apps tab, search DataForSEO to find the Google Play app ID. Write the app ID into column B. Then fetch the 100 most recent reviews for each and write all reviews into a Reviews tab with columns for app name, rating, review text, and date.
When you only want negative reviews
You want to focus on the strongest complaints, not the full spread.
Fetch Google Play reviews for all app IDs in column A of my Competitor Apps tab. Filter to only reviews with a rating of 1 or 2 stars. Write the filtered results into a new Reviews tab with columns for app_id, rating, review text, and date.
When you want App Store data alongside Play Store
You want both storefronts for a complete picture.
Fetch the 50 most recent reviews from both Google Play and the Apple App Store for each app in column A of my Competitor Apps tab. Write all reviews into a Reviews tab with a Source column indicating which store each review came from.
When you need the reviews plus a theme summary for the meeting
The meeting needs raw data and a written analysis of the top complaint categories.
Fetch the 100 most recent Google Play reviews for each app ID in column A of my Competitor Apps tab. Write all reviews into a Reviews tab with columns for app_id, rating, review text, and date. Then read all 1-star and 2-star reviews and write a short paragraph in a Summary tab identifying the three most common complaint themes across all three competitors.
The pattern: the API pull and the analysis happen in one prompt, so the meeting deliverable is ready without a second pass.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with competitor app IDs or app names, then ask it to pull Google Play or App Store reviews from DataForSEO. The DataForSEO integration is included in every SheetXAI plan. For related workflows, see how to pull Google Business reviews into Excel or the DataForSEO in Excel overview.