n8n templatesn8n templates

Create Custom Presentations per Lead

This workflow automates the processing of potential customer data by real-time monitoring for new files in Google Drive and generating personalized presentations. It supports extracting customer information from CSV or Excel files and quickly customizing content based on preset templates. Ultimately, the generated documents are associated with customer records, significantly improving the efficiency of sales and marketing teams, reducing errors and time wasted due to manual operations, and helping businesses respond more quickly to customer needs.

Workflow Diagram
Create Custom Presentations per Lead Workflow diagram

Workflow Name

Create Custom Presentations per Lead

Key Features and Highlights

This workflow automates the processing of newly received lead data by batch-generating personalized presentations based on templates and synchronizing relevant information with the customer list. It supports real-time monitoring of new files (such as CSV or Excel) in a specified Google Drive folder, automatically parses and imports the data, duplicates and customizes Google Slides templates, and ultimately associates the generated presentations with lead records. This significantly enhances the efficiency of sales and marketing teams.

Core Problems Addressed

  • Time-consuming and labor-intensive manual creation of personalized presentations for different leads.
  • Complex and error-prone processes for lead data collection, organization, and presentation creation.
  • Lack of automation to tightly link customer data with presentations, impacting sales follow-up efficiency.

Use Cases

  • Sales teams needing to rapidly produce customized pitch materials for different leads.
  • Marketing campaigns requiring automatic organization of lead information and generation of corresponding presentations.
  • Any office scenario that requires automated association and management of customer data with presentation files.

Main Workflow Steps

  1. Monitor New Files: Watch for newly created CSV or Excel files in a designated Google Drive folder.
  2. File Type Detection: Identify file type based on MIME type to differentiate between CSV and Excel for appropriate processing.
  3. Download and Parse Data: Download the file and extract lead information.
  4. Create New Google Sheet: Generate a new spreadsheet and import the lead data.
  5. Data Merging and Organization: Merge new data and update the lead list.
  6. Copy Presentation Template: Duplicate a predefined Google Slides template.
  7. Customize Presentation: Replace placeholders in the template with lead-specific details such as company name and contact person to create personalized content.
  8. Move and Archive Files: Transfer the generated presentations to designated client folders.
  9. Sync Updates to Sheet: Write the presentation IDs back to the lead list for easy tracking and management.

Systems and Services Involved

  • Google Drive: File monitoring, downloading, template copying, and file moving.
  • Google Sheets: Creating spreadsheets, reading, and updating lead data.
  • Google Slides: Duplicating templates and replacing text to generate customized presentations.
  • n8n Automation Platform: Orchestrating and triggering the entire workflow.

Target Users and Value

  • Sales representatives and teams: Quickly create professional, personalized client presentations to improve communication efficiency.
  • Marketing professionals: Automatically organize lead information and deliver targeted customized content.
  • Business managers: Digitize and automate sales processes, enhance team collaboration, and reduce human errors.
  • Any organization needing to automatically convert customer data into customized presentations.

This workflow seamlessly integrates the Google Workspace suite to fully automate the process from lead data intake to customized presentation generation, greatly simplifying sales preparation, enabling rapid business response to client needs, and improving conversion rates.