# Build a sales dashboard from mixed files with Claude Cowork

Canonical: https://www.coworks.dev/videos/claude-cowork-sales-dashboard

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

- Original video: [How to Use Claude Cowork (Step-by-Step Tutorial)](https://www.youtube.com/watch?v=YYr7hw5EAtk)
- Publisher: Kevin Stratvert (community)
- Published: 2026-08-17
- Duration: 9:41

## 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

- [1:35 Combine local source files](https://www.youtube.com/watch?v=YYr7hw5EAtk&t=95s)
- [4:11 Add data from Drive](https://www.youtube.com/watch?v=YYr7hw5EAtk&t=251s)
- [5:34 Refresh the dashboard](https://www.youtube.com/watch?v=YYr7hw5EAtk&t=334s)
- [6:08 Save a skill for reuse](https://www.youtube.com/watch?v=YYr7hw5EAtk&t=368s)

## 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.

## Follow the written guides

- [Practical use cases](https://www.coworks.dev/docs/use-cases)
- [Connector setup checklist](https://www.coworks.dev/docs/connector-checklist)
