Kütüphane / Formlar ve Anketler
Formlar ve Anketler
Teklif taleplerini Google Sheets'e doğrula ve Gmail ile bildir
Her teklif talebi formu gönderildiğinde çalışır, teklif için gereken bilgileri kontrol eder, talebi Google Sheets'te ready_to_quote veya missing_info olarak kaydeder, ardından sahibine ve müşteriye e-posta gönderir.
Ne yapar
## 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.
Adımlar
- 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
Benzer otomasyonlar
Formlar ve AnketlerTally Teklif Taleplerini Airtable, Slack ve Gmail'e Kaydetme6 adımFormlar ve AnketlerClassify procurement spend in Google Sheets with Gemini and Gmail31 adımFormlar ve Anketlern8n form girişlerini Sheets, Airtable ve Gmail'e kaydetme9 adımFormlar ve AnketlerGmail onayıyla formdan randevu alma23 adım