n8n workflow templates

Four ready-to-import workflows for jobs people usually babysit by hand. Each one calls a hosted scraper over plain HTTP — no community nodes, works on n8n Cloud and self-hosted. In n8n: Workflow → Import from URL, paste the link, connect two credentials, run.

1 · Weekly App Store + Google Play review digest → Gmail

Every Monday: both stores' new reviews for your app, one email — counts, average rating per store, and the negative reviews that need a reply, quoted with author and version.

https://inmanjeffrey89-cell.github.io/data-tools/workflows/t1-app-review-digest.json
Runs on App Store Reviews Scraper ($0.0002/review) + Google Play Reviews Scraper ($0.0001/review). A typical 200+200 week ≈ $0.06; quiet weeks cost $0. Hard $1 cap per run baked in.

2 · Whole YouTube channel → transcripts in Google Sheets

Paste a channel URL, get one row per video — title, URL, language, word count, full transcript. The back catalog becomes a knowledge base you can search, embed, or feed to AI.

https://inmanjeffrey89-cell.github.io/data-tools/workflows/t2-channel-transcripts-sheets.json
Runs on YouTube Channel Transcript Scraper ($0.002/transcript — a 25-video channel ≈ $0.05; videos without captions are never charged).

3 · Keyword ideas from Google / YouTube / Amazon / Bing autocomplete → Google Sheets

Seed keywords in, hundreds of real typed-by-humans phrases out, one row per idea — ready for clustering, briefs, or Ads planning.

https://inmanjeffrey89-cell.github.io/data-tools/workflows/t3-keyword-research-sheets.json
Runs on Keyword Research & Autocomplete Scraper ($0.01 per seed that returns ideas — a 20-seed session ≈ $0.20; empty seeds free).

4 · YouTube video → GPT-4o-mini executive brief → Gmail

Drop in a video URL; get a TL;DR, five timestamped key points, notable quotes, and a who-should-watch verdict in your inbox. Transcript fetching prefers human captions over auto-generated.

https://inmanjeffrey89-cell.github.io/data-tools/workflows/t4-youtube-ai-summary-gmail.json
Runs on YouTube Transcript Scraper ($0.002/video; uncaptioned videos free) + your OpenAI key (under a cent per brief with GPT-4o-mini).

Setup (same for all four)

  1. Create an Apify account and copy your API token (Console → Settings → API & Integrations).
  2. In n8n, add a Header Auth credential — Name: Authorization, Value: Bearer YOUR_APIFY_TOKEN — and select it on the HTTP node(s).
  3. Open the Config node, set your own values, connect Gmail/Sheets/OpenAI on the last node, hit test.

Each workflow documents itself — the sticky notes inside carry the full description, costs, and setup. MIT-licensed like everything else here. Built by an indie dev; issues → GitHub.