Run a personalized 3-email onboarding drip with Google Gemini and Gmail

Go to Workflow
0 views
Built by Oka Hironobu Oka Hironobu
Created on August 04, 2026

Description

Quick Overview
This workflow collects signups via an n8n form, logs them to Google Sheets, and uses Google Gemini to generate a 3-part personalized onboarding email drip sent through Gmail over five days.

How it works
Receives a new signup submission from an n8n Form trigger with the user’s name, email, role, and goal.
Adds product and sender context to the signup data and appends the signup to a Google Sheets worksheet.
Uses Google Gemini to draft a short personalized welcome email and sends it immediately via Gmail.
Waits 2 days, then uses Google Gemini to write a tips-focused onboarding email and sends it via Gmail.
Waits 3 more days, then uses Google Gemini to write a final check-in email that invites a reply and sends it via Gmail.

Setup
Add credentials for the Google Gemini (PaLM) API, Gmail OAuth2, and Google Sheets OAuth2.
Select the target Google Sheets spreadsheet and the “Signups” sheet (or update the sheet name) where new submissions should be appended.
Update the product name, product value, and sender name values to match your product in the product context step.
Publish the n8n form and share/embed it where users sign up, and confirm Gmail is allowed to send to external recipients.
Adjust the two Wait durations (2 days and 3 days) to match your desired onboarding cadence.

Nodes Used (4)

Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm
Gmail
n8n-nodes-base.gmail
Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
Google Sheets
n8n-nodes-base.googleSheets