Skip to content
FlowHubFluxonLab

Marketplace

İndirebileceğin 3.557 hazır workflow dosyası, artı 10.661 kaynağa bağlı n8n referansı.

sheetswhatsappbusinesscloud
free

Send daily appointment reminders from Google Sheets to WhatsApp

Quick overview This workflow runs daily to read appointment bookings from Google Sheets, filter for tomorrow’s appointments that have not been reminded yet, send each client a WhatsApp reminder message, and then update the sheet to mark the reminder as sent. How it works Runs every day at 9 AM on a schedule. Sets the Google Sheet ID, sheet tab name, WhatsApp phone number ID, and calculates tomorrow’s date. Reads all appointment rows from the specified Google Sheets tab. Filters to appointments where the appointment_date is tomorrow and reminder_sent is not true. Sends a WhatsApp message to each remaining client using their phone_number and appointment details. Updates the corresponding Google Sheets row (matched by row_id) to set reminder_sent to true. Setup Add Google Sheets OAuth credentials and set the target spreadsheet ID and sheet/tab name in the configuration values. Add WhatsApp Business Cloud (WhatsApp) credentials and set your WhatsApp phone number ID used to send messages. Ensure your Google Sheet includes the columns row_id (unique), client_name, phone_number, service, appointment_time, appointment_date (yyyy-MM-dd), and reminder_sent (boolean).

Kanishka Shrivastava tarafından
Csheets
free

Extract meeting decisions and action items with LDX hub (Gemini) and Google Sheets

Quick overview This workflow collects a meeting-minutes PDF via an n8n form, uses LDX hub (Gemini) to segment it by agenda and extract decisions and action items, then appends each item as a row in Google Sheets. How it works Receives a PDF upload through an n8n form submission trigger. Sends the document to LDX hub AnalyzeDoc (Google Gemini) to split the minutes into agenda-topic segments and return them as structured JSON — a topic that spans multiple pages stays in one segment. Converts the agenda segments into a JSONL batch so each segment can be processed independently. Sends the batch to LDX hub StructFlow (Google Gemini) to extract every decision and action item with owner and due date per agenda segment. Expands the extracted results into one row per decision/action item with agenda context. Appends the rows to a selected Google Sheets worksheet. Setup Install the n8n-nodes-ldxhub community node and create an LDXhub API credential. Create a Google Sheet with columns: agenda_no, agenda_title, item_type, item, owner, due_date. Add a Google Sheets OAuth2 credential and select the target spreadsheet and sheet in the append step. Activate the workflow and use the generated form

Hideki Mori tarafından
ACsheetsmicrosoftoutlook
free

Track RSS events with OpenAI GPT-4.1-mini, Google Sheets, and Outlook

Quick overview This automated pipeline monitors an RSS feed, leverages an OpenAI chat model to extract event details into structured JSON, logs the data to Google Sheets, and triggers real-time email notifications via Microsoft Outlook. How it works Trigger: An RSS node polls the specified feed every minute to detect new entries. Batching: A Loop node isolates each RSS item to ensure accurate, individual processing without data overlap. AI Extraction: An AI Agent, powered by OpenAI, extracts the event title, date, URL, and description, formatting the output strictly as JSON. Sanitization: A custom JavaScript Code node cleans the LLM response by stripping markdown blocks and parsing the JSON object. Database Logging: The Google Sheets node maps the parsed keys and appends a new row for the event. Alerting: An Outlook node dispatches an automated notification email, and the loop continues for the next item. Setup Configure the RSS Feed Trigger by pasting your target feed URL. Add your OpenAI API credentials to the OpenAI Chat Model node (verify your specific model identifier, e.g., gpt-4o-mini Authenticate the Google Sheets node via OAuth and select your destination spreadsheet and w

Swapnil Mandloi tarafından
CsheetsW
free

Log nearby businesses from OpenStreetMap to Google Sheets by proximity

Quick overview This workflow collects a location and business search criteria via an n8n form, geocodes the location with OpenStreetMap Nominatim, finds nearby matching businesses using the Overpass API, and appends normalized results (including website availability) to a Google Sheets spreadsheet. How it works Receives a submission from an n8n form with a location, business category, search radius, and maximum results. Sends the location text to OpenStreetMap Nominatim to retrieve latitude and longitude coordinates. Stops if the location cannot be geocoded, preventing an invalid proximity search. Builds an Overpass QL query for the selected business category and radius around the geocoded coordinates. Calls the OpenStreetMap Overpass API to return matching nodes/ways and their tags (for example website, phone, and opening hours). Normalizes the returned elements into a consistent set of fields, flags whether a website is present, and appends the rows to Google Sheets. Setup Add a Google Sheets credential and select the target spreadsheet and sheet in the Google Sheets append step. Update the User-Agent value to include a real contact email to comply with OpenStreetMap usage policy

Kevin Yu tarafından
CWnotion
free

Post a daily project health standup to Slack with Notion and Groq

Quick overview This workflow runs every morning, reads yesterday’s standup and today’s active projects from Notion, uses Groq (OpenAI-compatible chat completions) to generate a red/yellow/green project health standup, posts it to Slack, and saves the new standup back to Notion for tomorrow. How it works Runs every day at 7:30 AM on a schedule. Reads the previous standup digest from a Notion “memory” database row and fetches all “Active” projects from a Notion projects database. Builds a prompt that includes yesterday’s digest plus today’s project notes, last update dates, and next milestone dates. If there are no active projects, posts an “All quiet” message to a Slack channel. If there are active projects, sends the prompt to Groq’s chat completions endpoint to score projects as Red/Yellow/Green and list changes since yesterday. Posts the generated standup text to Slack and updates the Notion memory row with today’s digest and timestamp. Setup Add a Notion credential and set the database IDs for your Projects database and the single-row Memory database used to store the daily digest. Create a Groq API header-auth credential (Authorization: Bearer ) for the Groq chat completions re

Kevin Yu tarafından
W
free

Look up Brazilian company data by CNPJ with forms and Minha Receita API

Quick overview This workflow hosts an n8n form that accepts a Brazilian CNPJ, validates and normalizes the input, then queries the public Minha Receita API to fetch company registration details and displays either a formatted results page or an error page with a link back to the form. How it works Receives a CNPJ through an n8n form submission. Sets the base URL for the Minha Receita API and the redirect URL used by the “Search Again” button. Removes punctuation from the CNPJ and validates that it contains exactly 14 digits. Requests company data from the Minha Receita API endpoint for the cleaned CNPJ. Displays a results form with key company fields (for example, status, CNAE, partners, and address) when the API returns data. Displays an error form when the CNPJ format is invalid or the API request fails, then redirects back to the input form. Setup Activate the workflow and copy the Production URL from the form trigger. Paste that URL into the Set URL step (replace REPLACE_WITH_PRODUCTION_FORM_URL) so completion pages can redirect users back to the search form. Ensure outbound HTTP access to https://minhareceita.org/ from your n8n instance, since the workflow relies on the public

EximiaAI tarafından
CgoogledriveW
free

Generate SRT and VTT subtitles from media URLs with Gladia and Google Drive

Quick Overview This workflow collects a public media URL via an n8n form, sends it to Gladia to generate SRT and VTT subtitles, uploads the subtitle files to Google Drive, and returns Drive download links back in the form completion page. How it works Receives a media URL (and optional title) from an n8n Form Trigger. Submits the media URL to the Gladia pre-recorded transcription API with subtitles enabled for SRT and VTT output. Waits and repeatedly polls Gladia for the job result until the status is done, or stops and fails if Gladia returns an error or the max-attempt limit is reached. Extracts the SRT and VTT subtitle tracks from Gladia’s response, builds each one into a file, and stops with an error message if no subtitle tracks are returned. Uploads the generated subtitle files to a specified Google Drive folder. Displays a completion message in the form response containing the Google Drive links for the SRT and VTT files. Setup Create an HTTP Header Auth credential for Gladia (header name x-gladia-key) and select it for the Gladia API request steps. Connect a Google Drive OAuth2 credential and set the destination folder ID used for uploading subtitle files. Update the pollin

Kevin Yu tarafından
Cgmailgooglecalendarsheets
free

Calculate litigation deadlines from intake forms with Google Calendar, Sheets, Slack and Gmail

Quick Overview This workflow collects litigation matter intake details via an n8n form, calculates limitation and procedural deadlines using a built-in rules table, then creates deadline and reminder events in Google Calendar, logs each deadline to Google Sheets, and sends a summary via Slack and Gmail. How it works Receives a submission from an n8n form with the matter details, jurisdiction, claim type, and trigger dates. Loads the configured limitation rules, procedural rules, holidays, reminder offsets, and target Google Calendar/Google Sheets/Slack/email settings. Calculates limitation and procedural due dates (and any review notes) from the provided dates, rolling deadlines off weekends/holidays and generating reminder dates. Appends each calculated deadline record to a Google Sheets register. Creates an all-day Google Calendar event for each calculated deadline and separate all-day events for each upcoming reminder offset. Posts a consolidated deadline summary to a Slack channel and emails the same summary via Gmail to the responsible lawyer (or a fallback team email). Setup Connect credentials for Google Calendar, Google Sheets, Slack, and Gmail. In the rules/settings step,

Kevin Yu tarafından
CsheetsW
free

Track recurring job pain points with SerpApi, Gemini, and Google Sheets

Quick Overview This workflow runs weekly to pull Google Jobs results via SerpApi, uses Google Gemini to extract operational pain points and an automation opportunity from each posting, logs them to Google Sheets, and writes a frequency-ranked pain-point summary to a summary tab. How it works Runs weekly on a schedule. Sets the target job role, location, and Google Sheets tab name to use for this run. Queries Google Jobs through SerpApi and splits the response into one item per job posting. Sends each posting’s title, company, and description to Google Gemini and parses the returned JSON into structured fields. Appends each analyzed posting (company, title, pain points, automation opportunity, and collection date) as a new row in Google Sheets. Reads all rows from the same Google Sheets tab, counts how often each pain-point phrase appears, and sorts the list by frequency. Appends the ranked pain-point frequency list to a Google Sheets "summary" tab. Setup Add a SerpApi API key and update the SerpApi request parameters in the HTTP request step (or store the key in an n8n credential). Connect a Google Sheets OAuth2 credential and replace the placeholder spreadsheet URL/ID with your ow

Ayaan Sheikh tarafından
CsheetsW
free

Track buyer query citation sources with GPT-4o and Google Sheets

Quick overview This workflow tracks which sources ChatGPT cites for buyer queries.vIt runs weekly to test buyer queries against OpenAI’s GPT-4o web search, extracts the cited URLs, and logs per-query citation counts and domain classifications to Google Sheets. How it works Runs every week on a schedule trigger. Reads a list of buyer queries (including brand and competitor context) from the queries tab in Google Sheets. Sends each query to OpenAI’s gpt-4o-mini-search-preview three times with web search enabled and extracts the url_citation annotations from each response. Aggregates citations per query and domain, calculating citation totals and a sample hit rate across the three runs. Sends the unique cited domains to OpenAI’s gpt-4o-mini to classify each domain into a source taxonomy (brand site, competitor site, review platform, community, publisher, or docs/other). Appends the aggregated rows with the domain classification and an example URL to the citations tab in Google Sheets. Setup Add an OpenAI API key as an HTTP Header Auth credential (Authorization: Bearer YOUR_KEY) for both OpenAI HTTP requests. Add a Google Sheets credential with access to the target spreadsheet. Create

Sara Soleymani tarafından
ACgmailsheets
free

Route WhatsApp support requests with Groq, Google Sheets, Gmail, Telegram and AiSensy

Quick overview This workflow receives incoming WhatsApp messages via an n8n webhook, loads an FAQ knowledge base from Google Sheets, and uses Groq (Llama 3.3) to classify intent and generate a reply. It sends the response through the AiSensy API, logs the conversation to Google Sheets, and alerts via Gmail and Telegram. How it works Receives a POST request from AiSensy on a WhatsApp webhook when a customer sends a message. Extracts the customer phone, name, message text, and timestamp, and ignores requests missing required fields. Loads FAQ question-and-answer rows from Google Sheets and sends them with the customer message to Groq (Llama 3.3) to classify intent, detect language and urgency, and draft a reply. Parses and validates the model’s JSON output and formats a safe fallback reply if parsing fails. Sends the generated reply back to the customer using the AiSensy WhatsApp API. Sends a Gmail alert when the intent is COMPLAINT and posts a Telegram alert when the intent is ESCALATE. Appends or updates a conversation log row in Google Sheets and returns a 200 OK webhook response. Setup Configure AiSensy to send message events to this workflow’s webhook URL (path: /whatsapp-suppor

Utkarsh Kapoor tarafından
airtableW
free

Run AI voice outreach from Airtable with Bolna, Groq, Brevo and AiSensy

Quick overview This workflow runs daily and pulls outreach contacts from Airtable, calls each coordinator using Bolna.ai, and analyzes the call transcript with Groq. Based on the outcome, it sends tailored follow-up emails via Brevo and updates call status, last-called date, and attempt count back in Airtable. How it works Runs every day at 11 AM IST on a schedule. Searches Airtable for contact records that have a coordinator phone number and processes them one by one. Skips contacts that were called in the last 3 days or are already marked Interested, Not Interested, or Dead Contact. Places an outbound AI voice call through Bolna.ai, waits 180 seconds, and then fetches the call status and transcript from Bolna. If the call is answered (a transcript exists), sends the transcript to Groq (Llama 3.3) to classify the outcome as Interested or Not Interested. Sends the matching follow-up email via Brevo and updates the Airtable record with the outcome, last-called date, and incremented call attempts. If the call is not answered, sends a “No Answer” email via Brevo and updates Airtable on the first attempt, or sends a final “Dead Contact” email and marks the record Dead Contact on the se

Utkarsh Kapoor tarafından
CWmcpclient
free

Transform uploaded documents into structured data with Unstructured MCP

Quick overview This workflow collects an uploaded document via an n8n form and uses Unstructured’s hosted Transform MCP server to convert it into structured, LLM-ready text output, then returns the extracted content and basic stats (elements, characters) while handling size limits and transform job polling. How it works Receives a document upload through an n8n form trigger. Checks whether the uploaded file is within the 50 MB limit and shows a “File too large” completion page if it exceeds the cap. Requests a pre-signed upload URL from Unstructured Transform MCP and uploads the file bytes to that URL via HTTP PUT. Starts a transform job in Unstructured Transform MCP, then polls the job status every 5 seconds until it completes or fails. When the job completes, fetches the transform results metadata from Unstructured and verifies a download URL is available. Downloads the extracted output from the signed download URL and returns a formatted response containing the status, source filename, output stats, and extracted content (or a “No content could be extracted” message). Setup Create an Unstructured Transform account and generate an API key, then add it to n8n as an HTTP Bearer Aut

Unstructured tarafından
C
free

Post daily e-commerce market news from Google News RSS to LinkedIn

Quick overview This workflow runs daily at 9 AM to pull the latest “E-commerce Market” headline from Google News RSS, formats it into a text-only LinkedIn post with a link and hashtags, and publishes it to a LinkedIn personal profile. How it works Runs every day at 9:00 AM based on the schedule trigger. Fetches recent articles for the “E-commerce Market” query from Google News RSS. Sorts the RSS items by publish date and keeps only the newest article. Stops the run if the selected item has no title to avoid posting empty content. Builds the LinkedIn post text by cleaning the title, extracting the source, and appending the article link and hashtags. Creates a text-only post on LinkedIn as the configured person profile. Setup Create or select a LinkedIn OAuth2 credential in n8n and assign it to the LinkedIn node. Replace the placeholder Person URN with your LinkedIn Person URN (for example, urn:li:person:xxxxxxxx) in the LinkedIn post configuration. Confirm the schedule time (9 AM server timezone) and adjust it if needed before activating the workflow.

Muhammed Adnan Vv tarafından
BCgmailsheets
free

Log email receipts to Google Sheets with Gmail and OpenAI

Quick Overview This workflow logs Gmail receipt attachments to Google Sheets by extracting structured fields with OpenAI (including category selection from your list), prevents duplicates by checking the ledger, and sends a monthly spending summary email via Gmail based on last month’s rows. How it works Triggers when a Gmail message matching has:attachment subject:receipt arrives or when a schedule runs on the 1st of the month at 8am. For receipt emails, looks up the Gmail message ID in Google Sheets and stops if the receipt is already logged. If the receipt is new, extracts text from PDF attachments or transcribes image receipts using OpenAI vision. Sends the receipt text to OpenAI to extract receipt_date, merchant, amount, currency, and a category chosen only from your predefined category list. Appends one cleaned expense row to Google Sheets with the extracted fields plus a processed timestamp, Gmail message ID, and the original email subject. For the monthly run, reads the full Google Sheets ledger, totals last month’s expenses by category, and emails the summary to you via Gmail. Setup Connect Gmail credentials for the Gmail Trigger and for sending the monthly summary email.

43 Sunsets tarafından
BCWnotion
free

Save Amazon reviews to Notion with ScraperAPI and OpenAI GPT-5 Mini

Quick Overview This workflow runs every Monday to scrape recent Amazon product reviews via ScraperAPI, uses OpenAI to classify sentiment and feature tags, and then saves each new review into a Notion database with structured properties and a formatted page body. How it works Runs every Monday at 8am and loads a configured watchlist of Amazon ASINs plus Notion and locale settings. Fetches Amazon product data (including recent reviews) for each ASIN using ScraperAPI. Extracts reviews from each response and only forwards reviews that have not been seen in previous runs, capped per ASIN. Sends each new review to OpenAI to return a JSON sentiment label, 1–4 feature tags, and a one-sentence summary. Normalizes the AI output, clips long review text to fit Notion limits, and converts the review date into an ISO date. Creates a new page in the target Notion database for each review, filling properties like Sentiment, Stars, Feature tags, Product, Review date, and metadata. Setup Add ScraperAPI credentials and ensure the ScraperAPI Amazon Product (SDE) endpoint is available for your account. Add Notion API credentials, share the target database with your Notion integration, and copy the data

ScraperAPI tarafından
Cgmailgoogledocs
free

Turn customer emails into FAQ drafts with Gmail, Gemini, Docs and Sheets

Quick overview This workflow monitors customer-support emails in Gmail, uses Google Gemini to extract FAQ-ready questions and draft answers, logs every candidate to Google Sheets, and routes strong candidates to a Google Docs draft while sending unclear or sensitive messages to a Gmail draft for manual review. How it works Triggers every 5 minutes when Gmail finds new messages matching the configured support-style search query. Cleans and normalizes the email metadata and body text to remove signatures and quoted replies. Sends the normalized email content to Google Gemini to extract the customer question, category, urgency, FAQ value score, draft answer, and a recommended action as structured JSON. Logs the extracted FAQ candidate details (including score, tags, and sensitivity flags) to a Google Sheets tab for tracking. Creates a Google Docs FAQ draft and inserts the generated draft content when the candidate meets the score threshold or is marked as reusable. Creates a Gmail draft to the reviewer with the Google Docs link for high-value candidates, or a separate Gmail draft containing review notes for sensitive or unclear emails. Setup Connect credentials for Gmail, Google Gemin

uninc000 tarafından
sheets
free

Schedule social media posts from a Google Sheets content calendar via PostFast

Quick Overview This workflow runs every morning to read a Google Sheets content calendar, filter for posts marked ready and scheduled in the future, schedule them in PostFast, and then update the sheet to mark each row as scheduled. How it works Runs every day at 7:00 AM using a schedule trigger. Reads all rows from a Google Sheets content calendar. Keeps only rows where the status is ready and the scheduledAt time is at least 10 minutes in the future. Creates scheduled posts in PostFast using each row’s content, scheduled time, and social account ID. Updates the corresponding Google Sheets rows to set status to scheduled so they are not scheduled again. Setup Install and enable the PostFast community node (n8n-nodes-postfast) and add your PostFast API key credentials. Add your Google Sheets credentials and select the target spreadsheet and sheet in both Google Sheets steps. Ensure your sheet includes content, scheduledAt (ISO date-time), accountId (PostFast social account ID), and status columns, and set status to ready for rows you want to schedule. Confirm the Google Sheets update step matches rows correctly for your data (it uses the content column as the matching key) to avoid

Petar Georgiev tarafından
CW
free

Audit digital identities with Apify BreachHound and PDF.co

Quick overview This workflow starts from an n8n form submission, runs the BreachHound actor on Apify to discover where an email address is registered, then summarizes the results into an HTML audit report and converts it to a downloadable PDF using PDF.co. How it works Receives an email address (and options) when a user submits the n8n form. Sends the submitted inputs to the BreachHound actor on Apify to check the email across online services. Loads the actor’s results from the Apify dataset. Aggregates the dataset into audit statistics and a list of platforms where the email is found. Generates an HTML report containing the totals and a table of found accounts. Converts the HTML report to a PDF using the PDF.co Convert from HTML API and fetches the generated file via HTTP. Setup Connect an Apify API credential and select/configure the BreachHound actor in the Apify “Run an Actor” step. Create a PDF.co account, replace YOUR_API_KEY_HERE with your PDF.co API key, and keep the HTML-to-PDF endpoint settings as needed. Review the form fields and the default options (for example, the “onlyUsed” and “useResidentialProxy” values) to match the audit behavior you want before activating the

Blukaze Automations tarafından
Bgoogledocssheetsopenaichatmodel
free

Validate startup ideas and generate business plans from Telegram with Perplexity and GPT-4o

Quick overview This workflow receives startup ideas via a Telegram bot, uses OpenAI (GPT-4o and GPT-4o mini) plus Perplexity to score, research, and validate them, then generates a full business plan in Google Docs, logs key results to Google Sheets, and returns the plan link in Telegram. How it works Receives a Telegram message containing a raw startup idea. Uses OpenAI (GPT-4o mini) to structure the idea, detect its language, and assign an initial 1–10 idea score with improvement feedback. If the idea score is below the configured threshold, sends the score reasoning back to Telegram and stops. If the score meets the threshold, asks in Telegram for approval to run full research and plan generation. After approval, uses Perplexity to research the target market and competitors and then uses OpenAI (GPT-4o) to structure the findings, score market and competition, and generate differentiation and moat notes. Uses OpenAI (GPT-4o mini) to validate demand, risks, and go-to-market approach, then computes a composite score and recommendation. Uses OpenAI (GPT-4o) to write a full business plan, saves it to a Google Doc, appends a summary row to Google Sheets, and sends the Google Doc link

Dr. Firas tarafından
ACWopenaichatmodel
free

Translate YouTube video metadata into multiple languages with OpenAI

Quick overview This workflow fetches a YouTube video’s title and description, uses OpenAI to translate them into multiple target languages, and updates the video’s YouTube localizations via the YouTube Data API, returning a YouTube Studio link to review the translations. How it works Runs manually when you execute the workflow. Reads the configured YouTube video ID, default language, target languages, and OpenAI model. Fetches the video’s current metadata (including existing localizations) from YouTube. Removes the default language from the target language list and prepares the language-code keys required for the translation output. Sends the title and description to OpenAI and parses the response as structured JSON with a translated title and description per language code. Updates the video on YouTube by writing the translated metadata into the video’s localizations via a single YouTube API request. Outputs a YouTube Studio translations URL so you can review the updated localizations. Setup Add YouTube OAuth2 credentials with permission to edit videos on the target channel. Add an OpenAI API key credential and choose a model name in the configuration. Set the video_id, default_lan

Dr. Firas tarafından
Cgmailsheets
free

Send scheduled quote follow-up emails with Gmail and Google Sheets

Quick Overview This workflow runs daily to read open quotes from Google Sheets, calculates how many days have passed since each quote was sent, and sends the appropriate 3-, 7-, or 14-day follow-up email via Gmail, then writes a sent date back to the sheet to prevent duplicates. How it works Runs every day at 9am on a schedule trigger. Loads your business details, follow-up day offsets, and email subject/body templates from a preset configuration. Reads all quote rows from a Google Sheets spreadsheet. Keeps only quotes with status set to open, calculates days since sent_date, and selects the next due follow-up (day 3, 7, or 14) that has not been sent yet. Sends a plain-text follow-up email through Gmail to each due quote’s customer using the filled template. Updates the matching Google Sheets row (by quote_id) to stamp the corresponding followup_1, followup_2, or followup_3 column with today’s date. Setup Add Google Sheets credentials, select the target spreadsheet and sheet in both Google Sheets steps (read and update). Add Gmail credentials for the mailbox you want to send follow-ups from. Create a quotes sheet with headers quote_id, customer_name, customer_email, quote_amount, s

43 Sunsets tarafından
ACDembeddingsgooglegemini
free

Answer support FAQs with Google Gemini, Supabase, Google Sheets and WhatsApp

Quick overview This workflow ingests FAQs from Google Sheets into a Supabase vector table using Google Gemini embeddings, then serves a webhook-based support chatbot that answers only from that FAQ knowledge base and escalates unanswered questions to a human via UltraMsg WhatsApp. How it works Runs manually to pull FAQ rows (Question/Answer) from a Google Sheets spreadsheet. Formats each row into a single text document (for example, Q: … A: …), generates embeddings with Google Gemini, and inserts the documents into a Supabase vector store table. Receives incoming chat messages via a POST webhook that includes message and sessionId. Uses a Google Gemini chat model with session-based memory to query the Supabase vector store for the most relevant FAQ matches and generates a reply strictly from the retrieved content. If the agent output indicates escalation to a human, sends the full message content to UltraMsg via an HTTP request to alert a WhatsApp number. Returns a JSON response to the webhook caller with either the FAQ-based answer or a confirmation that a human agent has been notified. Setup Add credentials for Google Gemini (PaLM) API, Supabase, and Google Sheets OAuth2. In Supa

Ayaan Sheikh tarafından
CW
free

Search and preview GIFs with forms and GIPHY

Quick overview This workflow publishes an n8n Form where users enter a search term, queries the GIPHY Search API for the top 9 G-rated GIFs, and renders the results as a clickable HTML gallery on the form completion page with copy-to-clipboard links. How it works Receives a submission from an n8n Form at the gif-finder path with a required query field. Calls the GIPHY Search API with the submitted query, limiting results to 9 GIFs and filtering to G-rated content. Transforms the GIPHY response into responsive HTML that shows a grid of GIF thumbnails and a fallback message when no results are returned. Displays the generated HTML on the form completion page so users can click any GIF to copy its direct URL to the clipboard. Setup Create a GIPHY developer app and generate an API key. Add an HTTP Query Auth credential and set the api_key value to your GIPHY API key, then select it in the HTTP Request that calls GIPHY. Activate the workflow and share the n8n Form URL for the gif-finder form with your users.

Roshan Ramani tarafından