In today’s fast-paced world, the rate of change is nothing short of astonishing. For companies like Konamiya, keeping up with the latest tools, strategies, and breakthroughs in artificial intelligence can be more challenging than ever. To ensure we always provide our clients with the best advice and the most efficient solutions, we needed a way to continuously monitor, evaluate, and integrate the most critical updates from the AI landscape.

Embracing a No-Code, API-Driven Approach

Rather than writing custom code or maintaining our own servers, we opted for a no-code solution that leverages powerful APIs. This approach enables us to collect, process, and distribute vital information quickly and reliably—all while keeping our operational overhead low. Our primary goal was to build a newsletter that aggregates insights from numerous YouTube channels known for distilling complex AI information into accessible content.

Our Technology Stack

To build this innovative solution, we carefully selected tools that are reliable, cost-effective, and easy to integrate:

• Make.com: The backbone of our system, used to construct the core automation logic.
• RapidAPI: Employed to extract audio from YouTube videos in MP3 format.
• Runpod: Utilized to convert audio to text via a specialized transcription model.
  Affiliate Program: Runpod
• Elevenlabs: Responsible for creating the voice version of the newsletter.
  Affiliate Program: Elevenlabs

Our Data Organization: The Spreadsheet

For our database, we rely on a flexible and straightforward spreadsheet that organizes all the key information required for our newsletter. Our primary spreadsheet contains eight columns:

• STATUS: Reserved for future use.
• ACTION: Reserved for future use.
• IsEnabled: Indicates whether a channel should be monitored.
• Category: Provides context about the channel and helps tailor prompts.
• Channel URL: Direct link to the YouTube channel for quick reference.
• RSS ID: Identifier used by the RSS Feed module in Make.com.
• Group Name: Specifies which newsletter group the channel belongs to (multiple groups are possible).
• Filter Prompt: Used to filter videos based on their title to ensure relevance for the newsletter.

How the Automation Works: A Step-by-Step Overview

Our automated newsletter creation is broken down into several key scenarios within Make.com:

1. YouTube Feed Aggregation

Once a day, at a scheduled time, the system triggers the first phase of automation. The spreadsheet module scans the database for all rows marked as “enabled.” After filtering out irrelevant entries, qualifying records are transferred to a secondary working sheet dedicated to that day’s newsletter. The process then aggregates all the entries and waits for 10 minutes—ample time to ensure that all operations have been completed before proceeding to the next step.

2. Video Processing via RapidAPI

In the next phase, when triggered with the appropriate parameters, the system sends the video URL to RapidAPI. The API fetches the audio in MP3 format, and the corresponding status is updated in the spreadsheet.

3. Handling Transcription Tasks

After processing, RapidAPI returns task information via a callback URL. If successful, the task is forwarded to Runpod for transcription. In cases of error, the system automatically retries the request. Should errors persist, an alternative RapidAPI call retrieves the MP3, and once the task succeeds, transcription via Runpod is initiated.

4. Compiling the Final Newsletter

Triggered by the main scenario after the 12-minute wait, this phase gathers all the data from the newsletter spreadsheet. It performs several tasks:

• Verification: Confirms that videos are not YouTube Shorts.
• Summarization: Sends the transcription to ChatGPT, which generates a concise summary of the video.
• Voice Transcript Preparation: Prepares a text version for the voice newsletter and sends it to ChatGPT.
• Audio Generation: The text is then sent to Elevenlabs, which creates a voice file that is saved to Google Drive.
• Final Assembly: All relevant information—including thumbnails, video links, and summaries—is compiled into a final HTML document via ChatGPT.
• Distribution: The final HTML is emailed through Gmail to the team members who rely on this solution.

Daily Efficiency and Added Value

Our system is designed for continuous updates. Every morning, users can catch up on any content missed from the previous day or new updates released overnight while they were asleep. The voice version of the newsletter, in particular, is perfect for absorbing information during a morning coffee—making it an ideal solution for busy professionals.

Future Enhancements

Looking ahead, we are planning to expand our monitoring capabilities beyond YouTube. Soon, we will include blogs and manufacturer websites to gather additional information, allowing us to overcome the current limitations of relying solely on YouTube content.

Cost Analysis

Creating a newsletter based on 10 videos typically involves about 400 operations in Make.com. The expenses break down as follows:

• GPT API: Approximately 10 cents per newsletter.
• Runpod Transcription: Roughly 1 cent per video transcription.
• Elevenlabs: The most significant cost, with a $22 monthly subscription allowing for about 30 voice newsletters.

Conclusion

By harnessing the power of no-code platforms and a well-integrated technology stack, we have developed an automated, efficient, and cost-effective AI newsletter solution. This system not only keeps us up-to-date with the latest advancements in the AI industry but also ensures that our clients receive timely, high-quality insights in both text and audio formats.

In summary, our automated AI newsletter is a testament to how modern technology can simplify complex processes. With this innovative solution, you can catch up on missed content, absorb updates during your morning coffee, and stay ahead in the dynamic world of AI. Whether it’s through written insights or engaging voice summaries, our goal is to empower you with the information you need to adapt and thrive in an ever-changing digital landscape.

Looking ahead, we are expanding our monitoring capabilities beyond YouTube by including blogs and manufacturer websites, ensuring a richer and more comprehensive flow of information. This means that every morning, you’ll have the opportunity to catch up on any updates from the previous day or overnight developments while you enjoy your coffee.

For further insights into our approach and the world of AI automation, explore our related articles:

• Getting Started with Make.com Automation
• How We Automated Lead Qualification with Retell AI, Make.com, and ClickUp
• How to Kickstart AI Automation in Your Company: A Long-Term Cultural Shift, Not Just a One-Off Project

Let’s Collaborate

If you’re looking for this or any other AI-driven solution to optimize your information flow, streamline your processes, or simply stay ahead in the AI landscape, we’re here to help. Please write to us at [email protected] and let’s bring your AI solutions to the next level!