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
- Receives a quote submission from an n8n form and reads business settings from Google Sheets.
- Normalizes the quote fields, sets the quote to open, and appends the record to the Quotes sheet in Google Sheets.
- Sends an informational Gmail message to the business owner confirming the quote was logged (without emailing the customer).
- 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.
- 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.
- 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.
- 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
- 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).
- Add and select Google Sheets credentials on all Google Sheets steps, and set the target spreadsheet (document) for the Settings, Quotes, and Errors operations.
- Add Gmail credentials for sending owner notifications and customer follow-ups, and confirm the owner_email value in the Settings sheet is correct.
- Add OpenRouter credentials (or API key) and choose an OpenRouter chat model for drafting follow-up emails.
- 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.