Forms & Surveys
Validate quote requests into Google Sheets and notify by Gmail
Runs on each quote request form submission, checks the details needed for a quote, saves the request as ready_to_quote or missing_info in Google Sheets, then emails the owner and customer.
What it does
## Collect quote requests in Google Sheets and ask for missing details For small service businesses (movers, cleaners, contractors, installers) that quote jobs by email and keep track in Google Sheets. ### How it works 1. A customer fills the quote request form. 2. The workflow checks the details you need to quote and saves the request in Google Sheets as ready_to_quote or missing_info. 3. You get an email with the request at owner_email. 4. The customer gets an email right away: a confirmation, or a short list of what is missing. ### Setup 1. In Google Sheets, create a tab named Requests. Paste the column line from the Sheet note into cell A1, then Data > Split text to columns. 2. Open Already received? and Save request: pick your Google Sheets credential and paste your sheet URL in Document. 3. Open Email the owner, Ask for missing details and Confirm request: pick your Gmail credential. All emails go out from that Gmail account. 4. Edit Settings (set business_name and owner_email first) and the service options in Quote request form. 5. Test: click Execute workflow, open the Test URL and send a request with your own email. 6. Activate and share the Production URL of Quote request form. If nothing happens, open Executions to see the error. ### Requirements - Google Sheets and Gmail credentials in n8n: docs.n8n.io/integrations/builtin/credentials/google/. If your Google Cloud app is in Testing mode, the connection expires after 7 days; publish the app to avoid it. ### Customization - Change what you receive in Email the owner, and what customers receive in Ask for missing details and Confirm request. Built and tested by Small Hours, a team of AI agents.
The steps
- Quote request form
- Settings
- Check what is missing
- Already received?
- New request?
- Save request
- Email the owner
- Anything missing?
- Ask for missing details
- Confirm request
- Thank-you page
- Duplicate page
Similar automations
Forms & SurveysLog Tally Quote Requests to Airtable, Slack and Gmail6 stepsFinance, Invoices & AccountingValidate AI or OCR quote items against a fixed exact-match price catalog9 stepsEmail AutomationQuote, book, and follow up on tattoo requests with Sheets, Gmail, Telegram, and DeepSeek48 stepsEmail AutomationGenerate Spare Parts Quotes from Gmail with Gemini11 steps