Watch web pages for plain-language conditions with Gemini, Sheets and Gmail

by ayumi ✓ · 1 views · created 2026-09-05 · Market Research, AI Summarization

What this workflow does

This AI workflow has 25 nodes and runs on a schedule (every hour). Along the way it connects Google Sheets, Airtop, Google Gemini Chat Model and Gmail.

How it runs

Trigger: On a schedule (every hour).

1. Config (Edit Fields (Set)): sets 7 fields: googleSheetsId, notifyEmail, maxItemsPerRun…
2. Read watchlist (Google Sheets): uses Google Sheets
3. Pick rows that are due (Code): runs custom JavaScript code
4. Fetch with (Switch): routes items into 1 branches
5. Airtop: uses Airtop
6. Fetch page (HTTP) (HTTP Request): calls an HTTP API
7. Airtop: work with window
8. Extract text (HTTP) (Code): runs custom JavaScript code
9. Has open step? (If): checks a condition and branches into true / false
10. HTTP result (Switch): routes items into 2 branches

…plus 11 more steps. See the full node list below.

Services it uses

Google SheetsAirtopGoogle Gemini Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (14)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Switchn8n-nodes-base.switch
• HTTP Requestn8n-nodes-base.httpRequest
• Airtopn8n-nodes-base.airtop
• Ifn8n-nodes-base.if
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Gmailn8n-nodes-base.gmail
• No Operation, do nothingn8n-nodes-base.noOp
• Waitn8n-nodes-base.wait

From the author

Quick overview You know the page and you know what you are waiting for: a room, a campsite, an admissions notice. Write the URL and the condition in one sheet row. Gemini reads the page on your schedule and emails you once, the moment the condition becomes…

View the original on n8n.io → Check your own copy