Get a weekly throughput and capacity report without manual number crunching
Every Monday, WebRun opens XTRF and Smartcat, pulls all projects completed in the previous week, calculates total words delivered, language pairs handled, and linguist utilization rates, logs the figures to a Google Sheets tracker, and posts a concise throughput and capacity report to your operations team in Slack.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically generate a weekly throughput and capacity report for my translation agency?
WebRun opens XTRF and Smartcat every Monday, pulls all projects delivered in the previous week, calculates total words, language pairs, and linguist utilization rates, logs the figures to a Google Sheets tracker, and posts a concise week-on-week throughput report to your operations team in Slack. No manual data gathering, no spreadsheet formulas to run.
- Operations team gets a full week-on-week throughput report every Monday morning
- Linguist utilization and available capacity are visible without opening two systems
- Google Sheets tracker builds a running history of throughput for trend analysis
Built for translation agencies · LSP operations managers · language service providers · localization team leads
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.xtrf.euin a real browser with your saved login - no setup, no API keys. -
1
XTRF - pull completed projects and word counts for the week
xtrf.eu
WebRun opens XTRF to pull completed projects and word counts for the week. - Open XTRF and filter projects to Delivered status with a delivery date in the previous calendar week
- Capture the project count, total word count, language pairs handled, and per-client breakdown
- Note any projects that were delivered late and the reason recorded in the system
Done when Last week's delivered project totals are captured with word counts and language pair breakdowns.
-
2
Smartcat - calculate linguist utilization and task completion rates
smartcat.com
WebRun opens Smartcat to calculate linguist utilization and task completion rates. - Open Smartcat and pull task completion data for the same date range
- Calculate the number of words processed per active linguist and the average task turnaround time
- Identify linguists with high utilization and any with capacity available for additional work
Done when Linguist utilization rates and average turnaround times are calculated for the week.
-
3
Google Sheets - log weekly throughput figures to the tracker
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log weekly throughput figures to the tracker. - Open the weekly throughput tracker in Google Sheets
- Append a new row with the week's figures: projects delivered, total words, language pair count, average turnaround, and top linguists by volume
- Update the cumulative monthly and quarterly totals in the summary tab
Done when The Google Sheets tracker is updated with last week's throughput figures.
-
4
Slack - post throughput and capacity report to operations team
slack.com How to Automate Slack
WebRun opens Slack to post throughput and capacity report to operations team. - Post a throughput and capacity summary to the operations channel
- Include projects delivered, total words, top language pairs, average turnaround, and a capacity note on available linguists
- Compare this week's figures to the previous week and flag any notable change in volume or speed
Done when The operations team has last week's throughput report in Slack with week-on-week comparison.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it change anything in XTRF or Smartcat?
No. WebRun reads project and task data from both systems. The only write action is appending a new row to your Google Sheets tracker. Nothing is modified in your TMS.
Can the report include revenue figures alongside word counts?
Yes. If revenue data is available in XTRF, WebRun can include total revenue delivered alongside word counts and add a revenue-per-word metric to the weekly summary.
What if we only use one TMS and not both XTRF and Smartcat?
The report can be configured to pull from XTRF only or Smartcat only. All throughput calculations and the Google Sheets log work the same way regardless of which single system is the source.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.