n8n

How to Automate Google Slides Lead Presentations?

Turn every new lead CSV into a ready to share slide deck without manual work. Sales and marketing teams can upload a file to Google Drive and get a filled Google Sheet plus a custom Google Slides deck for each lead.

A Google Drive event starts the flow when a new file appears in the chosen folder. A switch checks the file type so only CSV files will run. The file is downloaded and the rows are extracted. A fresh Google Sheet is created and the lead data is appended. The sheet is then moved into a target folder for safe keeping. Next, each lead row is read from the sheet. The flow makes a copy of a Google Slides template, replaces placeholders like company name and contact info, and writes the new presentation ID back into the matching row in the sheet. This gives you one deck per lead with zero copy and paste.

You only need Google accounts and a Slides template with clear placeholder tags. Set the folder to watch, paste the template file ID, and map your CSV columns to the sheet fields. Expect big time savings and consistent branding. This is ideal for outbound teams, agencies preparing proposals, and event follow up where quick, personalized decks lift response rates.

What are the key features?

  • Watches a Google Drive folder and starts when a new file is added
  • Checks the file type and only runs for CSV files
  • Downloads the file and extracts rows from the CSV
  • Creates a new Google Sheet and appends the lead data
  • Moves the new sheet to a chosen Google Drive folder
  • Copies a Google Slides template for each lead
  • Replaces placeholder text in the deck with lead fields like company and name
  • Writes the new presentation ID back to the matching row in the sheet

What are the benefits?

  • Reduce manual slide creation from hours to minutes per upload
  • Automate most of the deck editing by replacing placeholders with lead data
  • Improve data accuracy by pulling directly from the CSV and the sheet
  • Connect Google Drive, Google Sheets and Google Slides in one flow
  • Handle hundreds of leads in one upload with consistent branding
  • Track outputs by writing each presentation ID back into the lead list

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Drive, Google Sheets and Google Slides. See the Tools Required section above for links to create accounts with these services.
  3. Open the Google Drive Trigger node. In the Credential to connect with dropdown, click Create new credential. Follow the on screen steps to connect your Google account. Choose the specific folder to watch and set the polling to every minute.
  4. Double click the Google Sheets nodes (Create new Sheet, Merge Data, Get all Leads, Add Presentation ID to Lead List). In each one, create a new Google Sheets credential and authorize your Google account.
  5. Open the Google Slides node Create Custom Presentation. Create a new Google Slides credential and authorize your account.
  6. In the Switch node named File Type, confirm the rule checks for CSV. If your uploads use a different MIME type, adjust the condition so it matches your files.
  7. Open Extract Information from CSV file and verify delimiter, header row, and character encoding match your CSV. Use a small sample to test parsing.
  8. In Create new Sheet, review the title format and sheet name. Keep the timezone or change it to match your region if needed.
  9. In Merge Data for new Lead Document, map the columns to match your CSV headers like First Name, Last Name, Email and Company. Enable append so rows are added below the header.
  10. Open MoveToLeadListFolder and set the target folder ID where you want the new sheet to live. Make sure your Google account has access to that folder.
  11. Open Copy Presentation Template and set the template file ID of your Google Slides deck. The template must contain placeholder text such as {COMPANYNAME}, {Full Name} and {Email}.
  12. In Create Custom Presentation, verify the replace text pairs match your template placeholders and the column names in the sheet. Edit or add tokens as needed.
  13. In Add Presentation ID to Lead List, confirm the matching key is Email so the update writes the presentation ID back to the correct row.
  14. Test the flow by uploading a sample CSV to the watched Google Drive folder. Check that a new Google Sheet appears, slides are created for each row, and the PresentationID column is filled. If replacements fail, check placeholder spelling and sheet headers. If nothing runs, confirm the folder ID and CSV file type.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Drive

Sign up

Drive API: $0 (no additional cost; quota-limited)

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Google Slides

Sign up

Free: $0, no usage-based charges for Google Slides API; quotas apply

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.