Google Calendar and Notion integration

How it works This workflow automates the entire lifecycle of a service-based client, combining four distinct business flows into a single view: Intake Leads: Receives a webhook from your form builder, validates the data, optionally enriches the email using Clearbit, and creates records in Airtable and Notion. Manage Bookings: Processes scheduling webhooks to update lead status, create Google Calendar events, and send pre-call survey emails. Send Reminders: Runs a daily schedule to scan Airtable for upcoming calls and automatically sends 24h reminder emails to reduce no-shows. Onboard Clients: Reacts to successful payments by marking leads as "Paid," generating a Notion Onboarding Checklist, and sending a Welcome Kit via Email and WhatsApp. Set up steps Configure Credentials: Connect your accounts for Airtable, Notion, Slack, Google Calendar, and GMAIL. (Optional) Add credentials for Clearbit (enrichment) and Twilio (WhatsApp). Customize Emails: Open the four Email Send nodes. Customize the Body Text with your own booking links and survey URLs. Configure Tables & IDs: Update the Airtable nodes with your specific Base and Table names (e.g., tblLeads). Update the Notion nodes with your Database IDs for Projects and Onboarding. Connect Webhooks: Copy the Production URLs from the three Webhook nodes (Lead Intake, Booking, Payment) and paste them into your respective form, calendar, or payment provider settings.

Who is this for This template is perfect for sales professionals, account managers, and business development teams who want to make memorable impressions on their clients. It automates the tedious task of researching gift shops and preparation spots before important meetings. What it does This workflow automatically prepares personalized recommendations for client visits by monitoring your Google Calendar, enriching data from Notion, and using AI to select the perfect options. How it works Trigger: Activates when a calendar event containing keywords like "visit," "meeting," "client," or "dinner" is created or updated Extract: Parses company name from the event title Enrich: Fetches customer preferences from your Notion database Search: Google Places API finds nearby gift shops and quiet cafes Analyze: GPT-4 recommends the best options based on customer preferences Notify: Sends a personalized message to Slack with recommendations Example Slack Output Here's what the final notification looks like: 🎁 Recommended Gift Shop Patisserie Sadaharu AOKI (★4.6) 3-5-2 Marunouchi, Chiyoda-ku 💡 Reason: The customer loves French desserts, so this patisserie's macarons would be perfect! ☕ Pre-Meeting Cafe Starbucks Reserve Roastery (★4.5) 5 min walk from meeting location Set up steps Setup time: approximately 15 minutes Google Calendar: Connect your Google Calendar account and select your calendar Notion Database: Create a customer database with "Company Name" (title) and "Preferences" (text) fields Google Places API: Get an API key from Google Cloud Console and add it to the Configuration node OpenAI: Connect your OpenAI account for AI-powered recommendations Slack: Connect your Slack workspace and update the channel ID in the final node Requirements Google Calendar account Notion account with a customer database Google Places API key (requires Google Cloud account) OpenAI API key Slack workspace with bot permissions How to customize Search radius: Adjust the searchRadius parameter in the Configuration node (default: 1000 meters) Event keywords: Modify the Filter node conditions to match your calendar naming conventions Notification channel: Change the Slack channel ID to your preferred channel

Who is this for This workflow is perfect for busy professionals, consultants, and anyone who frequently travels between meetings. If you want to make the most of your free time between appointments and discover great nearby spots without manual searching, this template is for you. What it does This workflow automatically monitors your Google Calendar and identifies gaps between appointments. When it detects sufficient free time (configurable, default 30+ minutes), it calculates travel time to your next destination, checks the weather, and uses AI to recommend the top 3 spots to visit during your break. Recommendations are weather-aware: indoor spots like cafés in malls or stations for rainy days, and outdoor terraces or open-air venues for nice weather. How it works Schedule Trigger - Runs every 30 minutes to check your calendar Fetch Data - Gets your next calendar event and user preferences from Notion Calculate Gap Time - Determines available free time by subtracting travel time (via Google Maps) from time until your next appointment Weather Check - Gets current weather at your destination using OpenWeatherMap Smart Routing - Routes to indoor or outdoor spot search based on weather conditions AI Recommendations - GPT-4.1-mini analyzes spots and generates personalized top 3 recommendations Slack Notification - Sends a friendly message with recommendations to your Slack channel Set up steps Configure API Keys - Add your Google Maps, Google Places, and OpenWeatherMap API keys in the "Set Configuration" node Connect Google Calendar - Set up OAuth connection and select your calendar Set up Notion - Create a database for user preferences and add the database ID Connect Slack - Set up OAuth and specify your notification channel Connect OpenAI - Add your OpenAI API credentials Customize - Adjust currentLocation and minGapTimeMinutes to your needs Requirements Google Cloud account with Maps and Places APIs enabled OpenWeatherMap API key (free tier available) Notion account with a preferences database Slack workspace with bot permissions OpenAI API key How to customize Change trigger frequency: Modify the Schedule Trigger interval Adjust minimum gap time: Change minGapTimeMinutes in the configuration node Modify search radius: Edit the radius parameter in the Places API calls (default: 1000m) Customize spot types: Modify the type and keyword parameters in the HTTP Request nodes Change AI model: Switch to a different OpenAI model in the AI node Localize language: Update the AI prompt to generate responses in your preferred language

How it Works This workflow accepts meeting transcripts via webhook (Zoom, Google Meet, Teams, Otter.ai, or manual notes), immediately processing them through an intelligent pipeline that eliminates post-meeting admin work. The system parses multiple input formats (JSON, form data, transcription outputs), extracting meeting metadata including title, date, attendees, transcript content, duration, and recording URLs. OpenAI analyzes the transcript to extract eight critical dimensions: executive summary, key decisions with ownership, action items with assigned owners and due dates, discussion topics, open questions, next steps, risks/blockers, and follow-up meeting requirements—all returned as structured JSON. The intelligence engine enriches each action item with unique IDs, priority scores (weighing urgency + owner assignment + due date), status initialization, and meeting context links, then calculates a completeness score (0-100) that penalizes missing owners and undefined deadlines. Multi-channel distribution ensures visibility: Slack receives formatted summaries with emoji categorization for decisions (✅), action items (🎯) with priority badges and owner assignments, and completeness scores (📊). Notion gets dual-database updates—meeting notes with formatted decisions and individual task cards in your action item database with full filtering and kanban capabilities. Task owners receive personalized HTML emails with priority color-coding and meeting context, while Google Calendar creates due-date reminders as calendar events. Every meeting logs to Google Sheets for analytics tracking: attendee count, duration, action items created, priority distribution, decision count, completeness score, and follow-up indicators. The workflow returns a JSON response confirming successful processing with meeting ID, action item count, and executive summary. The entire pipeline executes in 8-12 seconds from submission to full distribution. Who is this for? Product and engineering teams drowning in scattered action items across tools Remote-first companies where verbal commitments vanish after calls Executive teams needing auditable decision records without dedicated note-takers Startups juggling 10+ meetings daily without time for manual follow-up Operations teams tracking cross-functional initiatives requiring accountability Setup Steps Setup time:** 25-35 minutes Requirements:** OpenAI API key, Slack workspace, Notion account, Google Workspace (Calendar/Gmail/Sheets), optional transcription service Webhook Trigger: Automatically generates URL, configure as POST endpoint accepting JSON with title, date, attendees, transcript, duration, recording_url, organizer Transcription Integration: Connect Otter.ai/Fireflies.ai/Zoom webhooks, or create manual submission form OpenAI Analysis: Add API credentials, configure GPT-4 or GPT-3.5-turbo, temperature 0.3, max tokens 1500 Intelligence Synthesis: JavaScript calculates priority scores (0-40 range) and completeness metrics (0-100), customize thresholds Slack Integration: Create app with chat:write scope, get bot token, replace channel ID placeholder with your #meeting-summaries channel Notion Databases: Create "Meeting Notes" database (title, date, attendees, summary, action items, completeness, recording URL) and "Action Items" database (title, assigned to, due date, priority, status, meeting relation), share both with integration, add token Email Notifications: Configure Gmail OAuth2 or SMTP, customize HTML template with company branding Calendar Reminders: Enable Calendar API, creates events on due dates at 9 AM (adjustable), adds task owner as attendee Analytics Tracking: Create Google Sheet with columns for Meeting_ID, Title, Date, Attendees, Duration, Action_Items, High_Priority, Decisions, Completeness, Unassigned_Tasks, Follow_Up_Needed Test: POST sample transcript, verify Slack message, Notion entries, emails, calendar events, and Sheets logging Customization Guidance Meeting Types:** Daily standups (reduce tokens to 500, Slack-only), sprint planning (add Jira integration), client calls (add CRM logging), executive reviews (stricter completeness thresholds) Priority Scoring:** Add urgency multiplier for <48hr due dates, owner seniority weights, customer impact flags AI Prompt:** Customize to emphasize deadlines, blockers, or technical decisions; add date parsing for phrases like "by end of week" Notification Routing:** Critical priority (score >30) → Slack DM + email, High (20-30) → channel + email, Medium/Low → email only Tool Integrations:** Add Jira/Linear for ticket creation, Asana/Monday for project management, Salesforce/HubSpot for CRM logging, GitHub for issue creation Analytics:** Build dashboards for meeting effectiveness scores, action item velocity, recurring topic clustering, team productivity metrics Cost Optimization:** ~1,200 tokens/meeting × $0.002/1K (GPT-3.5) = $0.0024/meeting, use batch API for 50% discount, cache common patterns Once configured, this workflow becomes your team's institutional memory—capturing every commitment and decision while eliminating hours of weekly admin work, ensuring accountability is automatic and follow-through is guaranteed. Built by Daniel Shashko Connect on LinkedIn

The Google Meet AI Assistant workflow provides intelligent meeting analysis by integrating Google Calendar, Google Drive, AssemblyAI transcription, Anthropic Claude AI, Slack, and Notion. It automates the complete process of fetching meeting data, retrieving recordings, transcribing conversations, analyzing with AI, and distributing actionable insights. Workflow Steps Step 1: Fetch Meetings Retrieves Google Calendar events from the last 24 hours. Filters for confirmed meetings with Google Meet conference links. Step 2: Get Recording Searches for the meeting recording file saved in Google Drive. Downloads the recording for transcription purposes. Step 3: Transcribe Recording Uses AssemblyAI to transcribe the recording. Transcription includes speaker labels, highlights, and sentiment analysis. Step 4: AI Analysis Analyzes the transcript with Anthropic Claude AI. Extracts: Meeting summary (2-3 paragraphs) Action items with responsible parties Mentioned dates or deadlines Overall meeting sentiment Step 5: Distribute Summary Posts meeting summary and insights to a Slack channel. Creates tasks for action items in Notion. Integration Overview Google Calendar: Event retrieval and filtering of Google Meet meetings. Google Drive: Recording search and download. AssemblyAI: Audio transcription with advanced features. Anthropic Claude (Langchain): AI-driven analysis of transcripts. Slack: Notification distribution for meeting summaries. Notion: Task creation for actionable items. Error Handling If a recording is not found, stops execution and returns an error message: "No recording found for this meeting. Please ensure the meeting was recorded and saved to Google Drive." Summary This workflow fully automates the end-to-end process of meeting analysis from calendar event detection to action item task creation using AI, enabling productivity gains for meeting-heavy teams. If further use or support is needed, you can contact me via LinkedIn. If you want, I can also help create a detailed documentation or a formatted description ready for sharing or integration guides. Let me know!

Generate 7-Day Event Plans with Google Calendar, GPT-3.5 and Notion 🎉 Automate Your Event Planning: From Calendar Entry to Done-For-You Checklist Stop scrambling before birthdays, anniversaries, or family gatherings. This workflow turns a simple Google Calendar event into a 7-day prep plan — complete with shopping lists, tasks, and reminders — all auto-sent to Notion and your inbox. Perfect for: 👩‍👧 Homemakers hosting family events 💼 Solopreneurs planning launches or webinars 🎉 Anyone who wants to celebrate without the stress The workflow: 📅 Detects a new event in Google Calendar (e.g., “Emma’s Birthday”) 🤖 Uses GPT-3.5 to generate a 7-day prep plan (buy cake, send invites, decorate) 📝 Creates a Notion page for the event, then loops through each AI-generated task to add them as individual rows/items with due dates 📨 Emails you a summary + link to the Notion page No spreadsheets. No mental load. Just set the date — and let AI handle the rest. > 🔁 Key Detail: After the Notion page is created, the workflow uses an Item Lists node to split the AI-generated task array into individual items. Each task is then processed in a loop and appended to the Notion database as a separate row — ensuring clean, actionable checklists. Prerequisites Before using this workflow, ensure you have: | Service | Purpose | Free Tier? | |--------|--------|-----------| | n8n | Orchestrate automation | Yes | | Google Calendar | Trigger on new events | Yes | | Notion | Store prep checklist | Yes | | OpenAI | AI planning logic (GPT-3.5) | Yes (limited free tier) | | SMTP Email | Send confirmation email | Yes (via Gmail or similar) | 🔐 Store all API keys securely in n8n’s Credentials section. Google Calendar Setup Your event must include: Title**: e.g., "Emma’s Birthday" Date**: The event date Description** (optional): e.g., “Theme: Unicorn, Guests: 10” 💡 Tip: Use a specific keyword in the title (e.g., “🎂”) to trigger only special events. Notion Database Requirements Create a Notion database with these columns: | Column Name | Type | Example | |------------|------|--------| | Name | Title | "Emma’s Birthday Prep" | | Task | Text | "Buy cake" | | Due Date | Date | 2025-09-10 | | Status | Status | To Do, In Progress, Done | | Event Date | Date | 2025-09-12 | | Notes | Text | "Vanilla with rainbow sprinkles" | 📌 Share your Notion workspace with your n8n integration (via integration token). Step-by-Step Setup Instructions Import the Workflow In n8n, go to Workflows > Create from JSON Paste the provided JSON Click Import Set Up Credentials Google Calendar**: Connect via OAuth Notion**: Add your integration token OpenAI**: Add your API key Email**: Set up SMTP (e.g., Gmail app password) 🔐 Never hardcode keys — use n8n’s credential system. Configure the AI Prompt In the HubGPT: Generate Prep Plan node: You're planning "{{ $json['summary'] }}" on {{ $json['start'] }}. Generate a 7-day prep plan with 5–7 tasks (e.g., shopping, invites, setup). Include: 3 days before: Send invites 2 days before: Buy supplies 1 day before: Decorate Return as a JSON array with 'task' and 'dueDate'.

How it works This workflow is your personal CEO Brain. Every Saturday night, it automatically collects the past week’s activity across: 📩 Gmail: filters out spam, promos, receipts, etc. 📅 Google Calendar: grabs past week and upcoming month 🗒️ Notion Weekly Plan: pulls and analyzes a photo of your weekly plan (e.g., taken from a paper planner/notebook) using GPT-4o 🎯 Notion OKRs: fetches quarterly OKRs and formats them for summary It sends all the data to GPT-4.1, which generates a smart weekly report — including progress check, misalignments, overdue follow-ups, and next steps — then emails it to you as a Weekly OKR Report. Set up steps 🧠 Add your Gmail, Google Calendar, Notion, and OpenAI credentials 📅 The Notion Weekly Plan should have a date property and an image field that holds a photo of your planner/notebook page 🎯 The Notion OKR database should include objective, key result, and status fields 🔁 Schedule is preset to every Saturday at 20:30 HK time (cron 0 30 20 * * 6). Also set the workflow timezone in n8n and, if self-hosting, the server/container TZ (e.g., TZ=Asia/Hong_Kong) to ensure correct triggering 💬 You can modify the AI prompts inside the LLM nodes for more customized outputs

This workflow syncs multiple Notion databases to your Google Calendar. And it works both ways. What events are supported? Everything except recurring events. All day events, multiple day events, start and end date… these are all supported. You set them in Notion and they stay in sync with Google. And vice versa. Why doesn’t it support recurring events? Notion doesn’t support recurring events yet. So when you create a recurring event in Google, it will only consider the first date, ignoring future occurrences of the event. Can I connect more than one Notion database? Yes. You can have many Notion databases synced to one Google Calendar account. You can see how to do it in the workflow instructions. It is recommended that you create more calendars in your account, so that you can link each calendar to a different database in Notion. But that’s a choice. What happens if I delete an event or page? Notion page deleted → Deletes event in Google Notion date property cleared → Deletes event in Google Google event deleted → Clears the date property in Notion, but keeps the page, so you don’t lose your work. Does it update the events? Yes. When you update the event in Google or in Notion it syncs both ways. How can I know what Notion item was linked to an event? Either by the name or by clicking the hyperlink in the event description that says: 👉 View in Notion. When I create a new event in Google, does it add an item to Notion? Yes. When you create an event inside one of your calendars, the item is synced to the corresponding Notion database. Does it sync event descriptions? No. The event description will always be “View in Notion”. Even if you change it in Google Calendar it will be overwritten when you make a change to the Notion page. 🎉 When you buy this template you receive step-by-step instructions on how to set it up. Check out my other templates 👉 https://n8n.io/creators/solomon/