Quick Overview This workflow runs daily to read open quotes from Google Sheets, calculates how many days have passed since each quote was sent, and sends the appropriate 3-, 7-, or 14-day follow-up email via Gmail, then writes a sent date back to the sheet to prevent duplicates. How it works Runs every day at 9am on a schedule trigger. Loads your business details, follow-up day offsets, and email subject/body templates from a preset configuration. Reads all quote rows from a Google Sheets spreadsheet. Keeps only quotes with status set to open, calculates days since sent_date, and selects the next due follow-up (day 3, 7, or 14) that has not been sent yet. Sends a plain-text follow-up email through Gmail to each due quote’s customer using the filled template. Updates the matching Google Sheets row (by quote_id) to stamp the corresponding followup_1, followup_2, or followup_3 column with today’s date. Setup Add Google Sheets credentials, select the target spreadsheet and sheet in both Google Sheets steps (read and update). Add Gmail credentials for the mailbox you want to send follow-ups from.
Tags
Gmail
Google SheetsRelated workflows
See all Gmail→WRoute real estate buyer and seller leads with Claude and Google Sheets
Quick Overview This workflow hosts an n8n lead-capture form, uses Anthropic Claude to score and classify real estate inquiries, then routes ready leads to Gmail and Google Sheets while logging early-stage leads to a separate Google Sheets tab. How it works Receives a new submission from an n8n Form trigger with contact details, intent, area, budget, timeline, financing status, and notes. Normalizes the submitted fields (for example trimming strings, lowercasing email, and adding a timestamp) for consistent downstream processing. Sends the normalized lead details to the Anthropic Messages API (Claude) to return a strict JSON classification, summary, timeline band, financing readiness, recommended agent role, and score. Parses the Claude JSON response, clamps the score to a 1–10 range, and calculates whether the lead is “ready” (score 7). If the lead is ready, sends a formatted Gmail alert to the agent and appends the lead to the “Active Leads” tab in Google Sheets. If the lead is not ready, appends the lead to the “Nurture Leads” tab in Google Sheets. Returns a confirmation message to the form submitter after the lead is routed. Setup Create an Anthropic HTTP Header Auth credential
Capture real estate leads with Google Sheets, Gmail, and Slack
Quick Overview This workflow captures real estate property inquiries via a webhook, saves the lead to Google Sheets, sends an auto-reply email through Gmail, and posts a notification to a Slack channel before returning a JSON confirmation to the website. How it works Receives a POST request from your website form through a webhook endpoint. Extracts and standardizes the lead details (name, email, phone, property ID, and message) from the incoming request. Appends the inquiry details to a Google Sheets CRM spreadsheet. Sends an acknowledgement email to the prospect using Gmail with the referenced property details. Posts a new-lead alert to your agent team in Slack. Returns a JSON response (for example, { "status": "received" }) to confirm the submission was accepted. Setup Connect Google Sheets OAuth credentials and update the target spreadsheet and sheet tab used to store new leads. Connect Gmail OAuth credentials and customize the subject/body of the auto-reply message. Connect Slack OAuth credentials and choose the channel where agent notifications should be posted. Copy the webhook URL from the webhook trigger and configure your website inquiry form to send a POST request with n
Send appointment reminders from Google Sheets via Gmail and Slack
Quick Overview This workflow runs daily at 9:00, reads appointments from Google Sheets, emails next-day patients reminders via Gmail, and posts a reminder count to a Slack channel. How it works Runs every day at 9:00 using a schedule trigger. Reads all appointment rows from a specified Google Sheets worksheet. Filters the rows to keep only appointments whose Date matches tomorrow’s ISO date (YYYY-MM-DD). Sends a personalized reminder email for each remaining appointment using Gmail. Counts how many reminders are sent and generates a summary payload for tomorrow’s date. Posts the reminder count summary to a selected Slack channel. Setup Connect Google Sheets OAuth and set the target spreadsheet and sheet, ensuring columns like Patient, Email, Date, and Time exist. Ensure the Date values in Google Sheets are stored in a format compatible with the filter logic (ISO-style YYYY-MM-DD at the start of the field). Connect Gmail OAuth and update the sender account, subject, and message text as needed. Connect Slack OAuth and select the channel where the front desk summary should be posted.