How to Automate Google Searches and Generate Blog Post Ideas Using Dumpling AI in Make.com

Brainstorming blog post ideas can be a tedious process, especially when trying to align with trending topics or popular search queries. This automation combines the power of Google Sheets, Dumpling AI, and OpenAI to streamline your content ideation process. By automatically extracting trending keywords, analyzing search engine results, and generating blog post titles and outlines, this workflow saves time and ensures your content remains relevant and engaging.

Whether you’re a content strategist, blogger, or marketer, this setup will help you ideate smarter, not harder.

Step 1: Setting Up the Google Sheets Trigger

1. Create a Google Sheet
   • Create a sheet titled Content Ideation.
   • Add a column labeled Keywords to input the search terms you want to explore.
2. Add Google Sheets: Watch Rows Module
   • Log into Make.com and create a new scenario.
   • Add Google Sheets: Watch Rows to monitor newly added rows.
   • Connection: Authenticate your Google account if needed.
   • Spreadsheet: Select the Content Ideation spreadsheet.
   • Sheet Name: Choose the sheet containing your keywords (e.g., “Sheet1”).
   • Limit: Set to 1 to process one keyword per run.

Step 2: Using Dumpling AI to Perform Google Searches

1. Purpose: This step automates the Google search process, gathering fresh data from top search results to guide your content strategy.
2. Add Dumpling AI: Search Module
   • Add Dumpling AI: Search to the scenario.
   • Connection: Use your Dumpling AI connection or add it by entering your API key.
   • Query: Map the keyword from Google Sheets ({{1.Keyword}}).
   • Date Range: Select Past Week to prioritize recent trends.
   • Scrape Options:
     • Format: Set to Markdown for clean output.
     • Clean Data: Enable to remove unnecessary HTML tags.
3. Customize the Search Output
   • Number of Results to Scrape: Set to 3.
   • Scrape Results: Enable to include detailed results for analysis.

Step 3: Aggregating Search Results

1. Purpose: Aggregating search results ensures the data is clean and ready for the next step: blog idea generation.
2. Add the Text Aggregator Module
   • Use Text Aggregator to compile search results into a structured format.
   • Row Separator: Set to New Line (\n).
   • Values to Aggregate:
     • Title: Map the title of the search results.
     • Snippet: Map short descriptions or snippets from the search results.
     • Keywords: Include the original keyword for context.

Step 4: Generating Blog Post Ideas Using OpenAI

1. Purpose: OpenAI takes the aggregated search data and transforms it into actionable blog post ideas, complete with titles and summaries.
2. Add OpenAI: Create Completion Module
   • Add OpenAI: Create Completion to your scenario.
   • Model: Choose gpt-4o for advanced language understanding.

Prompt: Use the following prompt:

“Analyze the search results and generate blog post ideas. Focus on creating engaging and SEO-friendly titles with brief outlines. Search results: {{3.text}}”

• Max Tokens: Set to 2048 for detailed output.
• Temperature: Use 1 for balanced creativity.

Step 5: Saving the Output Back to Google Sheets

1. Purpose: This step ensures that all generated blog ideas are saved in the same sheet for easy review and implementation.
2. Add Google Sheets: Update Row Module
   • Add Google Sheets: Update Row to save the generated blog ideas.
   • Connection: Use your Google Sheets connection.
   • Spreadsheet ID: Select the Content Ideation spreadsheet.
   • Row Number: Map the row number from the trigger ({{1.__ROW_NUMBER__}}).
   • Columns to Update:

Blog Post Ideas: Map the output from OpenAI ({{4.result}}).

Step 6: Testing and Activating the Scenario

1. Run a Test
   • Add a keyword to the Keywords column in Google Sheets.
   • Run the scenario manually to confirm:
     • Dumpling AI fetches relevant search results.
     • OpenAI generates blog post ideas.
     • The output is saved back in Google Sheets.
2. Activate the Scenario
   Once testing is complete, activate the scenario to automate the entire workflow. Now, any new keyword added to the sheet will trigger blog idea generation.

Conclusion

This automation simplifies and accelerates content ideation by leveraging Dumpling AI for search data and OpenAI for creative idea generation. By following this guide, you’ll save time, focus on high-impact content, and ensure your blog remains fresh and relevant.

Get the Blueprint Featured in This Guide

Access the full blueprint here to get started on setting up this automation effortlessly!