Automate Zoom ๐ฆ user onboarding with OAuth token management and data tables
This workflow automates the management of Zoom OAuth tokens and the creation of new Zoom users through the Zoom API.
This workflow automates the process of creating a new Zoom user by first ensuring a valid OAuth access token is available. It is designed to handle the fact that Zoom access tokens are short-lived (1 hour) by using a longer-lived refresh token (90 days) stored in an n8n Data Table.
It includes two main phases:
-
Token Generation & Management
- The workflow initially requests a Zoom access token using the OAuth 2.0 โauthorization codeโ method.
- The resulting access token (valid for 1 hour) and refresh token (valid for 90 days) are stored in an n8n Data Table.
- When executed again, the workflow checks for the most recent token, refreshes it using the refresh token, and updates the Data Table automatically.
-
User Creation in Zoom
- Once a valid token is retrieved, the workflow collects the userโs first name, last name, and email (set in the โDataโ node).
- It then generates a secure random password for the new user.
- Using the Zoom API, it sends a POST request to create the new user, automatically triggering an invitation email from Zoom.
Key Features
-
โ Full Automation of Zoom Authentication
- Eliminates manual token handling by automatically refreshing and updating OAuth credentials.
-
โ Centralized Token Storage
- Securely stores access and refresh tokens in an n8n Data Table, simplifying reuse across workflows.
-
โ Error Prevention
- Ensures that expired tokens are replaced before API requests, avoiding failed Zoom operations.
4.โ Automatic User Provisioning
- Creates Zoom users automatically with prefilled credentials and triggers Zoomโs built-in invitation process.
-
โ Scalability
- Can be easily extended to handle bulk user creation, role assignments, or integration with other systems (e.g., HR, CRM).
-
โ Transparency & Modularity
- Each node is clearly labeled with โSticky Notesโ explaining every step, making maintenance and handover simple.
How it works
- Trigger and Data Retrieval: The workflow starts manually. It first retrieves user data (first name, last name, email) from the "Data" node. In parallel, it fetches all stored token records from a Data Table.
- Token Management: The retrieved tokens are sorted and limited to get only the most recent one. This latest token (which contains the
refresh_token) is then used in an HTTP Request to Zoom's OAuth endpoint to generate a fresh, validaccess_token. - User Creation: The new
access_tokenandrefresh_tokenare saved back to the Data Table for future use. The workflow then generates a random password for the new user, merges this password with the initial user data, and finally sends a POST request to the Zoom API to create the new user. If the creation is successful, Zoom automatically sends an invitation email to the new user.
Set up steps
-
Prepare the Data Table:
- Create a new Data Table in your n8n project.
- Add two columns to it:
accessTokenandrefreshToken.
-
Configure Zoom OAuth App:
- Create a standard OAuth app in the Zoom Marketplace (not a Server-to-Server app).
- Note your Zoom
account_id. - Encode your Zoom app's
client_idandclient_secretin Base64 format (asclient_id:client_secret). - In both the "Get new token" and "Zoom First Access Token" nodes, replace the
"XXX"in theAuthorizationheader with this Base64-encoded string.
-
Generate Initial Tokens (First Run Only):
- Manually execute the "Zoom First Access Token" node once. This node uses an authorization code to fetch the first-ever access and refresh tokens and saves them to your Data Table. The main workflow will use these stored tokens from this point forward.
-
Configure User Data:
- In the "Data" node, set the default values for the new Zoom user by replacing the
"XXX"placeholders forfirst_name,last_name, andemail.
- In the "Data" node, set the default values for the new Zoom user by replacing the
After these setup steps, the main workflow (triggered via "When clicking 'Execute workflow'") can be run whenever you need to create a new Zoom user. It will automatically refresh the token and use the provided user data to create the account.
Need help customizing?
Contact me for consulting and support or add me on Linkedin.
n8n Workflow: Basic Workflow Structure Example
This n8n workflow demonstrates a fundamental structure involving data manipulation, conditional logic, and external HTTP requests. It's a foundational example that can be extended for various automation tasks.
What it does
This workflow showcases a sequence of common n8n operations:
- Manual Trigger: Initiates the workflow execution manually.
- Edit Fields (Set): Allows for setting or modifying data fields within the workflow items.
- Data Table: Provides a structured way to manage and display data, potentially for lookup or storage within the workflow.
- Limit: Controls the number of items processed, useful for testing or managing API rate limits.
- Sort: Arranges workflow items based on specified criteria.
- If: Introduces conditional logic, allowing the workflow to branch based on whether a condition evaluates to true or false.
- HTTP Request: Makes a request to an external API or URL, enabling interaction with other services.
- Merge: Combines data from different branches or previous steps back into a single stream.
- Sticky Note: Provides a way to add comments or explanations directly within the workflow canvas for documentation purposes.
Requirements
- An n8n instance (cloud or self-hosted).
- No external credentials are explicitly configured in this basic structure, but for the "HTTP Request" node, you would typically need API keys, tokens, or other authentication details depending on the target API.
Setup/Usage
- Import the workflow: Download the provided JSON and import it into your n8n instance.
- Examine the nodes:
- Manual Trigger: Click "Execute Workflow" to start the flow.
- Edit Fields (Set): Configure this node to add, remove, or modify fields as needed for your specific use case.
- Data Table: Populate this node with sample data or configure it to receive data from previous nodes.
- Limit: Adjust the "Limit" parameter to control how many items pass through.
- Sort: Define the field(s) by which you want to sort the data and the sort order (ascending/descending).
- If: Set up your conditional logic using expressions to route data through the TRUE or FALSE branches.
- HTTP Request: Configure the URL, method (GET, POST, etc.), headers, and body for your API call. Add any necessary authentication.
- Merge: This node will automatically combine the outputs from its incoming connections.
- Sticky Note: This is purely for documentation; you can edit its content to add notes about specific parts of the workflow.
- Activate the workflow: Once configured, activate the workflow to make it ready for execution.
This workflow serves as an excellent starting point for building more complex automations by combining these fundamental building blocks.
Related Templates
AI multi-agent executive team for entrepreneurs with Gemini, Perplexity and WhatsApp
This workflow is an AI-powered multi-agent system built for startup founders and small business owners who want to automate decision-making, accountability, research, and communication, all through WhatsApp. The โvirtual executive team,โ is designed to help small teams to work smarter. This workflow sends you market analysis, market and sales tips, It can also monitor what your competitors are doing using perplexity (Research agent) and help you stay a head, or make better decisions. And when you feeling stuck with your start-up accountability director is creative enough to break the barrier ๐ฏ Core Features ๐งโ๐ผ 1. President (Super Agent) Acts as the main controller that coordinates all sub-agents. Routes messages, assigns tasks, and ensures workflow synchronization between the AI Directors. ๐ 2. Sales & Marketing Director Uses SerpAPI to search for market opportunities, leads, and trends. Suggests marketing campaigns, keywords, or outreach ideas. Can analyze current engagement metrics to adjust content strategy. ๐ต๏ธโโ๏ธ 3. Business Research Director Powered by Perplexity AI for competitive and market analysis. Monitors competitor moves, social media engagement, and product changes. Provides concise insights to help the founder adapt and stay ahead. โฐ 4. Accountability Director Keeps the founder and executive team on track. Sends motivational nudges, task reminders, and progress reports. Promotes consistency and discipline โ key traits for early-stage success. ๐๏ธ 5. Executive Secretary Handles scheduling, email drafting, and reminders. Connects with Google Calendar, Gmail, and Sheets through OAuth. Automates follow-ups, meeting summaries, and notifications directly via WhatsApp. ๐ฌ WhatsApp as the Main Interface Interact naturally with your AI team through WhatsApp Business API. All responses, updates, and summaries are delivered to your chat. Ideal for founders who want to manage operations on the go. โ๏ธ How It Works Trigger: The workflow starts from a WhatsApp Trigger node (via Meta Developer Account). Routing: The President agent analyzes the incoming message and determines which Director should handle it. Processing: Marketing or sales queries go to the Sales & Marketing Director. Research questions are handled by the Business Research Director. Accountability tasks are assigned to the Accountability Director. Scheduling or communication requests are managed by the Secretary. Collaboration: Each sub-agent returns results to the President, who summarizes and sends the reply back via WhatsApp. Memory: Context is maintained between sessions, ensuring personalized and coherent communication. ๐งฉ Integrations Required Gemini API โ for general intelligence and task reasoning Supabase- for RAG and postgres persistent memory Perplexity API โ for business and competitor analysis SerpAPI โ for market research and opportunity scouting Google OAuth โ to connect Sheets, Calendar, and Gmail WhatsApp Business API โ for message triggers and responses ๐ Benefits Acts like a team of tireless employees available 24/7. Saves time by automating research, reminders, and communication. Enhances accountability and strategy consistency for founders. Keeps operations centralized in a simple WhatsApp interface. ๐งฐ Setup Steps Create API credentials for: WhatsApp (via Meta Developer Account) Gemini, Perplexity, and SerpAPI Google OAuth (Sheets, Calendar, Gmail) Create a supabase account at supabase Add the credentials in the corresponding n8n nodes. Customize the system prompts for each Director based on your startupโs needs. Activate and start interacting with your virtual executive team on WhatsApp. Use Case You are a small organisation or start-up that can not afford hiring; marketing department, research department and secretar office, then this workflow is for you ๐ก Need Customization? Want to tailor it for your startup or integrate with CRM tools like Notion or HubSpot? You can easily extend the workflow or contact the creator for personalized support. Consider adjusting the system prompt to suite your business
๐ How to transform unstructured email data into structured format with AI agent
This workflow automates the process of extracting structured, usable information from unstructured email messages across multiple platforms. It connects directly to Gmail, Outlook, and IMAP accounts, retrieves incoming emails, and sends their content to an AI-powered parsing agent built on OpenAI GPT models. The AI agent analyzes each email, identifies relevant details, and returns a clean JSON structure containing key fields: From โ senderโs email address To โ recipientโs email address Subject โ email subject line Summary โ short AI-generated summary of the email body The extracted information is then automatically inserted into an n8n Data Table, creating a structured database of email metadata and summaries ready for indexing, reporting, or integration with other tools. --- Key Benefits โ Full Automation: Eliminates manual reading and data entry from incoming emails. โ Multi-Source Integration: Handles data from different email providers seamlessly. โ AI-Driven Accuracy: Uses advanced language models to interpret complex or unformatted content. โ Structured Storage: Creates a standardized, query-ready dataset from previously unstructured text. โ Time Efficiency: Processes emails in real time, improving productivity and response speed. *โ Scalability: Easily extendable to handle additional sources or extract more data fields. --- How it works This workflow automates the transformation of unstructured email data into a structured, queryable format. It operates through a series of connected steps: Email Triggering: The workflow is initiated by one of three different email triggers (Gmail, Microsoft Outlook, or a generic IMAP account), which constantly monitor for new incoming emails. AI-Powered Parsing & Structuring: When a new email is detected, its raw, unstructured content is passed to a central "Parsing Agent." This agent uses a specified OpenAI language model to intelligently analyze the email text. Data Extraction & Standardization: Following a predefined system prompt, the AI agent extracts key information from the email, such as the sender, recipient, subject, and a generated summary. It then forces the output into a strict JSON structure using a "Structured Output Parser" node, ensuring data consistency. Data Storage: Finally, the clean, structured data (the from, to, subject, and summarize fields) is inserted as a new row into a specified n8n Data Table, creating a searchable and reportable database of email information. --- Set up steps To implement this workflow, follow these configuration steps: Prepare the Data Table: Create a new Data Table within n8n. Define the columns with the following names and string type: From, To, Subject, and Summary. Configure Email Credentials: Set up the credential connections for the email services you wish to use (Gmail OAuth2, Microsoft Outlook OAuth2, and/or IMAP). Ensure the accounts have the necessary permissions to read emails. Configure AI Model Credentials: Set up the OpenAI API credential with a valid API key. The workflow is configured to use the model, but this can be changed in the respective nodes if needed. Connect the Nodes: The workflow canvas is already correctly wired. Visually confirm that the email triggers are connected to the "Parsing Agent," which is connected to the "Insert row" (Data Table) node. Also, ensure the "OpenAI Chat Model" and "Structured Output Parser" are connected to the "Parsing Agent" as its AI model and output parser, respectively. Activate the Workflow: Save the workflow and toggle the "Active" switch to ON. The triggers will begin polling for new emails according to their schedule (e.g., every minute), and the automation will start processing incoming messages. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
Dynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution
AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) ๐ง AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative โ all powered by AI logic, sir. --- ๐ก Key Advantages โก Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. ๐ง AI Qualification Engine An OpenAI-powered Agent evaluates the leadโs industry, region, and needs to generate a persona summary and routing rationale. ๐ Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. ๐ฌ Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. ๐ Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- โ๏ธ How It Works HubSpot Trigger โ Captures a new lead as soon as itโs created in HubSpot. Fetch Contact Data โ Retrieves all relevant fields like name, company, and industry. Clean & Format Data โ A Code node standardizes and structures the data for consistency. Airtable Record Creation โ Logs the lead data into the โLeadsโ table for centralized tracking. AI Agent Qualification โ The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update โ Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification โ Sends a real-time message tagging the rep with lead info. Gmail Notification โ Sends a personalized handoff email with context and follow-up actions. HubSpot Sync โ Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- ๐ ๏ธ Setup Steps Trigger Node: HubSpot โ Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the โLeadsโ table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- ๐ Credentials Required HubSpot OAuth2 API โ To fetch and update leads. Airtable Personal Access Token โ To store and update lead data. OpenAI API โ To power the AI qualification and matching logic. Slack OAuth2 โ For sending team notifications. Gmail OAuth2 โ For automatic email alerts to assigned reps, sir. --- ๐ค Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- ๐ฌ Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular โ perfect for scaling across global sales teams, sir.