UK_Jan_v3_FINAL_real.xlsx
Last week I recorded a demo with super messy data on purpose.
It included different countries submitting their P&Ls every month. With different names on every file. Very few finance teams have regular file naming rules.
So I wrote one prompt. I added a single clause telling Claude to read the data inside the files, instead of using the names.
Claude built the dashboard in two minutes. It used correct numbers, correct brand colors, and countries it hadn't seen before (because it found them inside the files automatically).
Then I added three new files mid-recording and hit refresh. Everything updated instantly.
This without code, without any IT specialist, and without any BI team.
So, today I will show you, not only how you can create AI dashboards in Claude. But how you can auto-update them using ‘Live Artifacts’.
100s of millions of Artifacts have been created on Anthropic’s Platform
Most of them are static. This means that when you generate a chart, it looks great. But will not update with new data.
|
|
That changed in April when Anthropic launched Live Artifacts (that stay connected to your data and update when you open them).
Most finance teams are still working with static data. So someone is re-downloading the same files, reformatting them, and rebuilding a dashboard they already built. Every month.
I've been using Live Artifacts with P&L data from a shared Google Drive.
What I can show you now: a dashboard your whole team can run from one prompt, that updates when new files arrive, and that never needs to be rebuilt.
Here's how to set it up.
The Live P&L Method in 5 steps
By the end of this, your P&L dashboard will update itself when new files land in the folder – even if everyone names their files differently.
I call it the ‘Content-Not-Filename Method’:
Step 1 – Connect Google Drive
Open Claude Desktop. Customize → Connect your apps → Google Drive.
|
|
|
|
Activate it. This is what gives Claude permission to read your files directly.
It can then work from them without you uploading each time. Then create a folder in Drive – "Monthly P&L Reports" works – and put your current files in it.
Note – You can also do this with OneDrive
Step 2 – Write the prompt that describes the outcome
|
|
Open a new Claude Cowork chat. Describe the dashboard you want – which countries, which P&L lines, which charts. Add this to the prompt before you hit enter:
|
|
Claude will ask for permission to get files from Google Drive.
|
|
You can click for it to always allow, especially if you are doing something else and let it run in the background.
Step 3 – Verify three numbers, then make Claude verify the rest
Pick three or four figures and check them manually against your source files. Then ask Claude to audit itself:
You review the audit, not every formula – the same way you'd review a junior analyst's work before it goes anywhere.
Step 4 – In the same chat, type: "Now make this a live artifact"
When you ask for a Live Artifact. The dashboard saves to the Live Artifacts tab in your Cowork sidebar. Open it any time and refresh it to re-reads the folder.
|
|
It will then look whatever files are there, and refreshes the numbers.
Step 5 – Share it via the system prompt, not a link
Live Artifacts can be shared, but when others open them, they will only see it at the 'live' point that the person who created it generated it.
For everyone to be able to refresh with live data. Each person needs to create their own version.
So, ask Claude to write the system prompt for the artifact – all its logic in one block of text.
Then share that with your team, give them access to the Drive folder, and they'll have an identical dashboard running in under two minutes.
The One Thing to Remember
Using the ‘Content-not-Filename Method’ you can produce a dashboard that refreshes itself even if the filenames change.
This means as soon as the files are added to the folder. You can refresh the Live Artifact and the numbers will already be there.
So a new colleague with different habits, a new subsidiary added in Q3, or a country submitted late with a different format. None of that breaks the dashboard now, because the dashboard reads data, not names.
You’ll go from a static finance leader to a dynamic finance leader in no time 😉
Best,
Your AI Finance Expert,
– Nicolas
P.S. – The best way to learn from me directly is to join my weekly masterclasses. 60-mins + Q&A where I’ll get all your AI in Finance questions answered. Join me here.
P.P.S – I built this live on camera, including the audit step and the refresh test. Watch the full demo here → How to Build INSANE Live Financial Dashboards With Claude
.