Build a sales dashboard from mixed files with Claude Cowork

Kevin Stratvert · Community · 9:41 ·

Watch on YouTube

Kevin Stratvert combines sales information from PDFs, spreadsheets, and text files into a dashboard, then extends the workflow with Google Drive.

Read these video notes as Markdown

What to look for

  • List the fields that must line up across documents before joining them.
  • Ask for an intermediate table so totals can be checked before the dashboard is styled.
  • Mark the date range and data sources on the dashboard so readers can tell what is included.

Video chapters

Open a timestamp on YouTube.

  1. 1:35Combine local source files
  2. 4:11Add data from Drive
  3. 5:34Refresh the dashboard
  4. 6:08Save a skill for reuse

Try it after watching

Make a miniature dataset with the same account in two sources. Verify the dashboard combines those records once and the total matches the source data.