n8n Lead Magnet Email Automation: OpenAI + Gmail + Drive

Turn every lead-magnet download into an instant, personalized follow-up

This n8n workflow automatically captures a lead magnet request via webhook, logs the requester in Google Sheets, uses OpenAI to write a short thank-you email, attaches your file from Google Drive, and sends it instantly through Gmail.

What this workflow does

• Receives a download request via webhook with the requester email in the query string (e.g., ?email=address@example.com).
• Logs or updates the lead in a Google Sheet: appends or updates a matching row in the “Downloads” tab with the latest download timestamp (“Last Download”).
• Generates a thank-you email using an OpenAI chat model, producing a subject and body that thanks the requester, includes tips, and references the attached resource.
• Downloads the lead magnet file from Google Drive using your provided file URL.
• Sends the email with the attachment to the requester using Gmail.

Use cases

• SaaS landing pages that offer a PDF/guide—deliver the file and send a branded thank-you email automatically.
• Lead capture forms where you want accurate download tracking in Google Sheets for follow-up campaigns.
• Automation engineers building a reliable lead magnet delivery system using n8n, OpenAI, Gmail, Google Drive, and Google Sheets.

Technical details

• Integrations/credentials required: Google Sheets, Google Drive, Gmail, and OpenAI.
• Nodes used: webhook, google sheets, set, google drive, gmail, and an OpenAI-powered email generation step (with a prompt you can update).

Setup note: Create a “Downloads” sheet with columns “Email Address” and “Last Download”, paste your spreadsheet URL, provide your Drive file URL, update the email prompt with your resource details, then use the generated webhook URL on your site/form.