Marketplace

Handle real estate SMS inquiries with Twilio, Google Sheets, Gemini, and Calendar

Quick overview Youtube Explanation: https://youtu.be/e_07nGFmVs0 This workflow replies to inbound Twilio SMS messages with property details and viewing scheduling help by looking up leads and properties in Google Sheets, using a Google Gemini agent with Redis chat memory, and checking/booking appointments in Google Calendar. How it works Receives an inbound SMS via Twilio. Looks up the sender’s mobile number in a Google Sheets “leads_info” spreadsheet and appends/updates the lead record if it does not exist, extracting a 4-digit property code from the message when available. Splits any saved semicolon-separated property IDs into individual lookups, fetches matching property rows from a Google Sheets “Property details” spreadsheet, and compiles a summary of found vs. missing property codes. Sends the user message, lead context (saved property IDs and email), current time, and the property-lookup results to a Google Gemini chat agent with Redis-backed conversation memory. Lets the agent optionally use tools to fetch additional property info from Google Sheets, update the lead’s email or interested property IDs in Google Sheets, and check or create viewing events in Google Calendar. S

iamvaar tarafından

Oneclick AI Squad tarafından

Generate structured drama scripts from webhook requests using OpenAI and Google Sheets

Quick overview This workflow accepts a webhook request with a drama topic, genre, tone, and size constraints, uses Python-based genre classification plus OpenAI GPT‑4.1 to generate a full script as structured JSON, then returns the script to the caller and appends a summary log entry to Google Sheets. How it works Receives a POST webhook request containing the script topic, genre, tone, language, act count, and character count. Normalizes inputs by applying defaults, clamping acts to 1–5 and characters to 2–8, and adding request metadata like a request ID and timestamp. Classifies the genre in Python and prepares genre-specific guidance used to shape the script structure, then filters out requests marked as invalid. Sends the prepared parameters and genre guidance to OpenAI (GPT‑4.1) to generate a complete drama script as a single JSON object. Parses and validates the AI response as JSON, falls back to a safe wrapper if parsing fails, and enriches the result with counts for acts, scenes, and characters. Waits briefly and then returns the structured script to the webhook caller while also appending a summary row to a Google Sheets tab for tracking. Setup Configure the Webhook trigge

Oneclick AI Squad tarafından

Send crowd safety SMS reroute alerts with OpenAI, Twilio, and Google Sheets

Quick overview This workflow ingests crowd density and incident reports via webhook or a 5‑minute schedule, assesses risk with Python thresholds, uses OpenAI to generate a short rerouting recommendation, then sends an SMS via Twilio and logs each alert to a Google Sheets heatmap tracker. How it works Triggers when a POST request hits the n8n webhook or every 5 minutes on a schedule. Normalizes incoming fields (location, crowd density, safety score, incidents, traveler contact, and preferences) and fills in defaults when values are missing. Calculates risk level in Python based on configurable thresholds for high density, incident count, and low safety score. Continues only for high-risk items and pauses briefly before the AI call. Uses OpenAI (via an AI agent) to generate a personalized rerouting suggestion under 150 words from the live data and traveler preferences. Sends the rerouting alert to the traveler via Twilio SMS and appends the alert details and reroute text to a Google Sheets log via the Google Sheets API. Setup Add an OpenAI API credential and select the model in the OpenAI Chat Model connection. Configure Twilio credentials (Account SID and Auth Token), replace YOUR_T

Oneclick AI Squad tarafından

Handle theater ticket bookings with Anthropic, Google Sheets, SendGrid, and Twilio

Quick overview This workflow receives theater ticket booking requests via webhook, validates and normalizes them with Anthropic Claude, assigns seats and calculates pricing from a Google Sheets seat map, then logs the booking, sends confirmation via SendGrid email and Twilio SMS, and returns a confirmation JSON response. How it works Receives a booking request via an HTTP POST webhook and standardizes fields like show details, ticket count, and customer contact info. Uses Anthropic Claude to validate and normalize the booking request, then filters out requests with a low validation score. Retrieves the current SeatMap data from Google Sheets and assigns specific seat numbers if enough seats remain in the requested category. Calculates the final ticket total based on seat category pricing, bulk-discount rules, and tax. Uses Anthropic Claude to generate a personalized confirmation message, upsell line, and arrival instructions. Builds a final booking record (including a QR payload string), appends it to a Google Sheets tracker, sends the confirmation by SendGrid email and Twilio SMS, and responds to the webhook with the booking confirmation JSON. Setup Add an Anthropic API credential

Create AI image and video posts from Telegram with GPT-4o, AtlasCloud and Blotato

Quick overview This workflow receives a post idea via Telegram, uses OpenAI (GPT-4o mini) to generate platform-specific copy plus image/video prompts, creates media through AtlasCloud (GPT Image 2 and Seedance 2.0), requests approvals in Telegram, and publishes the approved content to seven social platforms via Blotato. How it works Triggers when a new Telegram message arrives with a post description. Uses OpenAI (GPT-4o mini) to generate copy for X, LinkedIn, Facebook, Threads, Instagram, TikTok, and YouTube Shorts, plus an English image prompt and video prompt. Sends the prompts to AtlasCloud to generate a square image (GPT Image 2) and a vertical short video (Seedance 2.0), polling each prediction until it completes. Sends the generated image and video back to Telegram for preview and asks for approval, automatically regenerating the declined media. Publishes the approved image to X, LinkedIn, Facebook, and Threads via Blotato and confirms completion in Telegram. Publishes the approved video to Instagram Reels, TikTok, and YouTube Shorts via Blotato (with synthetic/AI flags enabled where configured) and confirms completion in Telegram. Setup Create a Telegram bot with BotFather,

Prateeksingh Bais tarafından

Register event attendance via webhook with Google Sheets and Gmail

Quick overview This workflow powers a QR code-based event attendance system. A presenter displays a QR code (generated via the companion web app) which participants scan with their phones. Scanning opens a registration form pre-filled with the Event ID; on submission, the form POSTs to this webhook. How it works Receives a POST request via a webhook secured with Basic Auth. Validates the request body (name, email format, and optional role/event/day) and generates a timestamp plus a target Google Sheets tab name. If validation fails, returns an error JSON response to the caller. Reads all existing rows from the Google Sheets tab for the selected day and checks whether the email address is already registered. If the email is a duplicate, returns an “already registered” JSON response. If the email is new, appends the attendee details to Google Sheets, sends a confirmation email through Gmail, and returns a success JSON response. Setup Configure the webhook Basic Auth credentials and share the webhook URL with the form/app that submits attendance data. Add Google Sheets OAuth2 credentials and update the spreadsheet ID and ensure each day has a matching tab name (for example, “Day 1” ma

Sara Soleymani tarafından

Track brand visibility in ChatGPT results with OpenAI and Google Sheets

Quick overview This workflow runs weekly, reads buyer-style queries from Google Sheets, asks OpenAI Chat Completions (ChatGPT) each query three times, judges whether your brand is mentioned, and writes per-query visibility metrics and a 0–100 score back to a Google Sheets results tab. How it works Runs every week on a schedule trigger. Reads the query set (query, brand, and competitors) from a Google Sheets tab named queries. Duplicates each query into three sample runs to account for variation in OpenAI responses. Sends each sample query to OpenAI Chat Completions (gpt-4o-mini) to generate an answer at temperature 1. Sends the generated answer to a separate OpenAI Chat Completions judge call (gpt-4o-mini) at temperature 0 to extract structured JSON about brand mention, rank, sentiment, recommendation, and competitors mentioned. Aggregates the three judged samples per query to compute inclusion rate, average rank/sentiment, and a weighted 0–100 visibility score. Appends the per-query results (including the run date and metrics) to the results tab in Google Sheets. Setup Add an OpenAI credential for HTTP Header Auth using Authorization: Bearer . Add a Google Sheets credential with a

Generate AI songs from Telegram prompts with OpenAI and Suno

Quick overview This workflow listens for Telegram messages containing a song idea, uses OpenAI to expand the idea into a Suno-ready prompt, submits a generation request to the Suno API, polls until the track is ready, and then sends the finished audio and details back to the user in Telegram. How it works Triggers when a user sends a message to your Telegram bot. Captures the message text and chat ID, applies default generation settings, and sends an acknowledgment message back on Telegram. Uses OpenAI to rewrite the short idea into a concise, Suno-optimized music prompt based on your style preferences. Submits the enriched prompt to the Suno API to start generating a song. Waits for a configured interval, checks the Suno generation status, and repeats polling until the status is SUCCESS. Sends the generated audio URL to the user as a Telegram audio message and follows up with a completion message including the title and duration. Setup Create and select a Telegram Bot credential for the Telegram trigger and the Telegram send-audio/message steps. Add an OpenAI API credential for the OpenAI chat model used to enrich the prompt. Create an HTTP Header Auth credential for the Suno API

Explain prescription PDFs for patients with GPT-4o-mini, Gmail and Google Sheets

Quick overview This workflow collects a patient’s prescription PDF via an n8n form, extracts its text, uses OpenAI (gpt-4o-mini) to generate a plain-language medicine-by-medicine explanation in the chosen language, emails the result via Gmail, and logs each processed prescription to Google Sheets. How it works Receives a form submission with the patient’s name, email, preferred language, optional doctor/health notes, and a prescription PDF upload. Extracts selectable text from the uploaded PDF. Validates required fields, checks that the PDF contains readable text, and truncates/cleans the extracted content for the AI prompt. Sends the prescription text and context to OpenAI Chat Completions (gpt-4o-mini) and requests a structured JSON explanation of each medicine in the selected language. Parses and validates the returned JSON, ensuring at least one medicine is found and merging the AI output with the patient context. Appends an audit row (date, patient details, doctor, medicine count, language, status, processed time) to a Google Sheets “Log” worksheet. Builds a formatted HTML email with the medicine explanations and disclaimer, then sends it to the patient using Gmail. Setup Add

Incrementors tarafından

Create and publish AI video reels to Instagram from Telegram with OpenAI and AtlasCloud

Quick overview This workflow turns a Telegram message into an AI-generated vertical video using AtlasCloud Seedance 2.0, generates an Instagram-ready caption with OpenAI, publishes the reel via Blotato, and sends a Telegram confirmation with the published video URL. How it works Triggers when a new message is received by your Telegram bot. Uses OpenAI to expand the message into a short, visually descriptive 9:16 text-to-video prompt. Sends the prompt to AtlasCloud (Seedance 2.0) to generate a vertical video with the configured size, duration, and FPS. Waits and polls AtlasCloud for the prediction status until the video completes. Uses OpenAI to write a playful Instagram caption with 3–5 hashtags based on the video prompt. Publishes the generated video URL as an Instagram Reel through Blotato using the generated caption. Sends a Telegram message confirming the Reel is published and includes the final video URL. Setup Create a Telegram bot and add your Telegram credentials to both the trigger and the notification steps. Add an OpenAI API credential and select it for both prompt and caption generation. Create an AtlasCloud API key and configure an HTTP header auth credential (Authoriz

Transcribe WhatsApp voice notes and auto-reply with OpenAI Whisper and GPT-4o

Quick overview This workflow receives WhatsApp Cloud API webhook events, transcribes incoming voice notes with OpenAI Whisper, generates a reply with OpenAI GPT-4o, and sends the response back to the sender via the WhatsApp Graph API while also handling plain text messages. How it works Receives WhatsApp webhook requests for verification (GET) and incoming messages (POST) from the Meta WhatsApp Cloud API. Validates the webhook verify token and returns the hub challenge to complete Meta webhook verification. Parses the inbound webhook payload to extract the sender number, phone number ID, message type, and either text content or an audio media ID. For voice notes, calls the WhatsApp Graph API to resolve the media ID to a temporary download URL, downloads the audio file, and transcribes it to text with OpenAI Whisper. For text messages, uses the incoming text directly as the user prompt. Sends the message text to OpenAI GPT-4o with a system prompt to generate a concise reply in the same language. Posts the generated reply back to the user using the WhatsApp Graph API messages endpoint and returns an OK response to the webhook. Setup Create a Meta app with WhatsApp Cloud API enabled,

Taseeb Saeed tarafından

Kristian Jønsson tarafından

Generate studio product photos for new Shopify products with Dreem AI

Quick overview This workflow triggers on new Shopify products, generates studio-style product shots from one product image using Dreem.ai and appends the rendered images back to the Shopify product listing, with optional Slack posting and approval before publishing. How it works A Shopify webhook fires when a product is created. Products without a photo are skipped. he Dreem node generates your chosen shot types (defaults: flat lay + ghost mannequin) from the product's first image. Sends the product’s first image (and optionally a second/back image URL) to Dreem AI to generate the configured product shot types and provides an n8n callback URL. Waits for Dreem AI to call back with the render result and verifies the render status is completed. Optionally posts the generated image links to Slack and waits for an Approve/Reject response. Finished shots are appended to the product, keeping existing photos. An optional second row renders back-view shots from the product's second image. Setup Install the Dreem community node and add a Dreem API key credential (dreem_pk_...) to the Dreem generate nodes. Add a Shopify Admin access token credential with read_products and write_products scope

Generate AI selfie photos from Telegram with AtlasCloud and Blotato

Quick overview This workflow listens for a two-photo Telegram album, uploads both images to Blotato for public hosting, sends them with a caption prompt to AtlasCloud (Nano Banana 2 Lite) to generate an edited “AI selfie,” then posts the result to Instagram and Facebook and replies with the image on Telegram. How it works Triggers when a Telegram bot receives a message and buffers album uploads until it has two photos plus the caption text. Stores the caption as the edit prompt and sets generation options such as model, aspect ratio, output format, and poll interval. Downloads each photo from Telegram and uploads both to Blotato to obtain stable public image URLs. Sends the two hosted image URLs and the prompt to the AtlasCloud generateImage API using the Nano Banana 2 Lite edit model. Waits and polls the AtlasCloud prediction status until it is marked completed or succeeded. Extracts the generated image URL, publishes it to Instagram and Facebook via Blotato, and sends the generated photo back to the originating Telegram chat. Setup Create a Telegram bot and add your Telegram API credentials to the Telegram Trigger and Telegram nodes. Add an AtlasCloud API key as an HTTP Header Au

Infraweb Poland tarafından

Score and triage job candidates with OpenAI o3-mini (OpenRouter) and ClickUp

Quick overview This workflow collects candidate CVs through an n8n Form, extracts text from a PDF, uses OpenRouter (OpenAI o3-mini) to score and summarize the candidate, and creates a ClickUp task with the evaluation for recruiter review. How it works Receives a CV submission through an n8n Form trigger (PDF upload plus message, captcha question, and consent). Extracts text content from the uploaded PDF CV. Validates that the CV text exists, the captcha answer is correct, and the candidate consent field is set to “I agree”. Sends the CV text and the candidate’s optional message to an OpenRouter chat model (openai/o3-mini) to generate a score, suggested best-fit role, and a short summary. Creates a new ClickUp task containing the AI output so the recruiting team can review the candidate. Setup Configure the n8n Form trigger fields and publish the form, then share the generated form URL with candidates. Add an OpenRouter API credential for the OpenRouter chat model used to score and summarize candidates. Add a ClickUp OAuth2 connection and select the target Workspace/Space/Folder/List in the ClickUp task creation step where candidates should be added.

Summarize Slack threads into Jira tickets with OpenRouter and Slack approval

Quick Overview This workflow turns a Slack slash-command request into an AI-drafted Jira ticket preview, then creates the Jira issue only after a user approves it in Slack using interactive buttons. How it works Receives a Slack slash command via a webhook and immediately responds with an ephemeral acknowledgement message. Reads configuration values (message count, Jira project key/type, and Slack context) and fetches recent messages from the Slack channel using the Slack conversations.history API. Cleans and formats the Slack messages into a chronological transcript, returning an error payload if no usable messages are found. Sends the transcript to an OpenRouter chat model (via an n8n AI agent) to generate a structured Jira ticket draft JSON. Parses the draft JSON and posts an ephemeral Slack preview containing the proposed title, type, priority, description, acceptance criteria, and Approve/Cancel buttons. Receives the Slack button interaction via a second webhook, parses the interaction payload, and either creates a Jira issue or cancels the request. Updates the Slack preview message to confirm ticket creation or show a cancellation notice. Setup Create a Slack app and configur

Salim BRAHMI tarafından

Extend videos with audio using Fal, OpenAI, and Upload-Post for TikTok

Quick overview This workflow accepts a video URL and prompt, uses Fal.ai (ltx-2.3-quality) to extend the video forward with generated audio, generates an SEO-friendly title with OpenAI, downloads the finished video, and uploads it to TikTok via the Upload-Post API. How it works Triggers from either an n8n Form submission or an incoming Webhook request containing video_url and prompt. Sends the video URL and prompt to Fal.ai’s ltx-2.3-quality extend-video endpoint to start an asynchronous high-quality render with audio generation enabled. Waits 60 seconds and repeatedly polls Fal.ai’s queue status endpoint until the job status returns COMPLETED. Fetches the completed Fal.ai request details to retrieve the final generated video URL. Sends the original prompt to OpenAI (GPT-5) to generate a short, clickable, SEO-oriented video title. Downloads the generated video file and uploads it to Upload-Post with the generated title, targeting the TikTok platform. Setup Add a Fal.run API credential (HTTP Header Auth) and confirm the extend-video and status/request URLs match your Fal.ai account and model. Add an OpenAI API credential and, if needed, change the model in the title-generation step.

Davide Boizza tarafından

Draft Google review reply emails with Gmail, OpenAI, and Google Sheets

Quick Overview This workflow monitors Gmail for Google Business Profile “new review” alert emails, uses OpenAI to extract the rating and review text and draft a policy-safe reply, then emails the draft to you and logs the review and reply draft to Google Sheets. How it works Triggers when a new Google Business Profile review notification email arrives in Gmail. Looks up the email’s message ID in a Google Sheets ledger to prevent drafting duplicate replies. Sends the email content and your configured business details to OpenAI to extract the rating, reviewer first name, and review text and generate a reply draft as structured JSON. Emails you a formatted message containing the review excerpt, the suggested reply, and a link to your Google reviews page. Appends a new row to Google Sheets with the message ID, extracted review details, the reply draft, a timestamp, and a “draft-sent-to-owner” status. Setup Connect your Gmail account and ensure Google review alerts are delivered from [email protected]. Add an OpenAI API key/credential and select the chat model in the OpenAI node. Create a Google Sheets “reply ledger” with columns like processed_at, gmail_message_id, rat

43 Sunsets tarafından

Anakhuagbor Sule tarafından

Vet community membership applications with Google Gemini, Telegram, and Sheets

Quick overview This workflow collects community membership applications via an n8n Form, vets each candidate with Google Gemini using Tavily web search and an Apify LinkedIn lookup, requests human approval in Telegram when needed, sends invite or rejection emails via Gmail, and logs outcomes to Google Sheets. How it works Receives a submission from an n8n Form that captures applicant details such as name, email, company, role, birthday, and additional notes. Normalizes the submitted fields and passes the candidate profile to a Google Gemini-powered AI Agent that can use Tavily web search, an Apify LinkedIn search actor, a calculator, and short-term memory. Produces a structured vetting result (including summary, decision status, and a community-fit score) using a structured output schema. If the AI decision is “Immediate approval”, sends the candidate summary to Telegram and waits for a response before continuing. If the AI decision is not “Immediate approval”, sends the summary to Telegram and asks the reviewer to reply with 1 (approve), 2 (reject), or 3 (do nothing). Sends an approval/invite email or a rejection email via Gmail based on the Telegram response, or stops without act

Precision Tech tarafından

Route ecommerce review alerts from Gmail to Slack with OpenAI and Google Sheets

Quick Overview This workflow polls Gmail for unread ecommerce review notification emails, extracts key review details, checks Google Sheets to prevent duplicate processing, uses OpenAI to classify sentiment and urgency, posts routed alerts to Slack, and logs each processed review and its AI metadata back to Google Sheets. How it works Polls Gmail every minute for unread emails with the “Reviews” label. Extracts the message ID, received time, customer details, product name, star rating, and review text from the email content. Reads the existing review audit log from Google Sheets and skips processing if the message ID already exists or the review text is too short. Sends the review details to OpenAI to return a JSON classification with sentiment, urgency, themes, summary, suggested action, and a sentiment score. Routes the review based on sentiment and urgency, escalating low-star or high-urgency negative reviews and optionally notifying on positive reviews. Posts a formatted alert to the selected Slack channel when notification is enabled. Appends the review (including route, AI fields, and whether Slack was notified) to Google Sheets as an audit log. Setup Create a Gmail label (fo

Aslamul Fikri Alfirdausi tarafından

Run Bunker Guard NPC chat and RAG lore checks with Google Gemini and Google Drive

Quick overview This workflow powers dynamic character interactions for investigative games. It ingests lore from Google Drive into a vector database, using Google Gemini agents to generate daily briefings, spawn NPCs, and roleplay interrogations via a webhook. How it works Runs on a manual trigger to download a lore PDF from Google Drive, split it into chunks, create Google Gemini embeddings, and store them in an in-memory vector store for retrieval. Receives a POST webhook request from the game client containing game state and an action value (briefing, init, or chat). Routes the request based on action to either generate a morale-based daily intel briefing, create a new NPC profile for the day, or generate an in-character reply to the player’s interrogation message. When factual lore is needed (routes, locations, prices, rules, professions), the Gemini agent queries the Database_Bunker vector-search tool to ground the response in the ingested PDF. Maintains short conversation context per player using a buffer memory keyed by playerId for ongoing chat and NPC interactions. Returns the agent output to the caller as clean JSON via the webhook response. Optionally, triggers on an n8n

Notify new Jumia orders with Telegram and WhatsApp Cloud API alerts

Quick Overview This workflow polls the Jumia Vendor API for recent orders, formats each new order into a readable alert, and sends notifications to both Telegram and WhatsApp, while tracking processed order IDs in an n8n Data Table to prevent duplicate messages. How it works Runs manually or on a 5-minute schedule to start the order-check process. Requests an access token from the Jumia Vendor API using a refresh token. Fetches recent orders from the Jumia Vendor API and normalizes the order data into a consistent structure. Checks an n8n Data Table to skip any orders that have already been processed. Formats a detailed notification message containing order, customer, totals, and shipping information. Sends the notification to a Telegram chat and then sends the same message via the WhatsApp Cloud API. Inserts the order ID and metadata into the n8n Data Table to mark the order as processed. Setup Provide your Jumia Vendor API values (client_id, refresh_token, and seller ID) in the HTTP request and normalization steps. Create an n8n Data Table named jumia_processed_orders with columns seller_id, marketplace, order_id, status, first_seen, notified_at, and raw_payload. Add Telegram cre

Taiwo Hassan tarafından

Create the newest Microsoft Entra user in Seventhings

Quick overview This workflow pulls user profiles from Microsoft Entra ID, selects the most recently created user, and creates a matching person record in seventhings with their name, email, and department. How it works Starts manually (or via a trigger you replace) to initiate the sync. Retrieves all users from Microsoft Entra ID with key profile fields like created date, name, email, and department. Sorts the users by creation time to identify the newest account. Keeps only the single most recently created user. Creates a person in seventhings using the Entra user’s first name, last name, email (userPrincipalName), and department. Setup Add a Microsoft Entra ID (Azure AD) OAuth2 credential with permission to read users. Add a seventhings API credential for your seventhings instance. Replace the manual trigger with your preferred trigger (for example, a schedule) if you want this to run automatically. Check the results and see if the users are created.

Henry Rausch tarafından