Workflow Templates

Quick overview This workflow runs on a schedule, polls a JSON API endpoint, derives and stores a snapshot of the response schema in an n8n Data Table, and posts a Slack alert only when the response structure or field types change. How it works Runs every 6 hours on a schedule. Loads the configured API endpoint URL, an endpoint key used for snapshotting, and the target Slack channel. Fetches the endpoint with retries and skips the run if the response is not a valid JSON object or array. Derives a normalized schema (field paths, types, required/optional, and nullability) and compares it to the previous schema stored in an n8n Data Table. Upserts the latest schema snapshot back into the n8n Data Table under the same endpoint key. Posts a formatted drift report to Slack only when a high- or medium-severity contract change is detected. Setup Create an n8n Data Table (for example, “API Contract Snapshots”) with text columns named endpointKey and schema_object, and select its ID in both the read and upsert steps. Add a Slack API credential in n8n. Update the Settings values for endpointUrl, endpointKey, and slackChannel (Slack channel ID) to match your API and destination channel. Run the workflow once to seed the initial schema snapshot, then activate it to start monitoring. Requirements n8n version recent enough to include Data Tables (built in, no community node) A Slack credential (OAuth2, or a bot token with chat:write) An HTTP or JSON endpoint to watch (ships pointed at a free no-key public endpoint, so it runs as-is) Customization Change the polling interval in the Schedule Trigger (every 6 hours by default) Watch several endpoints by giving each its own endpointKey and sharing one Data Table Lower the alert gate to also surface low-severity changes (a new optional field) Point it at an OpenAPI JSON document instead of a data endpoint to track the spec's structure Watch a private API by switching the HTTP Request authentication and adding a token credential Add a small LLM step to turn the change list into a plain-English impact note Send the alert to an on-call tool such as PagerDuty, Opsgenie, or Twilio SMS alongside Slack Additional info The workflow ships pointed at a free no-key public endpoint (jsonplaceholder), so a reviewer can run it end to end on import with only a Slack credential and no API key. Three design choices keep it quiet and safe: value-churn suppression (only structural and type changes alert, never changed values or list length), idempotency (each drift is reported once, then the snapshot refreshes), and a safe skip on a failed or non-JSON fetch so a bad response never overwrites the saved shape or raises a false alarm. All sample data is fictional and no real credentials, IDs, or endpoints are included.

🤹🤖 This workflow (AI Document Generator with Anthropic Agent Skills and Uploading to Google Drive) automates the process of generating, downloading, and storing professionally formatted files (PDF, DOCX, PPTX, XLSX) using the Anthropic Claude API and Google Drive. This workflow connects user prompts with the Anthropic API to generate professional documents in multiple formats, automatically retrieves and uploads them to Google Drive — providing a complete AI-powered document automation system. Key Advantages ✅ Full Automation** From user input to file delivery, the entire pipeline — creation, extraction, download, and upload — runs without manual intervention. ✅ Multi-Format Support** Handles four major business document types: PPTX (Presentations) PDF (Reports) DOCX (Documents) XLSX (Spreadsheets) ✅ Professional Output** Each format includes tailored Claude system prompts with detailed formatting and design principles: Layout structure Typography Visual hierarchy Consistency and readability This ensures that every file produced follows professional standards. ✅ Easy Customization** You can modify the prompt templates or add new Skills using the “Get All Skills” node. The form and switch logic make it simple to extend with additional file types or workflows. ✅ Seamless Cloud Integration** Generated files are automatically uploaded to a Google Drive folder, enabling: Centralized storage Easy sharing and access Automatic organization ✅ Reusable and Scalable** This workflow can be used as a foundation for: Automated report generation Client deliverables Internal documentation systems AI-driven content creation pipelines How it Works This n8n workflow enables users to create professional documents using Anthropic's Claude AI and automatically save them to Google Drive. The process works as follows: Form Trigger: The workflow starts with a web form where users submit a prompt and select their desired file type (PPTX, PDF, DOCX, or XLSX). Document Type Routing: A switch node routes the request based on the selected file type to the appropriate document creation node. AI Document Generation: Each document type has a dedicated HTTP Request node that calls Anthropic's Messages API with: Specific system prompts tailored for each document type (PowerPoint, PDF, Word, or Excel) The user's input prompt Appropriate Anthropic skills (pptx, pdf, docx, xlsx) for specialized document creation Code execution capabilities for complex formatting File ID Extraction: Custom JavaScript code nodes extract the generated file ID from Anthropic's response using recursive search algorithms to handle nested response structures. File Download: HTTP Request nodes download the actual file content from Anthropic's Files API using the extracted file ID. Cloud Storage: Finally, the downloaded files are automatically uploaded to a specified Google Drive folder, organized and ready for use. Set Up Steps API Configuration: Set up HTTP Header authentication with Anthropic API Add x-api-key header with your Anthropic API key Configure required headers: anthropic-version and anthropic-beta Google Drive Integration: Connect Google Drive OAuth2 credentials Specify the target folder ID where documents will be uploaded Ensure proper permissions for file upload operations Custom Skills (Optional): Use the "Get All Skills" node to retrieve available custom skills Update skill_id fields in JSON bodies if using custom Anthropic skills Modify the form dropdown to include custom skill options if needed Form Configuration: The form is pre-configured with prompt field and file type selection No additional setup required for basic functionality Execution: Activate the workflow Access the form trigger URL Submit prompts and select desired output formats Generated files will automatically appear in the specified Google Drive folder The workflow handles the entire process from AI-powered document creation to cloud storage, providing a seamless automated solution for professional document generation. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

What does this workflow do? This workflow exports the names of all Dialogflow intents from your agent, together with their priority levels, directly into a Google Sheets spreadsheet. It is triggered via Telegram and includes visual indicators (emojis) for priority levels. 📜 Overview 🔔 Activation**: Triggered when a validated user sends the keyword (e.g. "backup") via Telegram. 📥 Data Retrieval**: Fetches all intents of the specified Dialogflow agent using the Dialogflow API. ⚙️ Processing**: Transforms each intent into an n8n-compatible item. Extracts the displayName and priority of each intent. Assigns an emoji and descriptive label based on priority tier: 🔴 Highest, 🟠 High, 🔵 Normal, 🟢 Low, 🚫 Ignore. 📑 Storage**: Appends each intent (name, priority number, emoji, and description), along with current date and time, to a Google Sheets document. 📩 Notification**: Sends a single confirmation message to the Telegram user once insertion is complete (using Execute Once). 🛠️ How to install and configure Import the workflow: Upload the .json into your n8n instance. Connect Telegram: Add your Telegram bot credentials and configure the node Validación de usuario por ID with your Telegram ID. Configure Dialogflow: Authenticate using a Google Service Account API Credential. Then, in the Obtiene datos de los intents node, replace the example project ID (TU_PROJECT_ID) with your actual Dialogflow agent's project ID. Connect Google Sheets: Authorize Google Sheets via OAuth2 and select your destination document/sheet in the node Añadir fila en la hoja. Customize trigger keyword: Adjust the command text (default "backup") if needed. Activate workflow: Ensure the webhook is correctly set up in Telegram before enabling the workflow. 👥 Who is this for? 🤖 Bot administrators who need quick backups of Dialogflow intent names. 🌐 Teams managing multilingual or multi-intent agents wanting priority oversight. 💻 Development teams needing an automated way to audit or version intent configurations regularly. 💡 Use Cases ⚙️ Backup intents periodically to monitor changes over time. 📊 Visualize priority assignment in a spreadsheet for analysis or team discussion. 📖 Document conversational structure for onboarding or knowledge transfer.

Analyze Trustpilot & Sitejabber sentiment with Decodo + Gemini to Sheets Sign up for Decodo HERE for Discount This template scrapes public reviews from Trustpilot and Sitejabber with a Decodo tool, converts findings into a flat, spreadsheet-ready JSON, generates a concise sentiment summary with Gemini, and appends everything to Google Sheets. It’s ideal for reputation snapshots, competitive analysis, or lightweight BI pipelines that need structured data and a quick narrative. Who’s it for? Marketing teams, growth analysts, founders, and agencies who need repeatable review collection and sentiment summaries without writing custom scrapers or manual copy/paste. How it works A Form Trigger collects the Business Name or URL. Set (Config Variables) stores business_name, spreadsheet_id, and sheet_id. The Agent orchestrates the Decodo tool and enforces a strict JSON schema with at most 10 reviews per source. Gemini writes a succinct summary and recommendations, noting missing sources with: “There’s no data in this website.” A Merge node combines JSON fields with the narrative. Google Sheets appends a row. How to set up Add Google Sheets, Gemini, and Decodo credentials in Credential Manager. Replace (YOUR_SPREADSHEET_ID) and (YOUR_SHEET_ID) in Set: Config Variables. In Google Sheets, select Define below and map each column explicitly. Keep the parser and agent connections intact to guarantee flat JSON. Activate, open the form URL, submit a business, and verify the appended row.

Quick overview This workflow runs on a weekday schedule, scrapes WTI crude oil futures prices from Reliable Sources, extracts and formats key contract data with JavaScript, and sends a compact market snapshot to a Telegram chat. How it works Runs on a schedule at specified times on weekdays. Fetches the WTI futures webpage from Oilprice.com via an HTTP request. Parses the returned HTML to extract WTI (CL) contract symbols, contract months/years, prices, changes, and update times, then sorts and limits the list to the next 15 contracts. Aggregates the extracted contracts into a single dataset for reporting. Sends a formatted Telegram message that summarizes the market (all up/down/mixed), lists contracts with price and change, and includes range, average change, and a source link. Setup Add a Telegram Bot token (Telegram API credentials) and set the target chat ID in the Telegram message action. Review and adjust the schedule times and timezone as needed for your market hours. Confirm the Oilprice.com URL is reachable from your n8n instance and update the source URL if the data location or page structure changes.

Overview This n8n template automates a weekly Reddit industry digest without the Reddit API. It scrapes top posts from selected subreddits via ScrapeOps Proxy, enriches them with full post text, deduplicates against Google Sheets, and generates a weekly summary - optionally emailed to your inbox. Who is this for? Developers and product teams monitoring industry trends on Reddit Marketers and founders tracking niche community conversations Analysts building automated weekly briefings from Reddit What problem does it solve? Manually checking multiple subreddits weekly is time-consuming. This workflow runs automatically, scrapes top posts, removes duplicates, and delivers a clean weekly digest to Google Sheets and optionally your email. How it works A weekly schedule triggers the workflow automatically. ScrapeOps Proxy scrapes "Top of Week" from each subreddit on old.reddit.com. Post metadata is parsed from HTML: title, URL, score, comments, author, timestamps. Each post is fetched as JSON to extract the full selftext body. Data is merged, normalized, and deduplicated against existing Sheet rows. New posts are appended to the posts tab. A weekly digest is written to weekly_digest and optionally emailed. Set up steps (~10–15 minutes) Register for a free ScrapeOps API key: https://scrapeops.io/app/register/n8n Add ScrapeOps credentials in n8n. Docs: https://scrapeops.io/docs/n8n/overview/ Duplicate this sheet to copy Columns and Spreadsheet ID. Connect Google Sheets and set your Spreadsheet ID in the Read, Append, and Digest nodes. Update your subreddit list and week range in Configure Subreddits & Week Range. Optional: configure the Send Email node with sender and recipient credentials. Run once manually to confirm, then activate. Pre-conditions Active ScrapeOps account (free tier). ScrapeOps community node installed in n8n. Google Sheets credentials configured in n8n A Google Sheet with posts and weekly_digest tabs and correct column headers Optional: email credentials for the Send Email node Disclaimer This template uses ScrapeOps as a community node. You are responsible for complying with Reddit's Terms of Use, robots.txt directives, and applicable laws in your jurisdiction. Scraping targets may change at any time; adjust render, scroll, and wait settings and parsers as needed. Use responsibly and only for legitimate business purposes.

Quick overview This workflow pulls companies from Supabase, uses an OpenAI (GPT-4o) agent to crawl each company website and collect social media profile URLs via HTTP requests and HTML parsing, and then writes the enriched company record (name, website, and social links) back to Supabase. How it works Runs manually and loads all company records from a Supabase companies_input table. Keeps only each company’s name and website fields and sends the website to an OpenAI (GPT-4o) agent. The agent fetches page text (HTML converted to Markdown) and extracts links from pages (anchor hrefs), following additional URLs as needed to find social profiles. The agent returns a structured JSON object of social media platforms and their profile URLs. The workflow combines the extracted social links with the original company name and website. Inserts the enriched record into the Supabase companies_output table. Setup Add a Supabase credential and set the correct workspace/project so the workflow can read from companies_input and write to companies_output. Add an OpenAI API key in the OpenAI Chat Model node (configured for GPT-4o). Ensure your input table contains name and website fields (or update the field mapping to match your schema).

Overview This n8n template automates scraping Redfin property listings on a schedule. Using ScrapeOps Proxy API for reliable page fetching and the ScrapeOps Redfin Parser API for structured data extraction, it saves clean listing rows to Google Sheets and sends an optional Slack summary. Who is this for? Real estate investors monitoring listings in target markets Agents and brokers tracking new properties across cities or ZIP codes Analysts building property datasets without manual data entry Anyone who wants automated, scheduled Redfin data in a spreadsheet What problem does it solve? Manually checking Redfin for new listings is slow and inconsistent. This workflow runs on a schedule, scrapes your target search page, parses and filters valid listings, and keeps your Google Sheet updated automatically; no browser or manual copy-paste needed. How it works A schedule triggers the workflow every 6 hours. ScrapeOps Proxy fetches the Redfin search page with JS rendering and residential proxy support. ScrapeOps Parser API extracts clean structured JSON from the HTML. Search metadata (total listings, region, price range) is lifted and stored. The results array is split into one item per property. Property fields are normalized: address, price, beds, baths, sqft, status, and more. Invalid listings (missing address or price = 0) are filtered out. Valid listings are appended to Google Sheets. An optional Slack message posts a summary with listing count and sheet link. Set up steps (~10–15 minutes) Register for a free ScrapeOps API key: https://scrapeops.io/app/register/n8n Add ScrapeOps credentials to both ScrapeOps nodes. Docs: https://scrapeops.io/docs/n8n/overview/ Duplicate the Google Sheet template and paste your Sheet ID into Save Listings to Google Sheets. In Set Search Parameters, update redfin_url to your target city or ZIP search page. Optional: open Send Slack Summary, select your Slack credential, and set your channel. Run once manually to confirm results, then activate. Pre-conditions Active ScrapeOps account (free tier available): https://scrapeops.io/app/register/n8n ScrapeOps community node installed in n8n: https://scrapeops.io/docs/n8n/overview/ Google Sheets credentials configured in n8n A duplicated Google Sheet with correct column headers matching the formatter output Optional: Slack credentials for the summary notification node Disclaimer This template uses ScrapeOps as a community node. You are responsible for complying with Redfin's Terms of Use, robots.txt directives, and applicable laws in your jurisdiction. Scraping targets may change at any time; adjust render, scroll, and wait settings and parsers as needed. Use responsibly and only for legitimate business purposes.

Gold vs Equity Performance Comparison Tracker with Visual Insights This automated n8n workflow evaluates the historical performance of gold against equity markets. It extracts daily price data from Google Sheets, calculates comparative returns and uses an AI agent to generate actionable investment insights. Finally, it creates a visual performance chart and emails a smartly formatted HTML report—triggering a high-priority alert if the performance gap exceeds a defined threshold. Quick Implementation Steps Import the Workflow: Upload the downloaded JSON file into your n8n workspace. Connect Credentials: Authenticate your Google Sheets, Gmail and Groq API accounts in their respective nodes. Map Your Data: Select your specific Google Sheet documents for both the Gold and Equity data fetching nodes. Set Your Parameters: Open the Set Analysis Parameters node to define your target date range and performance gap threshold. Execute: Click "Test Workflow" to generate and receive your first automated financial comparison report. What It Does This workflow acts as an automated financial analyst. It begins by pulling day-by-day pricing for two distinct assets—Gold and Equity—from standard Google Sheets. A custom script then merges this data, ensuring dates match up perfectly while filtering out any information outside of your target date window. Once the data is aligned, the workflow calculates the percentage returns for both assets and determines the exact performance difference. Instead of just presenting raw numbers, the workflow passes these calculated metrics to an advanced AI Agent powered by Llama-3. The AI is prompted to step into the role of an investment advisor, evaluating the numbers to declare a "winner," providing realistic market context and suggesting a strategic portfolio allocation (e.g., 60% Equity / 40% Gold) based strictly on the provided data. To wrap it all up, the system generates a dynamic line chart URL using QuickChart.io. It packages the chart, the raw numbers and the AI's written insights into a clean HTML email. If one asset drastically outperforms the other (based on a threshold you set), the system routes the email as a special "ALERT". Finally, it logs a summary of the report back into a fresh Google Sheet for long-term record keeping. Who’s It For This workflow is perfect for financial analysts, portfolio managers, wealth advisors, and self-directed investors who want to automate their market tracking. It is highly beneficial for teams that need consistent, data-backed comparative reporting without the manual labor of crunching spreadsheet numbers and drafting summaries every week. Requirements to Use This Workflow An active n8n instance (compatible with self-hosted version 2.1.5 or newer). A Google Workspace account to authenticate both Google Sheets and Gmail nodes. A Groq API account to power the Llama-3 language model for AI insights. A Google Sheet populated with daily historical prices for Gold and Equity. How It Works & Set Up 1. Define Your Analysis Scope Start at the Set Analysis Parameters node. Here, you will define the startDate, endDate and the threshold percentage. This threshold is the performance gap required to trigger an urgent alert rather than a standard report. 2. Ingest the Market Data The workflow branches into two Google Sheets nodes (Fetch Gold Prices and Fetch Equity Prices). You will need to select your Google account credentials and point these nodes to the specific worksheets containing your date and price columns. 3. Merge and Calculate The Merge Market Data node uses JavaScript to combine both data streams into a single timeline. The subsequent Calculate Performance Metrics node does the math, calculating the total percentage return for both assets over your chosen timeframe. 4. Generate AI Insights The Generate AI Investment Insights Langchain agent takes the calculated returns and sends them to the Groq language model. Make sure your Groq credentials are active in the attached Insights model node. The AI outputs a structured JSON response containing the market summary and allocation advice. 5. Charting and Delivery While the AI processes text, the Generate Chart node transforms the price arrays into a QuickChart visual. Everything is combined in the Generate Final Report node, which builds the HTML structure. Finally, the Check Performance Gap node decides whether to trigger the Send Report Email or the Send Alert Email. How To Customize Nodes Set Analysis Parameters:** Update this node before every manual run to target different weeks, months or quarters. Generate AI Investment Insights:** Open the system prompt options in this node to change the AI's "personality." You can ask it to be more conservative, aggressive or to focus strictly on macroeconomic trends. Generate Chart:** Open the JavaScript code in this node to customize the aesthetics. You can change line colors, adjust the line tension or switch the chart type from "line" to "bar". Email Nodes:** Customize the HTML body or change the target email addresses. You can add CCs or BCCs for broader team distribution. Add‑ons Slack / Discord Integration:** Swap the Gmail nodes for messaging app nodes to drop these reports directly into a company finance channel. Live Data APIs:** Replace the Google Sheets fetch nodes with direct HTTP requests to Yahoo Finance or Alpha Vantage to pull real-time market data on the fly. PDF Generation:** Add a tool to convert the generated HTML payload into a polished PDF document, making it easier to attach to client emails. Use Case Examples Weekly Wealth Management Reporting: Automatically send weekly asset comparison summaries to high-net-worth clients to keep them informed on their portfolio balances. Automated Wealth Plan Generator: Feed the AI's allocation advice from this workflow directly into a broader wealth-planning system to calculate user eligibility and adjust debt-to-equity ratios. Market Volatility Alerts: Run this workflow daily on a schedule. If safe-haven assets (Gold) suddenly spike in comparison to risk assets (Equity), your team receives an immediate warning to adjust trading strategies. Crypto vs. Traditional Markets: Repurpose the workflow by simply changing the input sheets to compare Bitcoin performance against traditional S&P 500 index funds. Real Estate vs. Stocks: Adjust the data sources to compare local housing market indices against stock market growth over a multi-year period. Troubleshooting Guide | Issue | Possible Cause | Solution | | :--- | :--- | :--- | | Workflow fails at "Fetch Prices" nodes | Google Sheets credentials expired or Sheet ID is incorrect. | Re-authenticate your Google OAuth2 credentials and ensure you have selected the correct document and sheet tab from the node dropdowns. | | "Invalid JSON from AI" error | The Groq LLM returned conversational text (like "Here is your data:") instead of raw JSON. | Open the Generate AI Investment Insights node and ensure the system prompt strictly demands "Output ONLY valid JSON." You may also need to adjust the temperature setting on the Llama model. | | Chart image is broken in email | The data arrays are empty or the QuickChart URL exceeded character limits. | Verify that the Merge Market Data node successfully matched dates for both assets. If comparing years of data, consider calculating weekly averages instead of daily to shorten the URL string. | | No emails are being received | Gmail node misconfigured or blocked by Google security. | Check the Gmail credential connection. Ensure the recipient email address is valid and check your spam folder. | | Google Sheets history not updating | The Store Report History node is mapping to the wrong column headers. | Ensure your destination Google Sheet has exact column headers for "Date", "Winner", "Summary" and "Report" as defined in the node's schema. | Need Help? Running into hurdles getting this workflow perfectly tuned for your specific financial datasets? Whether you need help configuring the Groq AI prompts, adjusting the custom JavaScript parsing logic or building out more advanced add-ons like dynamic API integrations, our n8n automation team at WeblineIndia is here to assist. Feel free to reach out and contact WeblineIndia for expert n8n consultation. We can help you troubleshoot, customize and build the perfect automation architecture tailored to your exact business needs.

This workflow turns a Google Sheet into an automated certificate-issuing pipeline. The moment a new completion row is added — whether by your training team, a Zap, or a quiz platform — a branded PDF/A-2b (archival-grade) certificate is rendered by TemplateFox, archived in Google Drive, emailed to the participant with a permanent link, and the original sheet row is updated with the Drive URL and issue timestamp. You get a complete audit trail without writing a single line of code. Problem Solved Issuing certificates manually means: Copy-pasting names and dates into a Word or Canva file Exporting to PDF, attaching to an email, and sending it one by one Saving a copy somewhere your team can find later Maintaining a separate tracker of who got their certificate Inconsistent branding and typos that erode the document's authority This workflow eliminates all of that. Drop a row in your sheet, get an archival-quality certificate delivered, archived, and tracked — every time, with the same branding. Who Can Benefit Online course creators** issuing course-completion certificates at scale Corporate training and L&D teams** documenting compliance, onboarding, or upskilling Coaching and mentorship programs** rewarding milestones with a tangible deliverable Conference and event organisers** issuing attendance and CPD/CEU certificates Bootcamps and academies** delivering official credentials to graduates Nonprofits and associations** awarding volunteer or membership recognition Prerequisites TemplateFox account with an API key (free tier available) Google account with Sheets, Gmail, and Drive enabled Install the TemplateFox community node from Settings → Community Nodes Setting Up Your Template You need a TemplateFox certificate template for this workflow. You can: Start from an example — Browse certificate templates, pick one you like, and customize it in the visual editor with your colours, logo, and signatures Create from scratch — Design your own certificate in the TemplateFox editor Once your template is ready, select it from the dropdown in the TemplateFox node — your fields load automatically. Drag each field directly from the Google Sheets trigger output panel onto the matching template field. No code needed. The workflow renders the certificate as PDF/A-2b, a modern archival standard that guarantees the file looks identical decades from now — perfect for official credentials. You can switch to PDF/A-3b in the TemplateFox node options if your training body requires it. Workflow Details Step 1: Google Sheets Trigger — New Completion Row Watches a Google Sheet for new rows. Expected columns: Participant Name, Email, Course, Completion Date, Instructor. The trigger polls every minute by default. Step 2: TemplateFox — Generate Certificate (PDF/A-2b) Maps the row data directly to your certificate template fields and renders an archival-grade PDF. Static fields like your logo, signatures, and organisation name should be set inside the template editor itself — no need to pass them through n8n. Step 3: Download PDF An HTTP Request node downloads the rendered PDF as a binary file, ready to be uploaded to Drive. Step 4: Archive to Google Drive Uploads the PDF to your chosen Google Drive folder, named certificate-<email>.pdf for easy auditing. The node returns a permanent webViewLink that's used downstream. Step 5: Email Certificate A Gmail node sends a styled HTML email to the participant with a "Download your certificate" button pointing to the permanent Drive URL. Course name and completion date are included from the trigger row. Step 6: Update Sheet Row The original row in your Google Sheet is updated with two new values: Certificate URL (the permanent Drive webViewLink) and Issued At. Matching is done by Email, so even if rows are reordered the right one is updated. The whole pipeline runs in a single horizontal chain — clean to read, easy to debug. Customization Guidance Static template content:** Set your organisation's logo, signatures, and any constant fields directly in the TemplateFox template editor — they never change between certificates. PDF/A variant:** Switch to pdf/a-3b in the TemplateFox node options if you need PDF/A-3 (archival + attachments). Pass/fail gate:** Add an IF node after the trigger to skip rows where Score is below your passing threshold. Batch issuing:* Replace the Sheets trigger with a *Schedule Trigger** + a Get Many Rows step to issue certificates nightly instead of one-by-one. Drive organisation:** Use a sub-folder per course by templating the file name with {{ $('New Completion Row').first().json.Course }}/.... Slack alert:** Add a Slack node after the Drive step to notify your training team in #training-ops. Note: This template uses the TemplateFox community node. Install it from Settings → Community Nodes. Full tutorial: templatefox.com/n8n/automate-certificates

Overview Turn documents into an AI-powered knowledge base. Upload PDF, CSV, or JSON files and ask natural-language questions about their content using a Retrieval-Augmented Generation (RAG) workflow powered by Google Gemini. The workflow extracts, embeds, and semantically searches document data to generate accurate, source-grounded answers. Designed as a simple and extensible starting point for building AI document assistants. Key Features Upload and analyze PDF, CSV, and JSON AI chatbot with semantic document search Retrieval-Augmented Generation (RAG) architecture Answers grounded in uploaded documents Beginner-friendly workflow with clear documentation Easy to extend for production use How It Works Upload a document via form trigger Content is split into searchable chunks Gemini generates embeddings Data is stored in a vector store The chatbot retrieves context and answers questions Requirements Google Gemini API credentials Notes Uses an in-memory vector store (data resets on restart) Can be replaced with Pinecone, Supabase, Weaviate, or other persistent databases Gemini API usage may incur costs depending on document size and query volume

Who’s it for This template is ideal for recruiters, founders, sales teams, and lead-generation specialists who want to quickly collect LinkedIn profiles based on role, industry, and region. It is perfect for users who want profile lists for outreach, research, hiring, or market analysis without manually searching LinkedIn. What it does / How it works This workflow begins with a web form where you enter three inputs: position, industry, and region. Once the form is submitted, the workflow performs a Google Custom Search query restricted to LinkedIn profile URLs. The results are processed to extract structured profile information such as: Name Job title (cleaned using custom logic) LinkedIn profile link Description / bio snippet Profile image URL The workflow automatically handles pagination by detecting whether more results are available and continues fetching until the limit is reached. All extracted profiles are appended or updated in a Google Sheet so you always maintain an organized and deduplicated list. Requirements Google Sheets OAuth2 credentials Google Custom Search API key Google CSE (Custom Search Engine) ID A Google Sheet with the required columns (name, title, profile link, description, image link, searched position, searched industry, searched region) How to set up Connect your Google Sheets credentials. Add your Custom Search API key and CSE ID inside the HTTP Request node. Select your target Google Sheet in the “Append or update row in sheet” node. Open the form URL and submit your position, industry, and region. Run the workflow to begin scraping profiles. How to customize the workflow Modify search query structure for niche industries Add enrichment tools (Hunter.io, Clearbit, People Data) Expand pagination limit beyond the default Add filters to remove non-relevant results Output data to CRM tools like HubSpot, Notion, Airtable, or Sheets