Kütüphane / Takvim ve Zamanlama
Takvim ve Zamanlama
Google Sheets'teki kabul edilen teklifleri Calendar'a randevu olarak ekle ve Gmail hatırlatmaları gönder
Her 15 dakikada bir Google Sheets'te kabul edilen teklifleri kontrol eder, müşterilere randevu bağlantılarını e-postayla gönderir, planlanan işleri Google Calendar'a yazar ve yarınki işler için her gün Gmail hatırlatmaları gönderir.
Ne yapar
## 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.
Adımlar
- Every 15 minutes
- Booking form
- Every morning
- Settings
- Which step?
- Find accepted quotes
- Build booking link
- Send booking link
- Mark link sent
- Find the quote
- Check the link
- Link valid?
- Busy times
- Find free times
Toplam 32 adım.
Benzer otomasyonlar
Takvim ve ZamanlamaSend meeting confirmations and reminders from Google Calendar with HubSpot and Gmail9 adımTakvim ve ZamanlamaEn son Google Sheets satırından Google Calendar etkinlikleri oluştur4 adımTakvim ve ZamanlamaBook and manage LINE OA appointments with OpenAI, Google Calendar and Sheets40 adımTakvim ve ZamanlamaBook, cancel, and reschedule WhatsApp appointments with Google Calendar and Sheets49 adım