The Scenario
Your engineering director sent a message at 9 PM on a Tuesday: she wants to know whether the backend team codes more in the morning or afternoon, and which days of the week see the most hours. She is redesigning the meeting schedule and wants to protect peak coding time with meeting-free blocks.
You manage developer operations. You have access to WakaTime. You also have six other things open and no idea how to extract hourly and daily productivity distributions from an API you have used exactly twice.
The bad version:
- You log into WakaTime, navigate to the insights section, and find that the dashboard shows a chart — not a table you can copy.
- You take a screenshot of the chart, paste it into the Slack thread, and realize the director asked for the data in a spreadsheet so she can filter it herself.
- You spend 45 minutes trying to find the right WakaTime API endpoint for insights, read the docs, give up, and tell her you will have it by morning.
It is now morning. You still do not have it.
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 developer insights directly — no API docs, no chart screenshots.
Open a new sheet and paste this:
Fetch WakaTime insights for my account for the last 90 days and fill this sheet with: Day of Week, Average Hours, Peak Hour Range, Top Project
What You Get
- Seven rows, one per day of the week.
- Average Hours coded on that day across the 90-day window.
- Peak Hour Range showing the time block with the highest average activity (e.g., 10 AM to 12 PM).
- Top Project for that day of week — the project that absorbed the most hours on average.
- Data sorted by Day of Week in calendar order (Monday through Sunday).
What If the Data Is Not Quite Ready
The date range is in cells, not hardcoded
Your sheet has the analysis window in A1 and A2:
Pull my WakaTime coding insights for the range in A1:A2 and populate this sheet with insight category in column A and value in column B — covering best day, peak hour, average daily hours, and longest streak.
You want an hourly breakdown instead of a daily one
The director wants to see every hour of the day, not just peak range:
Fetch WakaTime insights for the last 90 days. Build a table with Hour of Day (0 through 23) in column A and Average Hours Coded in column B — so she can see the full daily distribution curve.
You want to compare two engineers
You have access to two WakaTime accounts and want a side-by-side comparison:
Fetch WakaTime insights for account 1 for the last 90 days. Put Day of Week in column A, Average Hours in column B, Peak Hour in column C. Then fetch insights for account 2 for the same window and put Average Hours in column D and Peak Hour in column E — same day order so rows align.
Full productivity pattern report with meeting-block recommendations in one pass
Fetch WakaTime insights for the last 90 days. Build a table with Day of Week, Average Hours, Peak Hour Range, Top Project. Then add a Meeting Safety column: write "Protect" if Average Hours is above 5, "Flexible" if between 2 and 5, "Low Activity" if under 2. Sort by Average Hours descending. Fill this sheet starting at row 2 with Day of Week, Average Hours, Peak Hour Range, Top Project, Meeting Safety.
The director gets a table she can filter and a recommendation column she can share with the leadership team.
Try It
Get the 7-day free trial of SheetXAI and open a new sheet in your engineering ops workbook — ask it to pull WakaTime productivity insights for the last 90 days, flag the high-activity days for meeting protection, and have the table ready before the next schedule review. See also how to bulk import sprint summaries from WakaTime, or return to the WakaTime integration overview.