Формы и опросы
Валидация запросов на расчёт в Google Sheets и уведомления через Gmail
Запускается при каждой отправке формы запроса на расчёт, проверяет данные, необходимые для расчёта, сохраняет запрос в Google Sheets со статусом ready_to_quote или missing_info, затем отправляет письма владельцу и клиенту.
Что делает
## 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.
Шаги
- 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
Похожие автоматизации
Формы и опросыЗапись запросов коммерческих предложений Tally в Airtable, Slack и GmailШагов: 6Формы и опросыClassify procurement spend in Google Sheets with Gemini and GmailШагов: 31Формы и опросыСохранение записей формы n8n в Sheets, Airtable и GmailШагов: 9Формы и опросыЗапись на приём из формы с подтверждением через GmailШагов: 23