The Scenario
You are a localization manager at a SaaS company. Five Crowdin projects, each with eight to twelve target languages. Every other Friday, you send the exec team a progress update.
The update is supposed to be a single Google Sheet, one row per project per language, with translation percentage and approval percentage side by side so leadership can see at a glance where things stand before the release decision.
The slow version of the Friday report:
- You open each Crowdin project individually
- Click through to the language breakdown for each
- Copy the numbers into a working spreadsheet one language at a time
- Repeat for all five projects, roughly forty rows of manual entry
- Fix the formatting so it matches the template leadership expects
- You send it at 4:55 PM and miss the exec team's 3 PM review.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your Crowdin projects and writes the progress data directly into the sheet, so you never have to open Crowdin's UI for this.
Open the SheetXAI sidebar and type:
Get the translation progress for all languages in each project listed in column A of my sheet and write the project name, language code, translated percentage, and approval percentage into rows starting at row 2. Sort by project name, then by approval percentage ascending.
SheetXAI calls the Crowdin API for each project ID in column A, retrieves the per-language progress, and writes the rows into the sheet sorted the way you asked. The exec report is ready.
What You Get
A progress dashboard with one row per project per language:
- Project name — from column A, written back with each row
- Language code — the Crowdin language identifier
- Translated % — percentage of strings with a translation
- Approval % — percentage of strings approved by a proofreader
The approval column is the number that matters. Translated percentage tells you if the work has started. Approval percentage tells you if the work is shippable.
Want a different view? Ask SheetXAI to flag any language below 90% approved in red, or to add a column showing the delta from last week if you kept the previous run in a separate tab. Same prompt, different column.
What If the Data Is Not Quite Ready
Real localization dashboards are rarely clean pulls. SheetXAI handles the edge cases in the same prompt.
When the project IDs in column A are mixed with project names
Some rows have numeric project IDs, some have display names someone typed by hand.
For each row in column A, look up the Crowdin project by ID if the value is numeric, or by name if it is text. Write the project name, language code, translated percentage, and approval percentage into columns B through E.
When the exec team wants only the languages below a threshold
Leadership only cares about languages that are not ready to ship.
Get the translation progress for all languages in each Crowdin project listed in column A. Write only languages with an approval percentage below 80% into the sheet, with project name, language, and approval percentage. Sort by approval percentage ascending.
When you need a rollup row per project
The exec team wants one row per project showing the average approval across all languages, not a row per language.
For each Crowdin project in column A, get the per-language approval percentages and calculate the average. Write one row per project showing project name, number of target languages, and average approval percentage. Sort by average approval ascending.
When you need to compare this sprint to last sprint
You have last sprint's numbers in the Prev Sprint tab and need a delta column in the current view.
Get the current translation progress for all projects in column A. Write project name, language, and current approval percentage into columns A through C of the Current tab. Then compare each row to the matching row in the Prev Sprint tab by project and language, and write the approval percentage change into column D. Flag rows where approval dropped.
The pattern: instead of pulling data first and then computing the view, you describe the output you need and SheetXAI figures out the pull and the logic together.
Try It
Get the 7-day free trial of SheetXAI and open a sheet with your Crowdin project IDs in column A, then ask it to pull translation progress for all languages. The Crowdin integration is included in every SheetXAI plan. For related workflows, see how to export file-level progress or the Crowdin in Google Sheets overview.