by Davide
The official ChatGPT connector doesn’t allow you to interact directly with Google Workspace apps from within the app. Let’s see how to overcome this limitation by creating a dedicated MCP server. This workflow acts as a Middleware Control Point (MCP) between Google Workspace services — including Gmail, Drive, Docs, Sheets, Calendar, and Slides — and AI agents like OpenAI’s Agent Builder and the ChatGPT App. It enables these AI assistants to directly interact with Google Workspace tools — from managing emails and calendars to creating and editing documents, spreadsheets, or presentations — through secure automation endpoints, a feature that is not natively supported in the ChatGPT app. Key Advantages ✅ Unified AI–Google Workspace Integration Allows large language models (LLMs) to manage Gmail, Drive, Docs, Sheets, Calendar, and Slides directly, enabling AI-driven workflows like email automation, document creation, meeting scheduling, and data analysis. ✅ Full Control Across Google Apps Supports key actions across multiple services: Gmail: Read, send, reply, search, and draft emails. Drive: Search, upload, organize, and share files. Docs: Create, edit, and retrieve Google Docs. Sheets: Create or update spreadsheets, analyze data, and read cell values. Calendar: List, create, update, or delete events. Slides: Generate or modify presentations. ✅ Plug-and-Play with OpenAI Agent Builder & ChatGPT Easily connect to MCP-compatible AI platforms like Claude Desktop or OpenAI Agent Builder, with minimal configuration. ✅ Scalable and Extensible The modular structure allows you to expand to additional Google APIs or custom automations (e.g., CRM syncing, sentiment analysis, or reporting). ✅ No-Code/Low-Code Configuration Fully built in n8n, allowing easy customization and maintenance without deep programming skills. How It Works MCP Trigger: The “MCP Google Workspace Trigger” node acts as the server endpoint, waiting for incoming requests from an AI application. Tool Execution: When the AI needs to interact with a Google app (e.g., Gmail or Drive), it sends a command to this trigger. The workflow routes the request to the appropriate tool node. Available Actions (Examples): Gmail: Get, send, reply, search, or draft messages. Drive: Upload or retrieve files. Docs: Create or edit documents. Sheets: Read or update cell data. Calendar: Manage events. Slides: Generate or modify presentations. Data Return: The result (email content, document link, file metadata, event details, etc.) is returned to the MCP server and then to the AI, which can use it to continue the workflow or conversation. Setup Steps Configure Google Workspace Credentials in n8n: Authenticate each Google service (Gmail, Drive, Docs, Sheets, Calendar, Slides) via OAuth2 using the correct account credentials. Activate the Workflow: The workflow must be active in n8n. The MCP Trigger node provides a unique URL that serves as the server endpoint. Connect to an AI Application (Choose one method): ChatGPT App: Open the ChatGPT App (Plus plan required). Enable Dev Mode → Add new connector. Add an “MCP Server” as a tool and provide the URL from the “MCP Google Workspace Trigger” node. OpenAI Agent Builder: Visit OpenAI Agent Builder. Create a new workflow or agent. Add an “MCP Server” as a tool and provide the MCP URL from n8n. Once connected, the AI can intelligently manage Google Workspace tasks based on natural language requests such as: > “Schedule a meeting with Sarah tomorrow at 3 PM,” > “Create a new Google Doc titled ‘Marketing Plan’ and share it with the team,” > or “Find the latest report in Drive and summarize it.” Need help customizing? Contact me for consulting and support or add me on Linkedin.
by KlickTipp
Community Node Disclaimer: This workflow uses KlickTipp community nodes. Introduction This template listens for new events in Google Calendar and automatically creates or updates participant profiles in KlickTipp. Every attendee’s email address (and other available details) is mapped directly into your KlickTipp account without manual steps. This ensures your contact list always reflects the latest event registrations in real time. Perfect for coaches, consultants, and event organizers who want to capture RSVP information instantly and keep their marketing lists up to date. With each new attendee synced, you can launch reminder emails, follow-up campaigns, or trigger automated onboarding sequences. How it works This template keeps your KlickTipp list in sync with Google Calendar across the full event lifecycle. For each attendee, the workflow optionally filters out internal domains, then writes event details into KlickTipp custom fields. It watches your calendar for: Event Created* → creates/updates each attendee as a KlickTipp contact and adds the *event created/updated tag. Event Cancelled* → tags attendees with *event canceled. Event Updated* → routes attendees by *responseStatus** and tags them: accepted → event confirmed declined → event declined tentative → event considered Setup Instructions KlickTipp Preparation Prepare custom fields Google Calendar | event summary, data type: "Single line" Google Calendar | event description, data type: "Single line" Google Calendar | event location, data type: "Single line" Google Calendar | event start datetime, data type: "Datetime" Google Calendar | event end datetime, data type: "Datetime" Prepare tags: Google Calendar | event created/updated Google Calendar | event canceled Google Calendar | event declined Google Calendar | event confirmed Google Calendar | event considered Credential Configuration Connect your Google Calendar account using Client ID and Client Secret from the Google Cloud. Authenticate your KlickTipp connection with username/password credentials (API access required). Customization Recommended poll frequency: every 1–5 minutes for near real-time updates. Adjust to your local timezone if necessary. Each trigger works independently, allowing partial deployments if only certain event types are needed.
by System Admin
Tagged with: , , , ,
by Mario
Store Variables Between Workflow Runs Using n8n's Built-In Data Tables (Key-Value Store) Purpose This workflow implements a simple key value store based on the built-in data tables feature in n8n – no external service needed. What this is for This is a workflow snippet which could be used to store a “last checked” timestamp or other variables between workflow runs. Setup Self-deploying – no extra setup needed Just clone the template into your n8n instance and follow the instructions on the yellow sticky notes How it works A data table is used as a key value store having the two columns “key” and “value”. It is referenced by name, which makes it easier to migrate this workflow to other instances. At the beginning a variable is retrieved by it’s key If the variable / key does not exist yet, a default value is set, otherwise the stored value is being returned The variable can now be used and updated (see customization below) The variable is being created/updated in the database for the next workflow run If the variable did not exist before it get’s created Fallback: If the table doesn’t exist, it automatically gets created Compatibility n8n Version 2.5.0 or above Cloud or Self-Hosted Note: Please make sure to use this feature with care when storing passwords or access tokens since those can be exposed via the n8n API when querying past executions with their data or data tables directly. Those kind of data should preferably stored inside of credentials directly.
by Robert Breen
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This n8n workflow provides automated Power BI dataset refresh capabilities with built-in refresh history monitoring. It triggers a dataset refresh in Power BI and simultaneously checks the refresh history to track data update status. This is perfect for data analysts, business intelligence teams, or anyone who needs to automate Power BI dataset refreshes and monitor their success rates without manual intervention. Key Features: Automated Power BI dataset refresh triggering Simultaneous refresh history monitoring Manual trigger for on-demand execution Real-time status tracking Integration with Power BI REST API Support for workspace and personal datasets Step-by-Step Implementation Guide Prerequisites Before setting up this workflow, you'll need: n8n instance (cloud or self-hosted) Power BI account (Pro or Premium) Microsoft Azure App Registration for API access Power BI dataset that you want to refresh Step 1: Set Up Azure App Registration Go to Azure Portal Navigate to Azure Active Directory → App registrations Click New registration Configure your app: Name: n8n-powerbi-integration Supported account types: Accounts in this organizational directory only Redirect URI: https://your-n8n-instance.com/rest/oauth2-credential/callback Click Register Note down the Application (client) ID and Directory (tenant) ID Step 2: Configure App Permissions In your app registration, go to API permissions Click Add a permission → Power BI Service Select Delegated permissions and add: Dataset.ReadWrite.All Dataset.Read.All Workspace.Read.All Click Grant admin consent for your organization Step 3: Create Client Secret In your app registration, go to Certificates & secrets Click New client secret Add description: n8n-powerbi-secret Set expiration (recommended: 24 months) Click Add and copy the secret value immediately Step 4: Configure Power BI API Credentials in n8n In n8n, go to Credentials → Add Credential → Power BI OAuth2 API Configure as follows: Client ID: Your Application (client) ID from Step 1 Client Secret: Your client secret from Step 3 Scope: https://analysis.windows.net/powerbi/api/.default Save and test the connection Step 6: Import and Configure the Workflow Copy the provided workflow JSON In n8n, click Import from File or Import from Clipboard Paste the workflow JSON Configure each node as detailed below: Node Configuration Details: When clicking 'Execute workflow' (Manual Trigger) Type**: Manual Trigger Purpose**: Allows manual execution of the workflow No configuration needed Refresh Datasource (Power BI) Resource**: dataset Operation**: refresh Group ID**: me (for personal workspace) or your workspace ID Dataset ID**: Your Power BI dataset ID (from Step 5) Credentials**: Select your "Power BI account" Check Refresh History (Power BI) Resource**: dataset Operation**: getRefreshHistory Group ID**: me (for personal workspace) or your workspace ID Dataset ID**: Your Power BI dataset ID (same as above) Top**: 10 (number of recent refresh records to retrieve) Credentials**: Select your "Power BI account" Workflow Flow Summary Manual Trigger → User initiates workflow execution Parallel Execution: Refresh Dataset → Triggers Power BI dataset refresh Get History → Retrieves recent refresh history Results → Both operations complete simultaneously providing: Confirmation of refresh initiation Historical context of previous refreshes Contact Information Robert A Ynteractive For support, customization, or questions about this workflow: 📧 Email: rbreen@ynteractive.com 🌐 Website: https://ynteractive.com/ 💼 LinkedIn: https://www.linkedin.com/in/robert-breen-29429625/ Need help implementing this workflow or want custom automation solutions? Get in touch for professional n8n consulting and workflow development services.
by Jitesh Dugar
Comprehensive workflow template for managing Google Tasks through n8n automation. Provides full CRUD operations (Create, Read, Update, Delete) for seamless task management integration. 🚀 Features Create Tasks** - Add new tasks programmatically Retrieve Tasks** - Get individual or multiple tasks with filtering Update Tasks** - Modify existing task details and status Delete Tasks** - Remove completed or obsolete tasks Batch Operations** - Handle multiple tasks efficiently 💼 Perfect For Project Management** - Automate task creation from project milestones Email Integration** - Convert emails to actionable tasks CRM Workflows** - Create follow-up tasks from customer interactions Content Planning** - Generate tasks from editorial calendars Team Collaboration** - Sync tasks across different platforms 🔧 What's Included Pre-configured Google Tasks API nodes Error handling and validation Flexible task filtering and sorting Status management (pending/completed) Batch processing capabilities ⚡ Quick Start Connect your Google Tasks account Configure task list preferences Test individual operations Deploy and automate! Transform your productivity workflow with automated task management.
by amudhan
Companion workflow for Bitbucket Trigger node docs
by amudhan
Companion workflow for Clockify Trigger node docs
by amudhan
Companion workflow for Calendly Trigger node docs
by amudhan
Companion workflow for Eventbrite Trigger node docs
by Don Wen
What this workflow does This template demonstrates how to perform unit-aware calculations with automatic unit conversion using the CalcsLive community node. It shows three calculation patterns: Speed calculation: Convert distance and time into velocity (km → km/h) Cylinder volume: Calculate volume from diameter and height (cm → Liters) Chained calculations: Pass output from one calculation as input to another (Volume → Mass) Workflow Screenshot CalcsLive Articles Used You can view and customize each calculation article in the CalcsLive editor: | Calculation | Article ID | Link | |-------------|------------|------| | Speed Calc | 3M6P9TF5P-3XA | Open in Editor | | Cylinder Volume | 3M6P9TF5P-3XA | Open in Editor | | Mass Calc | 3M6PBGU7S-3CA | Open in Editor | Note: Speed and Cylinder Volume use the same multi-purpose article (3M6P9TF5P-3XA), demonstrating how one article can serve multiple calculation needs. Meanwhile, Cylinder Volume and Mass Calc are chained together as composables - the volume output feeds directly into the mass calculation. This pattern offers both flexibility and power for complex workflows. Seamless Data Flow An implicit but powerful feature: full unit freedom - input data flows seamlessly through the workflow. The "Set" nodes prepare data that CalcsLive nodes consume directly via expressions. CalcsLive then delivers outputs in your specified units, ready to feed downstream nodes. Both inputs and outputs integrate naturally with n8n's data model - no transformation needed. Why use CalcsLive? 570+ units** across 67+ categories with automatic conversion No formula coding** - use pre-built calculation articles Chain calculations** - output from one calc feeds into another Unit flexibility** - input in any unit, get output in your preferred unit Prerequisites Install the CalcsLive community node: @calcslive/n8n-nodes-calcslive Get an API key from calcslive.com (free tier available) Create CalcsLive API credentials in n8n How to use Import this workflow Configure your CalcsLive API credentials Click "Execute workflow" to see the calculations run Modify the input values in the "Set" nodes to test different scenarios Example use cases E-commerce**: Calculate shipping costs based on package dimensions and weight Manufacturing**: Convert between metric and imperial units in production workflows IoT**: Process sensor data with proper unit handling Engineering**: Chain multiple physics calculations together Resources CalcsLive - n8n Integration npm Package GitHub Repository
by sshaligr
Add an event to Google Calendar