HumationHuman + Automation
Back to Catalog

Sync AI-enriched TimeRex bookings to Google Sheets and Slack with Gemini

Oka HironobuOka Hironobu
5 views
2/3/2026
Google SheetsShopifyE-commerceData SyncScheduling
Official Page

TimeRex AI-Powered Booking Automation

Description (for n8n template submission)

Transform your TimeRex booking management with AI-powered automation. This workflow automatically processes bookings, enriches data with AI insights, and keeps your team informed via Slack—all in real-time.

What This Workflow Does

🤖 AI-Powered Intelligence

  • Smart Company Detection: Automatically identifies company names from guest email domains
  • Booking Categorization: Uses Google Gemini to classify bookings (Sales/Support/Interview/Partnership/Media)
  • Meeting Brief Generation: AI creates actionable preparation notes for hosts before each meeting

⚡ Automated Processing

  • Receives webhooks from TimeRex for confirmed and cancelled bookings
  • Validates requests with security token verification
  • Logs enriched booking data to Google Sheets
  • Sends detailed Slack notifications with AI-generated insights

🛡️ Security & Reliability

  • Token-based webhook authentication
  • Security alerts for unauthorized access attempts
  • Automatic cancellation handling with data cleanup

Use Cases

  • Sales Teams: Automatically categorize leads and prepare meeting briefs
  • Recruitment: Streamline interview scheduling with AI-powered candidate insights
  • Customer Success: Track support meetings and prepare context for calls
  • Media Relations: Manage press interviews with automated briefings

How It Works

  1. TimeRex sends a webhook when a booking is confirmed or cancelled
  2. Security token is verified (failed attempts trigger Slack alerts)
  3. For confirmed bookings:
    • Media source is detected from calendar name
    • Company name is extracted from email domain
    • AI categorizes the booking purpose
    • AI generates a meeting preparation brief
    • Enriched data is saved to Google Sheets
    • Slack notification is sent with AI insights
  4. For cancellations:
    • Booking is found by Event ID
    • Row is deleted from Google Sheets
    • Cancellation alert is sent to Slack

Setup Instructions

  1. Webhook Configuration

    • Copy the webhook URL from the "TimeRex Webhook" node
    • Paste it in TimeRex Settings → Webhook

  2. Security Token

    • Copy your TimeRex security token
    • Update the Verify Security Token node with your token

  3. Google Sheets

    • Create a spreadsheet with these columns: event_id, booking_date, guest_name, guest_email, calendar_name, meeting_url, host_name, media_source, company_name, booking_category, ai_meeting_brief, created_at
    • Update all Google Sheets nodes with your Sheet ID

  4. AI Credentials

    • Connect your Google Gemini API credentials to both AI model nodes

  5. Slack

    • Connect your Slack account
    • Select your notification channel in all Slack nodes

  6. Activate

    • Turn on the workflow and start receiving AI-enhanced booking notifications!

Requirements

  • TimeRex account with webhook access
  • Google Cloud account (for Sheets & Gemini API)
  • Slack workspace
  • n8n instance (self-hosted or cloud)

Customization Tips

  • Modify the Filter by Calendar Type node to match your calendar naming convention
  • Adjust AI prompts in the LLM Chain nodes for different categorization or brief styles
  • Add more media sources to the Media Master sheet for accurate source tracking
  • Extend the workflow with email confirmations or calendar event creation

Short Description (100 characters max)

Automate TimeRex bookings with AI-powered categorization, meeting briefs, and Slack notifications.

Categories

  • Sales
  • Productivity
  • AI
  • Scheduling

Tags

TimeRex, Booking, AI, Google Gemini, Slack, Google Sheets, Automation, Meeting Management, LLM, Scheduling

n8n Workflow: AI-Enriched Timerex Bookings to Google Sheets and Slack with Gemini

This n8n workflow automates the process of receiving new booking data, enriching it with AI, and then logging it to a Google Sheet while also sending notifications to Slack. It leverages Google Gemini for AI enrichment and provides conditional routing based on the AI's output.

What it does

This workflow streamlines booking management by:

  1. Receiving Booking Data: Listens for incoming booking data via a webhook.
  2. AI Enrichment with Google Gemini: Uses Google Gemini to analyze and enrich the incoming booking data, potentially extracting key information or categorizing the booking.
  3. Conditional Routing: Based on the AI's output, it routes the data to different paths.
  4. Logging to Google Sheets: Appends the original and AI-enriched booking data to a specified Google Sheet.
  5. Notifying Slack: Sends a notification to a Slack channel with details of the new booking, including the AI-enriched information.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running instance of n8n.
  • Webhook Source: A system or application (e.g., Timerex or any booking system) configured to send booking data to the n8n webhook URL.
  • Google Sheets Account: A Google account with access to Google Sheets. You'll need to specify the Spreadsheet ID and Sheet Name.
  • Slack Account: A Slack workspace and a channel where notifications will be posted.
  • Google Gemini API Key: Access to the Google Gemini API for the "Google Gemini Chat Model" node.
  • n8n Credentials: Configured credentials for Google Sheets, Slack, and Google Gemini within your n8n instance.

Setup/Usage

  1. Import the Workflow: Import the provided JSON into your n8n instance.
  2. Configure Webhook:
    • Open the "Webhook" node.
    • Copy the "Webhook URL" and configure your booking system to send POST requests with booking data to this URL.
  3. Configure Google Gemini:
    • Open the "Google Gemini Chat Model" node.
    • Select or create your Google Gemini API credential.
    • Review and adjust the prompt in the "Basic LLM Chain" node to suit your enrichment needs.
  4. Configure Google Sheets:
    • Open the "Google Sheets" node.
    • Select or create your Google Sheets OAuth2 credential.
    • Specify the Spreadsheet ID and Sheet Name where you want to log the bookings. Ensure the sheet has appropriate headers for the data you intend to write.
  5. Configure Slack:
    • Open the "Slack" node.
    • Select or create your Slack API credential.
    • Specify the Channel where you want to receive notifications.
    • Customize the message content to include relevant booking and AI-enriched details.
  6. Configure Conditional Logic:
    • Review the "If" node (and potentially the "Switch" node if it's used for more complex routing).
    • Adjust the conditions based on the expected output from the Google Gemini AI to route data as needed.
  7. Activate the Workflow: Once all nodes are configured, activate the workflow.

Now, whenever a new booking is sent to the webhook, the workflow will automatically process it, enrich it with AI, log it to Google Sheets, and send a Slack notification.

Related Templates

Auto-create TikTok videos with VEED.io AI avatars, ElevenLabs & GPT-4

💥 Viral TikTok Video Machine: Auto-Create Videos with Your AI Avatar --- 🎯 Who is this for? This workflow is for content creators, marketers, and agencies who want to use Veed.io’s AI avatar technology to produce short, engaging TikTok videos automatically. It’s ideal for creators who want to appear on camera without recording themselves, and for teams managing multiple brands who need to generate videos at scale. --- ⚙️ What problem this workflow solves Manually creating videos for TikTok can take hours — finding trends, writing scripts, recording, and editing. By combining Veed.io, ElevenLabs, and GPT-4, this workflow transforms a simple Telegram input into a ready-to-post TikTok video featuring your AI avatar powered by Veed.io — speaking naturally with your cloned voice. --- 🚀 What this workflow does This automation links Veed.io’s video-generation API with multiple AI tools: Analyzes TikTok trends via Perplexity AI Writes a 10-second viral script using GPT-4 Generates your voiceover via ElevenLabs Uses Veed.io (Fabric 1.0 via FAL.ai) to animate your avatar and sync the lips to the voice Creates an engaging caption + hashtags for TikTok virality Publishes the video automatically via Blotato TikTok API Logs all results to Google Sheets for tracking --- 🧩 Setup Telegram Bot Create your bot via @BotFather Configure it as the trigger for sending your photo and theme Connect Veed.io Create an account on Veed.io Get your FAL.ai API key (Veed Fabric 1.0 model) Use HTTPS image/audio URLs compatible with Veed Fabric Other APIs Add Perplexity, ElevenLabs, and Blotato TikTok keys Connect your Google Sheet for logging results --- 🛠️ How to customize this workflow Change your Avatar: Upload a new image through Telegram, and Veed.io will generate a new talking version automatically. Modify the Script Style: Adjust the GPT prompt for tone (educational, funny, storytelling). Adjust Voice Tone: Tweak ElevenLabs stability and similarity settings. Expand Platforms: Add Instagram, YouTube Shorts, or X (Twitter) posting nodes. Track Performance: Customize your Google Sheet to measure your most successful Veed.io-based videos. --- 🧠 Expected Outcome In just a few seconds after sending your photo and theme, this workflow — powered by Veed.io — creates a fully automated TikTok video featuring your AI avatar with natural lip-sync and voice. The result is a continuous stream of viral short videos, made without cameras, editing, or effort. --- ✅ Import the JSON file in n8n, add your API keys (including Veed.io via FAL.ai), and start generating viral TikTok videos starring your AI avatar today! 🎥 Watch This Tutorial --- 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube

Dr. FirasBy Dr. Firas
39510

Automate invoice processing with OCR, GPT-4 & Salesforce opportunity creation

PDF Invoice Extractor (AI) End-to-end pipeline: Watch Drive ➜ Download PDF ➜ OCR text ➜ AI normalize to JSON ➜ Upsert Buyer (Account) ➜ Create Opportunity ➜ Map Products ➜ Create OLI via Composite API ➜ Archive to OneDrive. --- Node by node (what it does & key setup) 1) Google Drive Trigger Purpose: Fire when a new file appears in a specific Google Drive folder. Key settings: Event: fileCreated Folder ID: google drive folder id Polling: everyMinute Creds: googleDriveOAuth2Api Output: Metadata { id, name, ... } for the new file. --- 2) Download File From Google Purpose: Get the file binary for processing and archiving. Key settings: Operation: download File ID: ={{ $json.id }} Creds: googleDriveOAuth2Api Output: Binary (default key: data) and original metadata. --- 3) Extract from File Purpose: Extract text from PDF (OCR as needed) for AI parsing. Key settings: Operation: pdf OCR: enable for scanned PDFs (in options) Output: JSON with OCR text at {{ $json.text }}. --- 4) Message a model (AI JSON Extractor) Purpose: Convert OCR text into strict normalized JSON array (invoice schema). Key settings: Node: @n8n/n8n-nodes-langchain.openAi Model: gpt-4.1 (or gpt-4.1-mini) Message role: system (the strict prompt; references {{ $json.text }}) jsonOutput: true Creds: openAiApi Output (per item): $.message.content → the parsed JSON (ensure it’s an array). --- 5) Create or update an account (Salesforce) Purpose: Upsert Buyer as Account using an external ID. Key settings: Resource: account Operation: upsert External Id Field: taxid_c External Id Value: ={{ $json.message.content.buyer.tax_id }} Name: ={{ $json.message.content.buyer.name }} Creds: salesforceOAuth2Api Output: Account record (captures Id) for downstream Opportunity. --- 6) Create an opportunity (Salesforce) Purpose: Create Opportunity linked to the Buyer (Account). Key settings: Resource: opportunity Name: ={{ $('Message a model').item.json.message.content.invoice.code }} Close Date: ={{ $('Message a model').item.json.message.content.invoice.issue_date }} Stage: Closed Won Amount: ={{ $('Message a model').item.json.message.content.summary.grand_total }} AccountId: ={{ $json.id }} (from Upsert Account output) Creds: salesforceOAuth2Api Output: Opportunity Id for OLI creation. --- 7) Build SOQL (Code / JS) Purpose: Collect unique product codes from AI JSON and build a SOQL query for PricebookEntry by Pricebook2Id. Key settings: pricebook2Id (hardcoded in script): e.g., 01sxxxxxxxxxxxxxxx Source lines: $('Message a model').first().json.message.content.products Output: { soql, codes } --- 8) Query PricebookEntries (Salesforce) Purpose: Fetch PricebookEntry.Id for each Product2.ProductCode. Key settings: Resource: search Query: ={{ $json.soql }} Creds: salesforceOAuth2Api Output: Items with Id, Product2.ProductCode (used for mapping). --- 9) Code in JavaScript (Build OLI payloads) Purpose: Join lines with PBE results and Opportunity Id ➜ build OpportunityLineItem payloads. Inputs: OpportunityId: ={{ $('Create an opportunity').first().json.id }} Lines: ={{ $('Message a model').first().json.message.content.products }} PBE rows: from previous node items Output: { body: { allOrNone:false, records:[{ OpportunityLineItem... }] } } Notes: Converts discount_total ➜ per-unit if needed (currently commented for standard pricing). Throws on missing PBE mapping or empty lines. --- 10) Create Opportunity Line Items (HTTP Request) Purpose: Bulk create OLIs via Salesforce Composite API. Key settings: Method: POST URL: https://<your-instance>.my.salesforce.com/services/data/v65.0/composite/sobjects Auth: salesforceOAuth2Api (predefined credential) Body (JSON): ={{ $json.body }} Output: Composite API results (per-record statuses). --- 11) Update File to One Drive Purpose: Archive the original PDF in OneDrive. Key settings: Operation: upload File Name: ={{ $json.name }} Parent Folder ID: onedrive folder id Binary Data: true (from the Download node) Creds: microsoftOneDriveOAuth2Api Output: Uploaded file metadata. --- Data flow (wiring) Google Drive Trigger → Download File From Google Download File From Google → Extract from File → Update File to One Drive Extract from File → Message a model Message a model → Create or update an account Create or update an account → Create an opportunity Create an opportunity → Build SOQL Build SOQL → Query PricebookEntries Query PricebookEntries → Code in JavaScript Code in JavaScript → Create Opportunity Line Items --- Quick setup checklist 🔐 Credentials: Connect Google Drive, OneDrive, Salesforce, OpenAI. 📂 IDs: Drive Folder ID (watch) OneDrive Parent Folder ID (archive) Salesforce Pricebook2Id (in the JS SOQL builder) 🧠 AI Prompt: Use the strict system prompt; jsonOutput = true. 🧾 Field mappings: Buyer tax id/name → Account upsert fields Invoice code/date/amount → Opportunity fields Product name must equal your Product2.ProductCode in SF. ✅ Test: Drop a sample PDF → verify: AI returns array JSON only Account/Opportunity created OLI records created PDF archived to OneDrive --- Notes & best practices If PDFs are scans, enable OCR in Extract from File. If AI returns non-JSON, keep “Return only a JSON array” as the last line of the prompt and keep jsonOutput enabled. Consider adding validation on parsing.warnings to gate Salesforce writes. For discounts/taxes in OLI: Standard OLI fields don’t support per-line discount amounts directly; model them in UnitPrice or custom fields. Replace the Composite API URL with your org’s domain or use the Salesforce node’s Bulk Upsert for simplicity.

Le NguyenBy Le Nguyen
942

Automate RSS to social media pipeline with AI, Airtable & GetLate for multiple platforms

Overview Automates your complete social media content pipeline: sources articles from Wallabag RSS, generates platform-specific posts with AI, creates contextual images, and publishes via GetLate API. Built with 63 nodes across two workflows to handle LinkedIn, Instagram, and Bluesky—with easy expansion to more platforms. Ideal for: Content marketers, solo creators, agencies, and community managers maintaining a consistent multi-platform presence with minimal manual effort. How It Works Two-Workflow Architecture: Content Aggregation Workflow Monitors Wallabag RSS feeds for tagged articles (to-share-linkedin, to-share-instagram, etc.) Extracts and converts content from HTML to Markdown Stores structured data in Airtable with platform assignment AI Generation & Publishing Workflow Scheduled trigger queries Airtable for unpublished content Routes to platform-specific sub-workflows (LinkedIn, Instagram, Bluesky) LLM generates optimized post text and image prompts based on custom brand parameters Optionally generates AI images and hosts them on Imgbb CDN Publishes via GetLate API (immediate or draft mode) Updates Airtable with publication status and metadata Key Features: Tag-based content routing using Wallabag's native system Swappable AI providers (Groq, OpenAI, Anthropic) Platform-specific optimization (tone, length, hashtags, CTAs) Modular design—duplicate sub-workflows to add new platforms in \~30 minutes Centralized Airtable tracking with 17 data points per post Set Up Steps Setup time: \~45-60 minutes for initial configuration Create accounts and get API keys (\~15 min) Wallabag (with RSS feeds enabled) GetLate (social media publishing) Airtable (create base with provided schema—see sticky notes) LLM provider (Groq, OpenAI, or Anthropic) Image service (Hugging Face, Fal.ai, or Stability AI) Imgbb (image hosting) Configure n8n credentials (\~10 min) Add all API keys in n8n's credential manager Detailed credential setup instructions in workflow sticky notes Set up Airtable database (\~10 min) Create "RSS Feed - Content Store" base Add 19 required fields (schema provided in workflow sticky notes) Get Airtable base ID and API key Customize brand prompts (\~15 min) Edit "Set Custom SMCG Prompt" node for each platform Define brand voice, tone, goals, audience, and image preferences Platform-specific examples provided in sticky notes Configure platform settings (\~10 min) Set GetLate account IDs for each platform Enable/disable image generation per platform Choose immediate publish vs. draft mode Adjust schedule trigger frequency Test and deploy Tag test articles in Wallabag Monitor the first few executions in draft mode Activate workflows when satisfied with the output Important: This is a proof-of-concept template. Test thoroughly with draft mode before production use. Detailed setup instructions, troubleshooting tips, and customization guidance are in the workflow's sticky notes. Technical Details 63 nodes: 9 Airtable operations, 8 HTTP requests, 7 code nodes, 3 LangChain LLM chains, 3 RSS triggers, 3 GetLate publishers Supports: Multiple LLM providers, multiple image generation services, unlimited platforms via modular architecture Tracking: 17 metadata fields per post, including publish status, applied parameters, character counts, hashtags, image URLs Prerequisites n8n instance (self-hosted or cloud) Accounts: Wallabag, GetLate, Airtable, LLM provider, image generation service, Imgbb Basic understanding of n8n workflows and credential configuration Time to customize prompts for your brand voice Detailed documentation, Airtable schema, prompt examples, and troubleshooting guides are in the workflow's sticky notes. Category Tags social-media-automation, ai-content-generation, rss-to-social, multi-platform-posting, getlate-api, airtable-database, langchain, workflow-automation, content-marketing

Mikal Hayden-GatesBy Mikal Hayden-Gates
188