Zum Inhalt springen
NEUMarktplatz und dein Team: Verkaufe, was du baust, und bekomm Pläne und Änderungen, die getestet sind, bevor du sie siehst. Neuigkeiten ansehen

Bibliothek / Formulare & Umfragen

Formulare & Umfragen

Angebotsanfragen in Google Sheets validieren und per Gmail benachrichtigen

Wird bei jeder Absendung des Angebotsformulars ausgeführt, prüft die für ein Angebot nötigen Angaben, speichert die Anfrage in Google Sheets als ready_to_quote oder missing_info und sendet dann E-Mails an den Inhaber und den Kunden.

Was sie bewirkt

## 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.

Die Schritte

  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

Ähnliche Automatisierungen