Quick Overview This workflow manually runs to read a list of webpage URLs from Google Sheets, scrape each page with ScrapingBee, and use Google Gemini to extract structured product data from screenshots with an HTML fallback, then append the results back into a Google Sheets sheet. How it works Runs when you manually trigger the workflow. Reads the list of URLs to scrape from a Google Sheets spreadsheet. Fetches a full-page screenshot for each URL using the ScrapingBee API. Sends the screenshot (and the URL for context) to a Google Gemini model to extract product details into a structured JSON format, calling a ScrapingBee HTML fetch tool when screenshot extraction is incomplete. Converts any fetched HTML to Markdown and returns it to the Gemini agent to complete the extraction. Splits the extracted product array into individual items and appends them as new rows in the Google Sheets “Results” sheet. Setup Create a Google Sheets service account connection in n8n and set the target spreadsheet and the “List of URLs” and “Results” sheet selections. Add a Google Gemini (PaLM) API credential in n8n and ensure the selected model (gemini-1.5-pro-latest) is available for your account.
Tags
Call n8n Workflow ToolGoogle Gemini Chat Model
Google SheetsWHTTP Request
Structured Output ParserRelated workflows
See all AI Automation→
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
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