{"product_id":"n8n-workflow-reconcile-google-calendar-demo-attendees-with-hubspot","title":"n8n Workflow: Reconcile Google Calendar Demo Attendees with HubSpot","description":"\u003ch3\u003eReconcile Google Calendar demo attendees with HubSpot—catch handoff gaps before meetings\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically reconciles attendees from a dedicated Google Calendar “demo” schedule against exact, active contacts and owners in HubSpot, queues exceptions in Google Sheets, and sends a single Slack digest for review—so your sales ops team fixes demo handoff issues before they become missed follow-ups.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns each weekday morning\u003c\/strong\u003e and scans your dedicated demo calendar.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters out irrelevant bookings\u003c\/strong\u003e by excluding canceled events, declined attendees, internal domains, and bookings still within the grace period.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads HubSpot active owners\u003c\/strong\u003e using bounded pagination; if responses are incomplete, the report stops instead of implying readiness.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches attendees to HubSpot contacts by exact primary email\u003c\/strong\u003e in paced requests, distinguishing \u003cem\u003eno match\u003c\/em\u003e from \u003cem\u003eambiguous matches\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates ownership\u003c\/strong\u003e: checks whether the matched contact has an assigned owner and whether that owner is present in the active owner directory—without guessing alternate emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates a Google Sheets review queue\u003c\/strong\u003e using a stable \u003cem\u003eevent-and-attendee key\u003c\/em\u003e, recording status, evidence, and a recommended action.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends one bounded Slack exception digest\u003c\/strong\u003e (with calendar + queue links) after the sheet succeeds; healthy checks are recorded without alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePrevent demos from falling through when attendee records aren’t present in HubSpot or ownership isn’t assigned.\u003c\/li\u003e\n  \u003cli\u003eDetect owner mismatches (inactive\/missing owners) after sales territory or routing changes.\u003c\/li\u003e\n  \u003cli\u003eMaintain a daily, auditable review queue in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for sales operations triage.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e set, code, http request, slack, sticky note, google sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Calendar (OAuth2), HubSpot (App Token with \u003cem\u003ecrm.objects.contacts.read\u003c\/em\u003e and \u003cem\u003ecrm.objects.owners.read\u003c\/em\u003e), Google Sheets (OAuth2), Slack (\u003cem\u003echat:write\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e create a dedicated demo calendar and a Google Sheets tab with headers: \u003cem\u003ereview_key, event_id, event\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46019081306291,"sku":"N8N-19542","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EV_RFY6EmOsEWosm5XG7o_FK71RDSq.png?v=1789376981","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-reconcile-google-calendar-demo-attendees-with-hubspot","provider":"N8N Commerce","version":"1.0","type":"link"}