Send 3-7-14 day quote follow-up emails with Gmail and Google Sheets
n8n template #16975Summary
Use templateQuick 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 sentdate, 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 th
Hand off to your agent
Prompt
Help me set up the n8n workflow "Send 3-7-14 day quote follow-up emails with Gmail and Google Sheets" (https://n8n.io/workflows/16975). It uses: Google Sheets, Gmail, Code. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Similar workflows
NameViews
- Create & Upload AI-Generated ASMR YouTube Shorts with Seedance, Fal AI, and GPT-424K
- Gmail campaign sender: Bulk-send emails and follow up automatically if no reply21K
- AI Timesheet Generator with Gmail, Calendar & GitHub to Google Sheets20K
- Send a ChatGPT email reply and save responses to Google Sheets17K
- Send multiple emails in Gmail directly via Google Sheets9,820
- Lead Workflow: Yelp & Trustpilot Scraping + OpenAI Analysis via BrightData7,460
- 3D Product Video Generator from 2D Image for E-Commerce Stores6,543
- AI YouTube Analytics Agent: Comment Analyzer & Insights Reporter6,404