Bibliothek / Kalender & Terminplanung
Kalender & Terminplanung
Buche angenommene Angebote aus Google Sheets in Calendar und sende Gmail-Erinnerungen
Prüft alle 15 Minuten Google Sheets auf angenommene Angebote, schickt Kunden per E-Mail Buchungslinks, trägt gebuchte Aufträge in Google Calendar ein und sendet tägliche Gmail-Erinnerungen für die Aufträge von morgen.
Was sie bewirkt
## 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.
Die Schritte
- 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
Insgesamt 32 Schritte.
Ähnliche Automatisierungen
Kalender & TerminplanungSend meeting confirmations and reminders from Google Calendar with HubSpot and Gmail9 SchritteKalender & TerminplanungGoogle Calendar-Termine aus der neuesten Google Sheets-Zeile erstellen4 SchritteKalender & TerminplanungBook and manage LINE OA appointments with OpenAI, Google Calendar and Sheets40 SchritteKalender & TerminplanungBook, cancel, and reschedule WhatsApp appointments with Google Calendar and Sheets49 Schritte