Library / Content Writing & Generation
Content Writing & Generation
Build an AI Newsletter from Crawled Sites with Dumpling AI
When you run it, it crawls website URLs from Google Sheets with Dumpling AI, has OpenAI summarize the content into a newsletter, and sends it via Gmail.
What it does
### 🌐 Get Website Content Using Dumpling AI This section starts with a manual trigger, then fetches a list of website URLs from a connected Google Sheet. Each URL is sent to Dumpling AI’s crawl endpoint, which extracts readable content up to a set depth. The response is an array of article-like results. These are then split one by one for individual processing. The Set node maps key fields such as the original URL, article title, and cleaned content for each page.
The steps
- Start Workflow Manually
- Get Website URLs from Google Sheet
- Crawl and Extract Site Content with Dumpling AI
- Split Extracted Results into Individual Items
- Map Title, URL, and Page Text
- Combine Articles into Single Prompt Format
- Generate HTML Newsletter with Subject Using GPT-4o
- Send Newsletter via Gmail
Similar automations
Content Writing & GenerationTurn YouTube Transcripts into Newsletter Drafts with GPT-4o7 stepsLead Generation & EnrichmentWrite Cold Email Icebreakers from Lead Websites with Dumpling AI8 stepsContent Writing & GenerationSend a Personalized AI Tech Newsletter from RSS with OpenAI17 stepsContent Writing & GenerationWrite AI News Commentary with Dumpling AI and GPT-4o12 steps