by System Admin
Tagged with: , , , ,
by System Admin
Tagged with: , , , ,
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 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 Calendly Trigger node docs
by amudhan
Companion workflow for Eventbrite Trigger node docs
by amudhan
Companion workflow for Clockify Trigger node docs
by amudhan
Companion workflow for Bitbucket Trigger node docs
by sshaligr
Add an event to Google Calendar