How to Automate Blog Post Generation Using Dumpling AI, ChatGPT, and Google Sheets in Make.com

Creating engaging, well-structured blog posts can be time-consuming. You must manually search for news, extract relevant content, summarize key insights, and structure it into a compelling blog. However, with Make.com and Dumpling AI, you can fully automate this entire process.

This automation does the following:

Uses Dumpling AI to fetch real-time news from multiple sources.
Scrapes and cleans full articles from various news sites.
Uses ChatGPT to generate high-quality blog content (title, excerpt, and full post).
Saves the generated blog post into Google Sheets for easy access and future publishing.

This guide will cover every step in detail, including how to set up a Dumpling AI agent, integrate it with Make.com, and configure the workflow to run automatically.

Benefits of This Automation

✅ Automated Content Creation – No need to manually search, extract, or write blog posts.
✅ Ensures High-Quality Content – AI structures content for readability and engagement.
✅ Fetches Real-Time News – Always keeps your blog posts fresh with the latest news.
✅ SEO Optimized – AI-generated titles and excerpts enhance visibility.
✅ Saves Time & Effort – Google Sheets organizes everything for easy management.

Step 1: Set Up a Dumpling AI Agent to Fetch News Articles

Before setting up the automation in Make.com, we need to configure a Dumpling AI Agent that will fetch news from multiple sources.

1.1. Create a Dumpling AI Account

If you don’t have a Dumpling AI account yet:

Visit Dumpling AI’s website
Sign up for an account.
Log in to access your Dumpling AI dashboard.

1.2. Access Agents in Dumpling AI

Navigate to the Default Project.
Select Agents from the sidebar.
You will see options like YouTube to Blog Post Agent, Lead Generation Agent, Web Scraping Agent.
Click “Create New Agent” to build a custom agent for fetching news articles.

1.3. Configure the Dumpling AI Agent

To make the agent capable of searching for news articles from multiple sources, add the following tools:

🔹 Perplexity Tool → Uses AI-powered search to fetch the latest news from high-authority sources.
🔹 Google Search News Tool → Extracts Google News results for relevant topics.
🔹 Google Search Tool → Retrieves articles directly from Google’s search index.

📌 Pro Tip: Combining these tools ensures you get the most relevant and diverse news sources for your blog posts.

1.4. Save and Deploy Your Agent

Click Save and Deploy the agent.
Copy the Agent ID – you will need this when connecting to Make.com.

Step 2: Monitor Google Sheets for New Blog Topics

Instead of manually triggering news searches, we use Google Sheets as the input source for blog topics.

2.1. Set Up a Google Sheet

Create a Google Sheet with the following structure:

📌 Make sure new topics are added in Column A.

2.2. Connect Google Sheets to Make.com

Module: Google Sheets – Watch Rows
Spreadsheet ID: Select your Google Sheet.
Sheet Name: “Sheet1”
Table First Row: “A1:Z1” (Ensures headers are included.)
Includes Headers: Yes
Limit: 1 (Processes one topic at a time.)

📌 This module watches for new blog topics and triggers the automation.

Step 3: Fetch Latest News Using Dumpling AI Agent in Make.com

Now, we use Dumpling AI Agent to fetch the latest news related to the blog topic.

3.1. Add Dumpling AI to Make.com

Module: Dumpling AI – Generate Agent Completion
Agent ID: Paste the Agent ID from Step 1.4.
User Input: “Get me the latest news on {{11.0}}”
- {{11.0}} dynamically pulls the topic from Column A in Google Sheets.
Parse JSON: Enabled (This ensures a structured response.)

📌 Dumpling AI fetches the latest news from multiple sources and returns structured data.

Step 4: Process Multiple News Articles One by One

Since Dumpling AI returns multiple news articles, we need to process them one at a time.This module iterates through multiple news articles, processing them one by one

Module Setup

Module: Iterator
Input: {{3.parse Json}} (JSON from Dumpling AI response.)

Step 5: Scrape Full News Content from Each Article

Now that we have URLs of news articles, we need to extract the full content.

Module Setup

Module: Dumpling AI – Scrape
URL: {{5.url}} (Dynamically fetches each news article URL.)
Format: “Markdown” (Ensures structured extraction.)
Cleaned: Enabled (Removes ads and unnecessary elements.)
Render JavaScript: Enabled (Handles dynamically loaded content.)

What This Does

Extracts full news article content.
Removes unnecessary elements like ads, comments, and sidebars.
Ensures clean and structured data for AI processing.

5.1. Add Error Handling (Ignore Step on Failure)

Module: Ignore Error Handling
Connected to: The Scrape URL Module

📌 Why This Is Important:
If an article cannot be scraped, this step prevents the entire workflow from stopping and allows the automation to continue processing the next article.

Error Handling:

Step 6: Combine All Scraped Articles for AI Processing

Now that we have multiple clean news articles, we need to merge them before passing them to ChatGPT.

Module Setup

Module: Text Aggregator
Row Separator: Empty
Value: “###\n{{6.content}}\n###” (Merges scraped articles into one document.)

What This Does

Merges all news articles into a single structured text.
Prepares content for AI processing.

Step 7: Use AI to Generate a Blog Post

With all the scraped data aggregated, we pass it to ChatGPT to generate a fully structured blog post.

Module Setup

Module: OpenAI – Create Completion
Model: “ChatGPT-4o-latest”
Temperature: 1 (Higher creativity.)
Max Tokens: 2048
System Instructions:
- Analyze and filter the news data.
- Generate a structured blog post with:
  - Title
  - Excerpt
  - Body content
- Return the response in JSON format.

What This Does

AI filters and restructures scraped news into a full blog post.
Ensures a compelling title, engaging excerpt, and well-structured content.

Expected AI Output:

{

“title”: “How AI is Revolutionizing Healthcare”,

“excerpt”: “AI is making significant advancements in healthcare, from diagnostics to treatment…”,

“content”: “The healthcare industry is experiencing a major transformation due to AI innovations…”

}

Step 8: Store the Blog Post in Google Sheets

Now, we store the final blog post in Google Sheets.

Module Setup

Module: Google Sheets – Update Row
Spreadsheet ID: “Your Google Sheet”
Row Number: {{11.__ROW_NUMBER__}}
Values:
- Blog Post (Column B): {{8.result.content}}
- Excerpt (Column C): {{8.result.excerpt}}
- Title (Column D): {{8.result.title}}

Conclusion

This automation is a powerful solution for effortlessly generating high-quality blog posts based on real-time news. By leveraging Dumpling AI, ChatGPT, and Google Sheets, you eliminate the need for manual research, content extraction, and writing—saving valuable time while ensuring your content stays relevant and engaging.

Key Takeaways:

✔ Scalable & Efficient – This workflow allows you to generate unlimited blog posts from multiple sources, making it perfect for content creators, bloggers, and news aggregators.
✔ Ensures High-Quality Content – AI structures articles in a way that enhances readability, engagement, and SEO.
✔ Reliable Automation with Error Handling – The inclusion of error-handling steps ensures that failed scrapes do not disrupt the entire process, allowing your automation to continue running smoothly.
✔ Dynamic & Customizable – You can easily modify this automation by adjusting the AI prompts, adding more scraping sources, or integrating it with publishing platforms like WordPress or Notion.