This workflow allows you to ask questions about the data in a Google Sheet over a chat interface. It uses n8n's built-in chat, but could be modified to work with Slack, Teams, WhatsApp, etc. Behind the scenes, the workflow uses GPT4, so you'll need to have an OpenAI API key that supports it. How it works The workflow uses an AI agent with custom tools that call a sub-workflow. That sub-workflow reads the Google Sheet and returns information from it. Because models have a context window (and therefore a maximum number of characters they can accept), we can't pass the whole Google Sheet to GPT - at least not for big sheets. So we provide three ways of querying less data, that can be used in combination to answer questions. Those three functions are: List all the columns in the sheet Get all values of a single column Get all values of a single row Note that to use this template, you need to be on n8n version 1.19.4 or later.
Tags
Call n8n Workflow ToolCCode
Google Sheets
OpenAI Chat ModelRelated workflows
See all AI Automation→C
Summarize Zoom meetings and create follow-ups with OpenAI, ClickUp, and Outlook
Quick overview This workflow pulls the transcript and participant list from a recent Zoom meeting, uses OpenAI to generate formal meeting minutes, emails the summary via SMTP, and runs an AI agent that creates ClickUp tasks and (when details exist) schedules a follow-up meeting in Microsoft Outlook Calendar. How it works Starts when you manually run the workflow. Fetches your scheduled Zoom meetings and keeps only those that started within the last 24 hours. Requests the meeting recording files from Zoom, stops with an error if no transcript is available, then extracts the transcript download URL. Downloads the Zoom transcript file, extracts its text, and reformats it into clean, readable dialogue. Pulls the Zoom meeting participant list (including emails) and sends the transcript and participants to OpenAI to generate structured meeting minutes. Formats the minutes into an HTML email and sends the summary via SMTP to a participant email address. Uses an OpenAI-powered agent to extract action items and follow-up details from the same transcript, then creates tasks in ClickUp and creates a follow-up event in Microsoft Outlook Calendar when scheduling information is present. Setup Ad
CAnswer WooCommerce order and DHL tracking questions with GPT-4 chat
Quick overview This workflow serves a demo web page with an n8n chat widget and runs an OpenAI-powered support agent that looks up WooCommerce orders and DHL tracking details by calling the same workflow as a tool. How it works Serves a demo HTML page via a webhook that embeds the n8n Chat widget configured to start a chat session. Triggers a new conversation when the chat widget connects and provides a customer email (mocked in this template) as session metadata. Uses an OpenAI (GPT-4) chat model with short-term memory to answer order-related questions and decide when to fetch live order data. Calls the same workflow as a tool with the customer email (and optional comma-separated order IDs) to retrieve matching WooCommerce orders. Looks up the WooCommerce customer by email, fetches their orders, and extracts shipment tracking metadata from each order. For orders with DHL tracking numbers, queries the DHL API for current shipment status, then merges tracking results back into the order data. Returns a JSON response containing the customer’s orders and any available DHL tracking details to the agent for use in the chat reply. Setup Add a WooCommerce API credential and update the sto
Enrich company records with social media links using GPT-4o and Supabase
Quick overview This workflow is manually triggered to pull company names and websites from Supabase, crawl each site with an OpenAI-powered agent to extract social media profile URLs, and write the enriched results to a separate Supabase table. How it works Runs when you manually execute the workflow. Reads all rows from the Supabase companies_input table and keeps the name and website fields for processing. Uses an OpenAI (GPT-4o) agent to crawl the company website, following discovered links and extracting social media profile URLs. Forces the agent output into a structured JSON schema and maps the extracted links into a social_media array. Merges the original company name and website with the extracted social media data. Inserts the enriched record into the Supabase companies_output table. Setup Add a Supabase credential and set the correct project details for both reading from companies_input and writing to companies_output. Add an OpenAI API credential for the GPT-4o chat model used by the crawling agent. Ensure your input table has name and website fields or update the field selection and mapping to match your schema. Confirm the output table accepts the mapped fields (for ex