Перейти к содержанию
НОВОЕМаркетплейс и trig8n Agent: продавайте то, что создали, и получайте планы и изменения, проверенные до того, как вы их увидите. Что нового

Библиотека / Календарь и планирование

Календарь и планирование

Запись принятых коммерческих предложений из Google Sheets в Календарь и отправка напоминаний через Gmail

Каждые 15 минут проверяет Google Sheets на наличие принятых предложений, отправляет клиентам по email ссылки для бронирования, записывает забронированные работы в Google Календарь и ежедневно отправляет напоминания о завтрашних работах через Gmail.

Что делает

## Book jobs in Google Calendar from accepted quotes in Google Sheets For service businesses that track quotes in Google Sheets and jobs in Google Calendar. ### How it works 1. You set a quote's status to accepted in the sheet. Within 15 minutes the customer gets a personal booking link. 2. The customer books one of the free times in your calendar. The job goes to Google Calendar and the row to scheduled. 3. Every morning, customers with a job tomorrow get a reminder. To change a date, move the event in Calendar and update job_start. The reminder reads the sheet. ### Setup 1. Use the sheet described in the Sheet note. 2. Pick your Google credential in each Google node. 3. Paste your sheet URL in Document in all six Google Sheets nodes: Find accepted quotes, Mark link sent, Find the quote, Read the row again, Mark scheduled, Find scheduled jobs. 4. Edit Settings. Set Workflow settings > Timezone to the zone in timezone. 5. Open Booking form, copy its Production URL (it ends in /form/book-job) and paste it in Settings > booking_form_url. Then activate. 6. Test: add a row with your own email, set status to accepted and wait up to 15 minutes. Do not share the Booking form URL: each customer gets a personal link by email. If nothing happens, check Executions. ### Requirements - Google Sheets, Calendar and Gmail credentials in n8n: docs.n8n.io/integrations/builtin/credentials/google/. If your Google Cloud app is External and in Testing, the connection expires after 7 days; publish it to avoid this. - The form path book-job must be free. Change it in Booking form if another workflow uses it. Our paid template follows up Gmail quotes and tells you when the customer says yes: https://payhip.com/b/OyN5V One person is behind Small Hours. AI agents built and tested this template.

Шаги

  1. Every 15 minutes
  2. Booking form
  3. Every morning
  4. Settings
  5. Which step?
  6. Find accepted quotes
  7. Build booking link
  8. Send booking link
  9. Mark link sent
  10. Find the quote
  11. Check the link
  12. Link valid?
  13. Busy times
  14. Find free times

Всего шагов: 32.

Похожие автоматизации