The Scenario
You are building a portfolio site. You want a data-driven stats section: total lifetime hours coded, top five languages all-time, top five projects all-time. The kind of numbers that belong on a developer page the way follower counts belong on a social profile.
You have a WakaTime account that has been running for three years. You know the data exists — you have seen it on the WakaTime dashboard. Getting it into a structured Google Sheet so you can wire it to a dashboard template is another matter.
You spent 20 minutes last week trying to export the "all-time" stats from WakaTime. There is no export button. There is a dashboard. There is a share page. Neither of those is a spreadsheet.
The bad version:
- You navigate to your WakaTime profile page, read the lifetime hours number off the screen, and type it into cell B1 by hand.
- You switch to the languages section, read the top five languages and their hours, type those in too.
- You go to the projects section, repeat the process, and realize WakaTime only shows the top five by default — you do not know if there are more below the fold.
Now you have a spreadsheet full of numbers you typed manually from a webpage, with no record of when you pulled them. When the portfolio site launches, you will have to update these by hand again.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands what you are looking at, and through its built-in WakaTime integration it pulls lifetime stats directly — no manual reading from dashboards, no typed-in numbers.
Open a new sheet and paste this:
Fetch my WakaTime all-time totals and user stats, then fill this sheet: row 1 total lifetime hours, rows 3 onward top languages with hours, rows 10 onward top projects with hours
What You Get
- Cell B1: total lifetime hours coded since account creation.
- Rows 3 onward: one row per language, with language name in column A and lifetime hours in column B, sorted descending.
- Rows 10 onward: one row per project, with project name in column A and lifetime hours in column B.
- Data pulled live from WakaTime — not a cached dashboard view.
What If the Data Is Not Quite Ready
You want a single summary table instead of a positional layout
You need a clean two-column table for a dashboard component:
Get my WakaTime all-time-since-today stat and full user stats. Populate this sheet with a summary table: Metric in column A, Value in column B — covering total lifetime hours, daily average, best day hours, top language, and top project.
You want more than the default top-five languages
WakaTime tracks far more languages than the five shown on the dashboard:
Fetch my WakaTime user stats all-time. List all languages in this sheet with Language in column A and Lifetime Hours in column B — sorted descending by hours. Include every language regardless of rank.
You want a snapshot date recorded alongside the data
Your portfolio site will show "as of [date]" next to the stats:
Fetch my WakaTime all-time totals and user stats. Fill this sheet with a summary table: Metric, Value, Snapshot Date — where Snapshot Date is today's date for every row. Include total hours, daily average, best day, top 5 languages, top 5 projects.
Full portfolio data pull with snapshot and rank in one pass
Fetch my WakaTime all-time user stats. Build a table in this sheet with columns: Section, Rank, Name, Hours, Snapshot Date. Rows 1 through 5: Section = Languages, ranked 1-5. Rows 7 through 11: Section = Projects, ranked 1-5. Row 13: Section = Summary, Name = Total Lifetime Hours, Hours = the all-time total. Use today's date as Snapshot Date throughout.
One prompt produces a structured table your portfolio template can read directly.
Try It
Get the 7-day free trial of SheetXAI and open a new Google Sheet for your developer portfolio stats — ask it to pull your WakaTime all-time totals, top languages, and top projects into a structured table, and update it whenever you want a fresh snapshot. See also how to export your language breakdown from WakaTime, or return to the WakaTime integration overview.