Nurture real estate leads with Google Gemini, Gmail, and Google Sheets

Quick overview This workflow adds real-estate leads to a 5-touch Gmail drip campaign, uses Google Gemini to generate and classify all five emails upfront, sends them automatically on schedule, detects replies and stops the sequence instantly, and delivers a morning digest of all active. How it works 1. Receives a new lead via a webhook request (or an optional Google Sheets row-added trigger) and normalizes the lead and property fields into a consistent format. 2. Uses Google Gemini to pre-generate five personalized email subjects and bodies based on the lead, property address, and agent details. 3. Creates a new sequence row in Google Sheets (Active Sequences) with the generated email content and sends Touch 1 via Gmail, then applies a Gmail label and stores the Gmail thread ID back in the sheet. 4. Waits the configured number of days between touches, checks the current sequence status in Google Sheets, and sends Touches 2–5 via Gmail only if the sequence is still active, updating the sheet and applying the Gmail label after each send. 5. Monitors Gmail for replies on the labeled threads, fetches the full thread from the Gmail API, and extracts the latest reply text. 6. Uses Google Gemini to classify the reply sentiment (Hot, Neutral, or Unsubscribe), matches the reply to the active sequence (by thread ID or sender email), updates the sequence as Responded in Google Sheets, emails the agent a notification, and logs the event to a Sequence Log sheet. 7. Runs daily on a schedule to pull all sequences from Google Sheets, builds an HTML digest of active and responded sequences, emails it to the agent via Gmail, and logs the digest to a Daily Digest Log sheet. Setup 1. Create and connect credentials for Gmail OAuth2, Google Sheets OAuth2, and a Google Gemini (PaLM) API key. 2. Create a Gmail label (for example, "drip-sequence") and update the workflow’s label configuration to match the label used by the Gmail trigger and label-applying steps. 3. Create a Google Sheets spreadsheet with tabs/columns matching the workflow outputs (Active Sequences, Sequence Log, and Daily Digest Log) and fill in the target Spreadsheet ID and sheet/tab references in all Google Sheets steps. 4. Update the agent configuration values (agent name, agent email, and the touch timing offsets) in the sequence configuration sections, and set the agent notification recipient email in the reply notification email. 5. If using the webhook entry point, copy the production webhook URL and configure your lead source to POST leadName/leadEmail/propertyAddress (and optional property details) to that endpoint. Requirements - Gmail label setup (required before first use): Create a label named drip-sequence in Gmail before activating. Go to Gmail → Settings → See all settings → Labels → Create new label → name it drip-sequence. This label is applied to every outgoing sequence email so incoming replies are detectable by the Gmail Trigger. The label name must exactly match the GMAILLABEL value in the Configuration node. - Google Sheets setup: Create a Drip Campaign Manager sheet template and link its ID to all Sheets nodes. Three tabs are required. Tab 1 — Active Sequences — with these columns: Sequence ID, Lead Name, Email, Phone, Property Address, Property URL, Property Description, Lead Background, Touch 1 Subject, Touch 1 Body, Touch 2 Subject, Touch 2 Body, Touch 3 Subject, Touch 3 Body, Touch 4 Subject, Touch 4 Body, Touch 5 Subject, Touch 5 Body, Current Touch, Status, Start Date, Last Touch Date, Thread ID, Reply Received, Reply Sentiment, Agent Notified, Sequence Label. Tab 2 — Sequence Log — with columns: Date, Sequence ID, Lead Name, Touch Number, Email Subject, Status, Notes. Tab 3 — Daily Digest Log — with columns: Digest Date, Active Count, Completed Count, Responses Today, Digest Sent. - Before going live: Update AGENTNAME and AGENTEMAIL in the Section A Configuration node. Update AGENTEMAIL in the Section C Daily Digest Configuration node — keep both in sync