See llms.txt for all machine-readable content.

Back to Templates

Follow up on open quotes with OpenRouter, Gmail and Google Sheets

Quick overview

This workflow logs sent quotes to Google Sheets via an n8n form, then checks open quotes daily to draft and send follow-up emails with OpenRouter and Gmail, updating the quote status and notifying the owner when a quote expires or an error occurs.

How it works

  1. Receives a quote submission from an n8n form and reads business settings from Google Sheets.
  2. Normalizes the quote fields, sets the quote to open, and appends the record to the Quotes sheet in Google Sheets.
  3. Sends an informational Gmail message to the business owner confirming the quote was logged (without emailing the customer).
  4. Runs every day at 09:00, reads settings and all quotes from Google Sheets, and selects open quotes that are due for a follow-up or should be expired based on time since sent/last contact and follow-up count.
  5. For quotes due for follow-up, uses OpenRouter to draft a short email (with a fallback if the draft is invalid) and sends it to the customer via Gmail.
  6. Updates the quote row in Google Sheets to increment the follow-up count and last contact timestamp, or marks the quote as expired and emails the owner when the quote reaches the expiry condition.
  7. If any sheet write, draft, or email step fails, logs the error to an Errors sheet in Google Sheets and emails the owner via Gmail.

Setup

  1. Create a Google Sheet with Quotes, Settings, and Errors tabs and add the required headers (including quote_id in Quotes, and business_name/owner_email/booking_url in Settings).
  2. Add and select Google Sheets credentials on all Google Sheets steps, and set the target spreadsheet (document) for the Settings, Quotes, and Errors operations.
  3. Add Gmail credentials for sending owner notifications and customer follow-ups, and confirm the owner_email value in the Settings sheet is correct.
  4. Add OpenRouter credentials (or API key) and choose an OpenRouter chat model for drafting follow-up emails.
  5. Use the n8n form URL for “Log a sent quote” with your team and verify your instance timezone matches the business timezone for the 09:00 daily check.