Ask Claude to define the current-stage review, export HubSpot pipeline data to Sheets, and build a custom dashboard with clearly scoped deal counts and values.
Plan stage-count and stage-value charts. Keep currencies separate and explain that this is current pipeline state, not historical stage conversion or a revenue forecast.
Keep explicit
Current snapshot · no inferred conversion rate
→Current snapshot · no inferred conversion rate
Datapipe → Sheets → Looker Studio
YOU
Send the pipeline view to Looker Studio.
✦
Save the HubSpot report, authorize Sheets and build custom charts from the populated export. Reconcile the selected pipeline and stage labels before sharing.
Keep explicit
Saved source report · custom native charts
→Saved source report · custom native charts
Looker Studio + Claude
YOU
Check the pipeline dashboard for the sales meeting.
✦
Compare the dashboard with the current source and account for changed deals between reads. Avoid implying that a date filter reconstructs historical pipeline state.
Keep explicit
Stage totals · currencies · snapshot timing
Current HubSpot pipeline dashboard
▦Deals by stage
▦Deal value by currency
▦Pipeline stage comparison
▤Current-state timing and source checks
Illustrative dashboard layout · no live report values
→Current HubSpot pipeline dashboard
1 / 4Read the pipeline
Illustrated use case. Save the actual report, dashboard and schedule settings in the indicated app.
MAKE THE TASK CONCRETE
Current HubSpot pipeline dashboard
01
Read the pipeline
Confirm the intended portal and pipeline. Read current accessible deal counts and values by stage using the source’s stage definitions.
02
Build the dashboard
Save the HubSpot report, authorize Sheets and build custom charts from the populated export. Reconcile the selected pipeline and stage labels before sharing.
03
Review the result
Compare the dashboard with the current source and account for changed deals between reads. Avoid implying that a date filter reconstructs historical pipeline state.
KNOW WHERE EACH STEP HAPPENS
One use case across the tools you use.
Claude
Read authorized data, agree on the questions and prepare the report, charts or review checklist.
Datapipe
Save source reports, authorize the destination, export the data and review any refresh or email settings.
Google Sheets + Looker Studio
Save a supported prepared copy or build the custom charts described above. Check each source and its freshness settings.
START WITH YOUR ASSISTANT
Give it the task. Follow up with the next step.
Copy these in order into the assistant connected to your Datapipe project.
Read the pipeline
Read the prompt
Use only the intended Datapipe project. Discover the account, datasets and compatible fields first. Use actual returned dates and filters; preserve empty or missing results and never substitute sample data for a failed read.
Build a HubSpot pipeline dashboard with Claude in Looker Studio.
Current pipeline state is not stage history, conversion rate or guaranteed revenue. Validate pipeline and currency context.
Refine the view
Read the prompt
Show which stages need a closer look.
Plan stage-count and stage-value charts. Keep currencies separate and explain that this is current pipeline state, not historical stage conversion or a revenue forecast.
Prepare the checklist without claiming completion. Save reports, destination authorization, schedules and recipients in Datapipe; build custom native charts in Looker Studio. The AI tools do not perform those setup steps.
Review the result
Read the prompt
Check the pipeline dashboard for the sales meeting.
Compare the dashboard with the current source and account for changed deals between reads. Avoid implying that a date filter reconstructs historical pipeline state.
Current pipeline state is not stage history, conversion rate or guaranteed revenue. Validate pipeline and currency context.
Prepare the checklist without claiming completion. Save reports, destination authorization, schedules and recipients in Datapipe; build custom native charts in Looker Studio. The AI tools do not perform those setup steps.
A FEW USEFUL ANSWERS
Before you start.
Will this show historical stage conversion?
No. This worked view uses current pipeline records. Historical transitions and conversion analysis require appropriate separate history and defined cohorts.
Does the assistant complete the setup automatically?
Prepare the checklist without claiming completion. Save reports, destination authorization, schedules and recipients in Datapipe; build custom native charts in Looker Studio. The AI tools do not perform those setup steps.
Does this example read or change my data?
No. The conversation and output are labeled illustrations. Review the actual source account, permissions, fields and destination before doing the task. Current pipeline state is not stage history, conversion rate or guaranteed revenue. Validate pipeline and currency context.