Trigger: Schedule (Daily 8:00 AM)
    ↓
Action 1: Apify — Scrape Substack Leaderboard (Top 5 newsletters)
    ↓
Action 2: Code Node — Append /feed to URLs
    ↓
Action 3: RSS Feed Read — Pull latest posts from top newsletters
    ↓
Action 4: Claude 3.5 Sonnet — Curate & summarize with hot takes
    ↓
Action 5: Notion — Create database entries (your public archive)
    ↓
Action 6: Google Sheets — Read subscriber list
    ↓
Action 7: Gmail — Batch send (40 per batch)
    ↓
Outcome: Daily newsletter sent, archive updated, zero manual work

{
  "node": "Schedule Trigger",
  "settings": {
    "rule": "0 8 * * *",
    "timezone": "Australia/Sydney"
  }
}

{
  "actorId": "pepe~substack-leaderboard-scraper",
  "input": {
    "category": "technology",
    "maxItems": 5
  }
}

const newsletterUrls = $input.all().map(item => ({
  feedUrl: item.json.url + '/feed'
}));
return newsletterUrls;

{
  "system": "You are the editor of a cult newsletter. I will give you the text of 5 trending articles. 1. Select the top 3 most interesting ones. 2. For each, write a 'Hot Take' (1 sentence, punchy, contrarian) and a 'Summary' (2 sentences). 3. Assign a 'Must Read' score (1-10). 4. Output strictly in JSON format: [{title, url, hot_take, summary, score}]."
}

{
  "batchSize": 40,
  "bcc": "{{ $json.subscriberEmails }}",
  "subject": "Daily Insight: {{ $json.topStory.title }}",
  "body": "<h3>Today's Top 3 Reads</h3>..."
}