How to Automate Account executives and sales engineers who need to create customized pitch decks for each prospect without starting from scratch every time. with HubSpot + Google Sheets + Claude + Google Slides + Slack
Learn how to automate account executives and sales engineers who need to create customized pitch decks for each prospect without starting from scratch every time. using HubSpot, Google Sheets, Claude, Google Slides, Slack. Step-by-step guide with pro tips for maximum efficiency.
Every minute you spend on repetitive tasks is a minute taken away from high-impact work. This AI workflow recipe shows you how to use HubSpot, Google Sheets, Claude, Google Slides, and Slack together to automate account executives and sales engineers who need to create customized pitch decks for each prospect without starting from scratch every time. — saving you time and delivering better results.
Why This Matters
Why This Matters Now
The average knowledge worker spends 60% of their time on "work about work" — status updates, data entry, and context switching. This workflow eliminates a significant chunk of that overhead.
HubSpot centralizes all the prospect intelligence your team has gathered, Claude transforms that raw data into persuasive narratives tailored to each buyer, and Google Slides delivers it in a professional format. This dramatically reduces deck creation time from hours to minutes while maintaining personalization.
Teams using this type of automation report saving 5-10 hours per week on average, with the added benefit of more consistent, reliable outputs.
How It Works: Step-by-Step Guide
This advanced workflow connects 5 powerful tools into an automated pipeline. Here's how each step works:
Step 1: HubSpot — Extract deal and prospect data
Connect to your HubSpot CRM and configure the trigger for deals reaching a specific pipeline stage (e.g., 'Proposal Sent'). Pull the company profile, deal value, industry, pain points logged in notes, previous interactions, and any custom properties relevant to your pitch.
HubSpot serves as the starting point of your automation. This is where raw data enters the pipeline and gets processed for the next stage.
Step 2: Google Sheets — Aggregate and structure deal intelligence
Consolidate the HubSpot data alongside industry benchmark data and competitive intelligence stored in a shared Google Sheet. This step normalizes the data into a structured format that includes company size, revenue range, known competitors, and relevant case studies from your portfolio that match the prospect's industry.
With Google Sheets handling step 2, your data gets transformed and enriched before reaching the next stage.
Step 3: Claude — Generate personalized sales narratives
Send the structured deal context to Claude with a prompt that generates a company-specific value proposition, ROI estimates based on deal size and industry benchmarks, competitive differentiators, and three key talking points. Include your product positioning guidelines to ensure brand consistency.
With Claude handling step 3, your data gets transformed and enriched before reaching the next stage.
Step 4: Google Slides — Build a tailored presentation
Use a branded Google Slides template and populate it with the generated content. Map value propositions to the hero slide, talking points to individual slides, and ROI data to a summary slide. The finished deck is saved to a shared drive folder and linked back to the HubSpot deal record.
With Google Slides handling step 4, your data gets transformed and enriched before reaching the next stage.
Step 5: Slack — Notify sales rep and manager for review
Post a notification to the sales team's Slack channel with a link to the generated deck, a brief summary of the prospect profile, and the suggested talking points. Tag the assigned account executive and their manager so the deck can be reviewed and customized before the meeting. Include a direct link to the HubSpot deal for quick context.
Slack delivers the final output, completing the automation loop and ensuring the right information reaches the right people at the right time.
Pro Tips for Maximum Impact
Who Should Use This Workflow?
This recipe is ideal for account executives and sales engineers who need to create customized pitch decks for each prospect without starting from scratch every time.. It's rated as Advanced, so teams with automation experience will find it straightforward to implement.
The Bottom Line
HubSpot centralizes all the prospect intelligence your team has gathered, Claude transforms that raw data into persuasive narratives tailored to each buyer, and Google Slides delivers it in a professional format. This dramatically reduces deck creation time from hours to minutes while maintaining personalization. By combining HubSpot, Google Sheets, Claude, Google Slides, Slack, you get a workflow that's greater than the sum of its parts.
Get Started
Ready to put this automation to work? Check out the full recipe for step-by-step setup instructions, or browse our recipe collection for more AI workflow ideas.
Have questions about setting up this workflow? Drop a comment below or reach out to our team — we're here to help you automate smarter.