Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Forms & Surveys

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

  1. Quote request form
  2. Settings
  3. Check what is missing
  4. Already received?
  5. New request?
  6. Save request
  7. Email the owner
  8. Anything missing?
  9. Ask for missing details
  10. Confirm request
  11. Thank-you page
  12. Duplicate page

Similar automations