Quick overview
Quick overview This workflow watches a Google Form response sheet in Google Sheets, finds the next available working-hours slot in Google Calendar, creates a held discovery-call event, and emails the client a confirmation link via Gmail, then sends timed reminders until the invite is accepted . How it works Triggers when a new row is added to the Google Sheets worksheet that stores Google Form responses. Normalizes the submission fields (name, email, company, and goal) and loads scheduling rules like work hours, lead time, and reminder limits. Reads upcoming events from Google Calendar and selects the first free weekday time slot within the configured working hours. Creates a “hold” discovery call event in Google Calendar with a Google Meet link and adds the client as an attendee without sending Google’s default invite email. Updates the client’s row in Google Sheets with the held slot, event ID, booking link, and an “invited” booking status, then sends a branded Gmail invitation containing the Google Calendar confirmation link. Waits for the configured interval, checks the attendee RSVP status on the Google Calendar event, and if accepted or tentative logs “booked” in Google Sheets and sends a Gmail confirmation email. If the invite is not accepted, sends escalating Gmail reminders and logs them to Google Sheets until the maximum reminder count is exceeded, then marks “no response” and emails an internal alert to the host. Setup Connect Google Sheets, Google Calendar, and Gmail credentials (OAuth2) for the trigger, calendar operations, and email sends. Ensure your Google Form writes to a Google Sheet, then add these columns to that sheet: Booking Status, Calendar Event ID, Booking Link, Held Slot, Reminders Sent, Last Contacted, and Booked At. Select the correct Google Sheets document and sheet in the trigger and set the spreadsheet ID, sheet name, calendar ID, host name, company name, and internal alert email in the workflow settings values. Update the field mappings in the client-record step so the column names match your specific Google Form questions (especially name and email). Set your n8n workflow timezone appropriately, since the slot finder uses the instance timezone for working-hours calculations. An n8n automation workflow template by Muhammad Hanan.
Muhammad Hanan
web
free
Others in the same category, ranked by how often they are opened.
