Book accepted quotes from Google Sheets into Calendar and send Gmail reminders

## 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.