Workflow

B2B Video Script Generator

Automatically creates personalized 60-second video outreach scripts for B2B sales teams by analyzing lead websites and integrating relevant case studies.

Last updated

March 10, 2026

Connectors used

Google Sheets

Tags

Cold OutreachLead GenerationSales AutomationVideo Scripts

B2B Video Script Generator

This workflow automatically creates personalized 60-second video scripts for cold outreach tailored to B2B leads. By analyzing a lead's company website and matching their pain points with relevant success stories, it generates engaging sales videos that resonate directly with each prospect.

What The Workflow Does

  1. Starts with either a manual trigger or mock lead data for testing.
  2. Scrapes the full homepage text of the lead's website.
  3. Uses an AI model to analyze the website content and extract their target audience, core product, and main pain point.
  4. Searches a curated agency case study database for relevant success stories addressing that pain point.
  5. Combines the case study results with triage data to prepare inputs.
  6. Creates a conversational video outreach script referencing the lead's product, pain point, and a matching ROI case.
  7. Writes the completed script back into a Google Sheet alongside lead details.

Prerequisites

  1. A Needle platform account.
  2. A connected Google Sheets account for live lead data input and output.
  3. Active API access for web browsing, AI models, and semantic search collection.
  4. A prebuilt Needle collection containing agency case studies and ROI examples.

Workflow Steps

StepComponentDescription
1TriggerStarts the flow manually or uses simulated lead info to test the pipeline without live data.
2Web ScraperCollects all visible homepage text from the lead's URL, extracting headlines, subheadings, value props, and feature details.
3AI AnalysisProcesses scraped text to identify the lead's target audience, core product, and primary pain point relevant for sales outreach.
4RAG SearchQueries the case study collection with the extracted pain point to find agency success stories tied to similar challenges.
5Data MergerCombines retrieved case study information with triage details, providing a fallback summary if no specific cases are found.
6Script GeneratorComposes a natural 60-second video script, including hooks, pain statements, solution pitches, and a soft call to action.
7Google SheetsInserts or updates the lead row, saving the generated script along with the lead name, URL, and timestamp.

Expected Output

You receive a customized cold outreach video script for each lead, saved directly into your Google Sheet alongside their details. This script is designed to feel personal, relevant, and human, ready to boost engagement in your B2B sales efforts.

Important Notes

  1. To activate with real leads, replace the mock data node with a Google Sheets trigger connected to your lead list.
  2. Ensure your case study collection is regularly updated to keep pitches fresh and meaningful.
  3. Reviewing scripts before sending is recommended, even though the AI models are tuned for specificity and impact.
  4. Visual cues in the script brackets help guide recording your video with smooth transitions.

Want to showcase your own workflows?

Become a Needle workflow partner and turn your expertise into recurring revenue.

Try Needle today

Streamline AI productivity at your company today

Join thousands of people who have transformed their workflows.

Agentic workflowsAutomations, meet AI agents
AI SearchAll your data, searchable
Chat widgetsDrop-in widget for your website
Developer APIMake your app talk to Needle
    Needle LogoNeedle
    Like many websites, we use cookies to enhance your experience, analyze site traffic and deliver personalized content while you are here. By clicking "Accept", you are giving us your consent to use cookies in this way. Read our more on our cookie policy .