I Built a Self-Updating Finance Dashboard With Claude (Full Tutorial), by Luke Finance on YouTube. 16 min 3 s.
- Video length
- 16 min 3 s
- Time to do it
- 1 hour
- Difficulty
- Medium
- Steps
- 7
What you need
Steps
Lay out your finance data in Google Sheets across separate tabs: revenue, pipeline, customers, marketing, support, forecasts and budgets. Keep one header row per tab and consistent column names.
Give Claude the structure of your sheet: tab names, column headers and a few sample rows. Ask it to act as system architect and design the dashboard logic, KPIs and chart types.
Review Claude's proposed layout and KPI formulas. Correct any field names or calculations that do not match your sheet before building further.
Connect the Google Sheets API so the app can read your data. Share the sheet with the service account email and paste the API credentials into your hosting environment.
Have Claude generate the dashboard code, including tables, charts and KPI cards. Ask it to map each element to the correct sheet tab and column.
Set the refresh interval to 30 seconds so the app re-pulls data and recalculates KPIs, charts and tables automatically.
Deploy the app to a live domain through your host and test it in a browser. Share the URL with your finance team and confirm the data updates.
Tips and common mistakes
Keep column headers identical across tabs so the API mapping does not break when data changes.
Test with a copy of your sheet first so a bad formula or mapping cannot corrupt real finance data.
A 30 second refresh can hit API rate limits on large sheets, so widen the interval if you see errors.
Never paste API keys or credentials into a public chat or shared document.
Questions
Do I need to know how to code?
No. Claude writes the dashboard code and you review it. You do need to follow the API and hosting setup steps carefully.
Will it work with Excel instead of Google Sheets?
The workflow here uses the Google Sheets API. Excel needs a different connector, so the exact steps would change.
How often does the dashboard update?
The build sets it to refresh every 30 seconds. You can change that interval in the app settings if it is too frequent.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
