GeminiCreativeWritingAI score · PendingAI-assisted edit · no obvious prompt-injection riskn8n.io

Auto-Monitor School Admission Updates with n8n: Web Scraping + Gemini AI + Email Alerts

Input: list of school websites; Process: daily scrape, Gemini checks for admission openings; Output: email notification

Some experienceStepsWorkflowPrompt
Who
Parents tracking admission updates across multiple schools
You get
Daily automated check of school websites; email alert when admissions open
You need
n8n · google-gemini · email · http-request

Constraints

Prerequisites: n8n instance (self-hosted or cloud); Google Gemini API key; SMTP email account. Import the template, fill credentials and school list into designated nodes, then activate. Triggered daily at UTC 00:00.

What they did

Author aimasterishita published an n8n workflow template to help parents automatically monitor admission pages across multiple schools. The workflow triggers daily, iterates through a preset school list, fetches web pages via HTTP Request, cleans HTML via a Code node, then uses Gemini 2.5 Flash to judge whether admissions are open. If the judgment is 'yes', it sends an email alert.

How it went

Published as a public template on n8n.io (author_report). The template description states it uses 'all free tier tools', but no specific success rate, false-positive rate, or execution logs are provided.

Worth knowing

1) The source prompt's JSON example contains a syntax error: the line "school:: {{ $json.school }}" is missing a closing quote; manual correction is needed or Gemini may return unparsable output. 2) The 'Parse LLM response' node includes fallback handling: if JSON parsing fails, it defaults to admissions_open: "no". 3) The template defaults to monitoring Pre-nursery for 2026-2027; changing year/grade requires manual prompt editing. 4) The HTTP Request node sets no headers or anti-bot measures; some sites may return 403 or require additional handling. 5) This site has not tested the template; reproduction=not_tested.

n8n workflow template

Structure checked · Not run-tested

Use “Import from File” in n8n, or copy the JSON and paste it into the editor. Connect your own accounts, then try test data. The template is inactive by default.

Download JSONOriginal template

Setup and test checklist

Credentials to connect

  • Send email node: connect smtp credentials.
  • Are admissions Open node: connect Google Gemini/PaLM API credentials.

Configuration to replace

  • Source template is n8n public workflow #11691 (~14 nodes). Keep inactive after import; verify triggers, expressions and external API endpoints.
  • Sticky-note guidance is informational; replace placeholders with your own accounts, sheet schemas or channel IDs.

Test input and expected output

  • Manually run the main path once in a test workspace and confirm credentialed nodes authenticate without errors.
  • Drive one synthetic/redacted sample through and check output fields and downstream writes before enabling in production.

Template changes

  • Author credential bindings, webhookId and execution data are removed; the workflow is inactive. Nodes, connections and original prompts are preserved. Not run-tested in n8n.
  • No business-logic edits; verify keys, quotas and privacy compliance before use.

Template retrieved: 2026-10-24

Steps

  1. Import template and configure trigger + school list

    Import this template into n8n. Open the 'Daily Trigger' node and verify the Cron expression is 0 0 * * * (daily at UTC midnight). Open the 'Shortlisted Schools' node and replace the example schools with your target school names and admission page URLs.

  2. Configure Gemini node prompt and credentials

    Open the 'Are admissions Open' node. Select or create a googlePalmApi credential and enter your Gemini API key. The node includes a built-in prompt that instructs Gemini to detect admission openings from webpage text. Modify the year and class description in the prompt if you need to track a different grade or year.

    Execution prompt · Source text。The 'Are admissions Open' node's messages / content field

    You are an AI that detects school admission openings for year 2026-2027 for Pre-nursery with age criteria as 3 year+ as on Mar, 2026(optional). Analyze the following cleaned webpage text and return ONLY this JSON:
{
  "admissions_open": "yes/no",
  "school:: {{ $json.school }}
  "reason": "",
  "classes": ""
}
Page content:
{{ $json["cleaned_text"] }}

  3. Configure SMTP email node

    Open the 'Send email' node. Select or create an smtp credential. Fill in the From-Email and To-Email. The subject and body use template variables and will auto-populate with the school name and Gemini's reasoning.

  4. Run and customize

    Save and activate the workflow. Run manually for a first test. To customize: modify the prompt in 'Are admissions Open' for other grades (e.g., Bal-vatika, 1st, etc.). Any school with extractable website content via HTTP Request can be tracked.

Prompt you can copy

Setup guidance · Editorial suggestion。Setup starter: confirm inputs and permissions before importing the template

This block is the prompt. Ads are never placed here.

You are setting up an n8n workflow to auto-monitor school admission pages. Confirm you have: 1) a list of school names and admission URLs; 2) a Google Gemini API key; 3) SMTP sender/recipient emails and credentials. If any are missing, pause and obtain them before proceeding.

Prepare your school list, Gemini key, and SMTP credentials, then fill them into the corresponding nodes step by step.

Source

Monitor school admission updates with web scraping, Gemini AI & email alerts · aimasterishita · n8n.io · 2025-12-11

Comments & feedback

Tried this method? Share results, problems or improvements. Comments appear after moderation. Please avoid sensitive information.

Loading…

    Related