January 21, 2026

Google Drive to Google Slides, decks filled from CSV

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Building “just a quick personalized deck” turns into a slow copy-paste marathon. One wrong company name on slide two, one missed metric, and suddenly you’re doing damage control instead of outreach.

Sales ops usually gets stuck cleaning the lead list. Demand gen needs the decks yesterday. And the agency team doing outbound for clients feels the same pressure. This CSV slides automation takes a CSV in Google Drive and produces a fresh Google Slides deck per lead, then logs the deck link back to Google Sheets.

Below, you’ll see exactly how the workflow runs, what it replaces, and where the real time savings show up once you’re doing this at volume.

How This Automation Works

See how this solves the problem:

n8n Workflow Template: Google Drive to Google Slides, decks filled from CSV

Click to explore

flowchart LR

    subgraph sg0["Lead File Flow"]
        direction LR
        n0@{ icon: "mdi:cog", form: "rounded", label: "Retrieve File by ID", pos: "b", h: 48 }
        n1@{ icon: "mdi:cog", form: "rounded", label: "Relocate Lead Sheet", pos: "b", h: 48 }
        n2@{ icon: "mdi:database", form: "rounded", label: "Update Lead with Deck ID", pos: "b", h: 48 }
        n3@{ icon: "mdi:database", form: "rounded", label: "Fetch Lead List", pos: "b", h: 48 }
        n4@{ icon: "mdi:database", form: "rounded", label: "Generate Lead Sheet", pos: "b", h: 48 }
        n5@{ icon: "mdi:database", form: "rounded", label: "Append Lead Records", pos: "b", h: 48 }
        n6@{ icon: "mdi:play-circle", form: "rounded", label: "Lead File Trigger", pos: "b", h: 48 }
        n7@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Route by File Format", pos: "b", h: 48 }
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge Sheet with CSV"]
        n9@{ icon: "mdi:cog", form: "rounded", label: "Personalize Slide Deck", pos: "b", h: 48 }
        n10@{ icon: "mdi:cog", form: "rounded", label: "Parse CSV Content", pos: "b", h: 48 }
        n11@{ icon: "mdi:cog", form: "rounded", label: "Duplicate Slide Template", pos: "b", h: 48 }
        n7 --> n0
        n3 --> n1
        n0 --> n10
        n0 --> n4
        n4 --> n8
        n6 --> n7
        n1 --> n11
        n11 --> n9
        n9 --> n2
        n5 --> n3
        n10 --> n8
        n8 --> n5
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n6 trigger
    class n7 decision
    class n2,n3,n4,n5 database
    classDef customIcon fill:none,stroke:none
    class n8 customIcon

The Challenge: Personalizing Slide Decks at Scale Without Errors

If you’ve ever personalized decks from a lead list, you know the trap. The first few are fine. Then you’re juggling a CSV, a Slides template, a naming convention, a folder structure, and a “where did we put the link?” spreadsheet that’s never updated consistently. It’s not just slow. It’s mentally exhausting, because every deck is a chance to mix up names, paste the wrong stat, or forget to update the doc link before you move on.

It adds up fast. Here’s where it breaks down once you move beyond a handful of prospects.

Copying a master deck for every lead turns into an hour-long task the moment you have a decent list.
Placeholder replacement is easy to mess up when you’re switching tabs, especially when two companies have similar names.
Links to finished decks end up scattered across Slack messages, emails, and half-updated spreadsheets.
Manual processes don’t leave an audit trail, so you can’t quickly answer “Which leads already got a deck?”

The Fix: Auto-Generate a Deck Per CSV Row (and Log Every Link)

This workflow watches a specific Google Drive folder for new lead CSV uploads. When a new file arrives, it checks that it’s actually a .csv (so you don’t accidentally trigger on random attachments), downloads it, and parses the rows into structured lead data. Next, it creates a fresh Google Sheet to act as the run log and source-of-truth for that batch, then writes the CSV rows into the sheet so you have clean columns to map against. From there, it loops through each lead, duplicates your master Google Slides template, replaces placeholders like {{Name}} and {{Company}} with that lead’s values, and finally writes the finished deck URL back into the sheet. The output is simple: one generated Slides deck per lead, plus a spreadsheet that shows exactly what was created and where it lives.

The workflow starts with a CSV landing in Drive. Google Sheets becomes the tracking layer and the data map. Google Slides does the personalization work on a copied template, and the final deck link gets written back to the lead row so nothing gets lost.

What Changes: Before vs. After

What This Eliminates

Impact You’ll See

Manually copying a Slides template for every single prospect.
Copy-pasting names, companies, and metrics into the wrong places.
Hunting for “the right link” after decks are generated.
Ad-hoc tracking that depends on someone remembering to update a sheet.

Generating 50 decks becomes a “drop the CSV” task, not an afternoon.
Your team gets a consistent spreadsheet log for each batch of leads.
Fewer embarrassing personalization mistakes because replacements are systematic.
Cleaner handoffs between marketing and sales, since the link is stored with the lead.
It’s much easier to scale outbound without hiring someone just to do deck grunt work.

Real-World Impact

Say you’re running a list of 40 leads and you want a personalized deck for each. Manually, a typical flow is: copy the template (2 minutes), replace fields (6 minutes), name and file it correctly (2 minutes), then log the link (2 minutes). That’s about 10 minutes per lead, or roughly 6 hours for the batch. With this workflow, you upload one CSV, then wait for processing while n8n generates decks and writes the URLs back to Google Sheets. Your “hands-on” time is closer to 10 minutes total.

Requirements

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Drive for CSV intake and deck storage
Google Sheets to log leads and deck URLs
Google Slides to duplicate and personalize decks

Skill level: Beginner. You’ll connect Google accounts, set a folder, and map a few placeholders to CSV column names.

Need help implementing this? Talk to an automation expert (free 15-minute consultation).

The Workflow Flow

A CSV hits your Drive folder. The Google Drive trigger monitors an “incoming leads” folder, then routes files through a quick file-type check so only .csv uploads continue.

The workflow turns the CSV into usable lead rows. n8n downloads the file by ID, extracts the CSV content, and merges it into a structured format that matches what Google Sheets and your Slides placeholders expect.

Google Sheets becomes the tracking spine. It creates a new sheet for that run, appends lead records, then fetches all rows so the workflow can iterate cleanly without missing anyone.

Slides are duplicated and personalized one lead at a time. For each row, the workflow copies your master Slides template in Drive, replaces tokens like {{Company}} with real values, then updates the corresponding sheet row with the final presentation URL.

You can easily modify which CSV columns map to which slide tokens based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Google Drive Trigger

Set up the workflow to start when a new lead file is created in a specific Google Drive folder.

Add and open Lead File Trigger.
Set Event to fileCreated and Trigger On to specificFolder.
Set Folder To Watch to the target lead upload folder (replace [YOUR_ID]).
Credential Required: Connect your googleDriveOAuth2Api credentials.

⚠️ Common Pitfall: If [YOUR_ID] isn’t replaced with a real folder ID, Lead File Trigger will never fire.

Step 2: Connect Google Drive and Google Sheets

Ensure all Google Drive and Google Sheets nodes are authorized for file download, sheet creation, and updates.

Open Retrieve File by ID and confirm Operation is download with File ID set to ={{ $json.id }}.
Credential Required: Connect your googleDriveOAuth2Api credentials for Retrieve File by ID, Relocate Lead Sheet, and Duplicate Slide Template.
Credential Required: Connect your googleSheetsOAuth2Api credentials for Generate Lead Sheet, Append Lead Records, Fetch Lead List, and Update Lead with Deck ID.
In Relocate Lead Sheet, set Folder ID to the destination folder (replace [YOUR_ID]).
In Duplicate Slide Template, set File ID and Folder ID to your template and output folder IDs (replace [YOUR_ID]).

Tip: Keep all Drive/Sheets credentials under the same Google account to avoid cross-permission issues when files are copied and moved.

Step 3: Set Up File Routing and Data Extraction

Route the uploaded lead file by MIME type, download it, then parse the CSV content for import.

Open Route by File Format and confirm rules compare Left Value ={{ $json.mimeType }} against text/csv and application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.
Verify Retrieve File by ID receives the trigger output from Route by File Format.
Open Parse CSV Content and set Encoding to utf-8, Delimiter to ,, and Header Row to true.
Retrieve File by ID outputs to both Parse CSV Content and Generate Lead Sheet in parallel.

Step 4: Create and Populate the Lead Sheet

Create a new Google Sheet, merge it with the parsed CSV, append records, then fetch the full lead list.

In Generate Lead Sheet, set Resource to spreadsheet and Title to =Leads_{{ $now.setZone('Europe/Berlin').toFormat('yyyy-dd-MM') }}.
In Merge Sheet with CSV, set Mode to chooseBranch and Use Data Of Input to 2.
In Append Lead Records, keep Operation set to append and Options → Use Append to true.
In Fetch Lead List, confirm Document ID is ={{ $('Generate Lead Sheet').first().json.spreadsheetId }} and Sheet Name is ={{ $('Generate Lead Sheet').first().json.sheets[0].properties.sheetId }}.
In Relocate Lead Sheet, set File ID to ={{ $('Generate Lead Sheet').first().json.spreadsheetId }} and select the destination folder.

Tip: The sheet title uses Berlin time. If you want local time, update Europe/Berlin in Generate Lead Sheet.

Step 5: Configure Slide Duplication and Personalization

Duplicate the slide template, replace placeholder text with lead details, and store the presentation ID back in the sheet.

In Duplicate Slide Template, set Operation to copy and Name to ={{ $('Fetch Lead List').item.json.Company }} X MYCOMPANYNAME_{{ $now.setZone('Europe/Berlin').toFormat('yyyy-dd-MM') }}.
Set Folder ID in Duplicate Slide Template to the output presentations folder (replace [YOUR_ID]).
In Personalize Slide Deck, set Operation to replaceText and Presentation ID to ={{ $json.id }}.
Confirm text replacements in Personalize Slide Deck use lead data: ={{ $('Fetch Lead List').item.json.Company }}, ={{ $('Fetch Lead List').item.json['Full Name'] }}, and ={{ $('Fetch Lead List').item.json['First Name'] }}.
In Update Lead with Deck ID, set Operation to update and map Email to ={{ $('Fetch Lead List').item.json.Email }} and PresentationID to ={{ $json.presentationId }}.
Credential Required: Connect your googleSlidesOAuth2Api credentials in Personalize Slide Deck.

⚠️ Common Pitfall: If the placeholders in your slide template don’t exactly match {COMPANYNAME}, {Testdurchgestrichen}, and {nichtdurchgestrichen}, the replacements won’t occur.

Step 6: Test and Activate Your Workflow

Run a manual test to confirm the file trigger, sheet creation, and slide personalization work end-to-end before turning it on.

Click Execute Workflow and upload a CSV file into the watched folder for Lead File Trigger.
Confirm a new sheet is created by Generate Lead Sheet and data is appended by Append Lead Records.
Verify a presentation is created by Duplicate Slide Template and text is replaced by Personalize Slide Deck.
Check that Update Lead with Deck ID writes the new PresentationID into the sheet.
Once successful, switch the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Watch Out For

Google Drive and Google Slides permissions can be picky. If deck copies fail or replacements don’t apply, check the Google connection inside n8n and confirm the account can edit the template and write to the target folder.
If you’re processing a big CSV, Google APIs can throttle you. Processing times vary, so add throttling (like SplitInBatches) or increase waits if downstream steps sometimes run before a copy is fully available.
Template tokens have to match your mapping exactly. If your deck uses {{CompanyName}} but your CSV header is Company, you’ll get blank fields and you won’t notice until someone opens the deck.

Common Questions

How quickly can I implement this CSV slides automation automation?

About 30 minutes if your Google accounts and template are ready.

Can non-technical teams implement this CSV slides automation?

Yes. No coding is required, but you do need to be comfortable mapping CSV column headers to slide placeholders.

Is n8n free to use for this CSV slides automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Google Workspace access if your team requires it.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

How do I adapt this CSV slides automation solution to my specific challenges?

You can change the mapping where the workflow merges CSV rows into the structure used for personalization (the “merge” stage) and in the Google Slides personalization step where tokens are replaced. Common tweaks include adding new variables (by adding CSV headers and matching placeholders in the template), changing how decks are named and filed in Drive, and writing extra fields back into Google Sheets like owner, segment, or campaign name.

Why is my Google Drive connection failing in this workflow?

Most of the time it’s expired OAuth access or the connected Google account losing permission to the folder or template. Reconnect the Google credential in n8n, then confirm the Drive folder ID and the Slides template are accessible to that same account. If your org uses shared drives, make sure the connection is allowed to access them.

What’s the capacity of this CSV slides automation solution?

If you self-host, there’s no fixed execution limit (it mainly depends on your server and Google API limits). On n8n Cloud, capacity depends on your plan’s monthly executions, and this workflow uses multiple steps per lead. Practically, most teams run batches of dozens to a few hundred leads smoothly, then add throttling if they go bigger.

Is this CSV slides automation automation better than using Zapier or Make?

Often, yes, because this kind of workflow needs branching, looping through rows, and more control over how data is merged into a template. n8n is also easier to self-host, which matters when you start generating lots of decks. Zapier or Make can still work for small batches, but you may hit complexity limits sooner than you expect. If your process includes enrichment, multiple templates, or approval steps, n8n usually stays cleaner. Talk to an automation expert if you want a quick recommendation based on your exact flow.

Once this is set up, “make 40 decks” becomes a background process instead of a calendar-blocking chore. The workflow handles the repetitive parts, and you keep your attention for the conversations that actually close deals.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"meta": {
"instanceId": "7270a977832ae748ad35fd7cf0b5c2598658a7e349d6a3a3272f6ed18b5b7a4e",
"templateCredsSetupCompleted": null,
"templateId": null
},
"name": "Automated Lead Presentation Builder",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-3890",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 860,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "4cc04b1c-d97d-4d5a-b614-ba22b7b447bd",
"name": "Retrieve File by ID",
"type": "n8n-nodes-base.googleDrive",
"position": [
250,
120
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": [],
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 3
},
{
"id": "8d550abf-a5f8-424d-8bfb-d9a9732eb93f",
"name": "Relocate Lead Sheet",
"type": "n8n-nodes-base.googleDrive",
"position": [
720,
530
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Generate Lead Sheet').first().json.spreadsheetId }}"
},
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"folderId": {
"__rl": true,
"mode": "id",
"value": "[YOUR_ID]"
},
"operation": "move"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 3
},
{
"id": "4872b5ec-6dda-4920-b6e2-120bdc273c00",
"name": "Update Lead with Deck ID",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
580
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $('Fetch Lead List').item.json.Email }}",
"PresentationID": "={{ $json.presentationId }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Full Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Full Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contact Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Contact Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Employees",
"type": "string",
"display": true,
"required": false,
"displayName": "Employees",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "State",
"type": "string",
"display": true,
"required": false,
"displayName": "State",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "City",
"type": "string",
"display": true,
"required": false,
"displayName": "City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PresentationID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PresentationID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keywords",
"type": "string",
"display": true,
"required": false,
"displayName": "Keywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
]
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('Generate Lead Sheet').first().json.sheets[0].properties.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Generate Lead Sheet').first().json.spreadsheetId }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "afe225e3-fb82-4091-8310-6645d883c54d",
"name": "Fetch Lead List",
"type": "n8n-nodes-base.googleSheets",
"position": [
760,
360
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('Generate Lead Sheet').first().json.sheets[0].properties.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Generate Lead Sheet').first().json.spreadsheetId }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "635c62cf-4369-442b-8fd7-be2e4caa6ebc",
"name": "Generate Lead Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
320
],
"parameters": {
"title": "=Leads_{{ $now.setZone('Europe/Berlin').toFormat('yyyy-dd-MM') }}",
"options": [],
"resource": "spreadsheet",
"sheetsUi": {
"sheetValues": [
{
"title": "sample_data"
}
]
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "d55c0f32-b74a-484a-b759-9ca1c4cf8d65",
"name": "Append Lead Records",
"type": "n8n-nodes-base.googleSheets",
"position": [
510,
310
],
"parameters": {
"columns": {
"value": [],
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Full Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Full Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contact Location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Contact Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Employees",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Employees",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "State",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "State",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "City",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keywords",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": []
},
"options": {
"useAppend": true
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('Generate Lead Sheet').first().json.sheets[0].properties.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Generate Lead Sheet').first().json.spreadsheetId }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "9d93741a-93b2-4556-9f2e-2d40617c69ac",
"name": "Lead File Trigger",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
760,
120
],
"parameters": {
"event": "fileCreated",
"options": [],
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "__cmath"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "174ff078-e06a-47c3-93c2-441667e0f8e5",
"name": "Route by File Format",
"type": "n8n-nodes-base.switch",
"position": [
500,
160
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "csv",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.mimeType }}",
"rightValue": "text/csv"
}
]
},
"renameOutput": true
},
{
"outputKey": "xlsx",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c2f2fb50-a750-4870-aff7-11df142a9be5",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.mimeType }}",
"rightValue": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
}
]
},
"renameOutput": true
}
]
},
"options": []
},
"typeVersion": 3.2
},
{
"id": "23d71fb1-c8f2-4144-a40e-be378aa2043a",
"name": "Merge Sheet with CSV",
"type": "n8n-nodes-base.merge",
"position": [
260,
360
],
"parameters": {
"mode": "chooseBranch",
"useDataOfInput": 2
},
"typeVersion": 3
},
{
"id": "195d7ed6-7dc0-4f49-8256-f47b4c8d426b",
"name": "Personalize Slide Deck",
"type": "n8n-nodes-base.googleSlides",
"position": [
240,
530
],
"parameters": {
"textUi": {
"textValues": [
{
"text": "{COMPANYNAME}",
"replaceText": "={{ $('Fetch Lead List').item.json.Company }}"
},
{
"text": "{Testdurchgestrichen}",
"replaceText": "={{ $('Fetch Lead List').item.json['Full Name'] }}"
},
{
"text": "{nichtdurchgestrichen}",
"replaceText": "={{ $('Fetch Lead List').item.json['First Name'] }}"
}
]
},
"options": [],
"operation": "replaceText",
"presentationId": "={{ $json.id }}"
},
"credentials": {
"googleSlidesOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2
},
{
"id": "9dd9e32a-5c1b-4faf-8054-63b66f5dd24e",
"name": "Parse CSV Content",
"type": "n8n-nodes-base.extractFromFile",
"position": [
10,
160
],
"parameters": {
"options": {
"encoding": "utf-8",
"delimiter": ",",
"headerRow": true
}
},
"typeVersion": 1
},
{
"id": "0329eabe-dee1-41fd-a7eb-017343523e40",
"name": "Duplicate Slide Template",
"type": "n8n-nodes-base.googleDrive",
"position": [
480,
580
],
"parameters": {
"name": "={{ $('Fetch Lead List').item.json.Company }} X MYCOMPANYNAME_{{ $now.setZone('Europe/Berlin').toFormat('yyyy-dd-MM') }}",
"fileId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Stardawn Updated"
},
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": [],
"folderId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Custom Presentations"
},
"operation": "copy",
"sameFolder": false
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 3
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Route by File Format": {
"main": [
[
{
"node": "Retrieve File by ID",
"type": "main",
"index": 0
}
]
]
},
"Fetch Lead List": {
"main": [
[
{
"node": "Relocate Lead Sheet",
"type": "main",
"index": 0
}
]
]
},
"Retrieve File by ID": {
"main": [
[
{
"node": "Parse CSV Content",
"type": "main",
"index": 0
},
{
"node": "Generate Lead Sheet",
"type": "main",
"index": 0
}
]
]
},
"Generate Lead Sheet": {
"main": [
[
{
"node": "Merge Sheet with CSV",
"type": "main",
"index": 0
}
]
]
},
"Lead File Trigger": {
"main": [
[
{
"node": "Route by File Format",
"type": "main",
"index": 0
}
]
]
},
"Relocate Lead Sheet": {
"main": [
[
{
"node": "Duplicate Slide Template",
"type": "main",
"index": 0
}
]
]
},
"Duplicate Slide Template": {
"main": [
[
{
"node": "Personalize Slide Deck",
"type": "main",
"index": 0
}
]
]
},
"Personalize Slide Deck": {
"main": [
[
{
"node": "Update Lead with Deck ID",
"type": "main",
"index": 0
}
]
]
},
"Append Lead Records": {
"main": [
[
{
"node": "Fetch Lead List",
"type": "main",
"index": 0
}
]
]
},
"Parse CSV Content": {
"main": [
[
{
"node": "Merge Sheet with CSV",
"type": "main",
"index": 1
}
]
]
},
"Merge Sheet with CSV": {
"main": [
[
{
"node": "Append Lead Records",
"type": "main",
"index": 0
}
]
]
}
}
}