Generate LinkedIn Carousels from Viral Reddit Posts
This automation streamlines your content creation process by finding viral posts on Reddit based on your keywords, automatically converting the most engaging text post into a professional LinkedIn-style carousel using the Gamma API, and logging the results in a Google Sheet for easy tracking.
Airtop Community
Featured Apps
This automation is a powerful tool for content marketers and social media managers looking to create engaging content with proven appeal. Here's how it works:
- Discover Relevant Communities: The workflow starts by searching Reddit for communities (subreddits) that match your specified keywords. It then intelligently ranks these communities by their activity level to identify the most relevant ones.
- Identify Viral Content: It scans the top posts from the most active communities, looking for content that has gone "viral" based on a combination of upvotes and comments.
- Extract Post Content: The automation intelligently filters out image or link-based posts, focusing on the first high-scoring post that contains substantial text content. It extracts the title and body of the post to use as the source material.
- Generate a Carousel: The extracted text is sent to the Gamma API, which automatically designs and generates a visually appealing, multi-page carousel document, perfect for sharing on LinkedIn.
- Save the Results: Finally, the automation saves all the important information—including the original post title, its stats, and links to both the editable Gamma carousel and its PDF export—into a Google Sheet you specify. This creates an organized log of your generated content.
Usage Ideas
- Create a steady stream of high-engagement content for your company's social media channels.
- Monitor trends and discussions in your industry and quickly produce thought leadership pieces.
- Repurpose popular community-generated stories or advice into branded educational content.
- Generate lead magnets, like PDF carousels, based on topics you know your audience is interested in.
- Equip your sales team with relevant, timely content to share with prospects.
Customization Ideas
This template is a great starting point for your content creation workflow, and you have the flexibility to tailor it to your specific needs. You can:
- Target Any Topic: Change the search keywords to find viral content for any industry, niche, or subject matter.
- Define Your Destination: Easily direct the output to your own Google Sheet, allowing you to integrate this workflow with your existing content calendars or tracking systems.
- Control the Search Scope: Adjust how many communities and posts the automation analyzes, allowing you to perform either a quick, targeted search or a broad, comprehensive one.
- Change the Output Columns: Customize the columns in your Google Sheet to track the data that matters most to you.
- Source Content Differently: While it's set up for Reddit, the logic can be adapted to find popular content on other websites or social platforms.
Agent Inputs
Required Parameters
Name | Type | Default |
|---|---|---|
gammaApiKey | string | None |
Your Gamma API key, used for X-API-KEY authentication when generating carousels | ||
keywords | string | None |
Search keywords to find relevant subreddits on Reddit (e.g. 'Claude Code', 'AI agents') | ||
spreadsheetUrl | string | None |
URL of the Google Sheet where results (post title, subreddit, upvotes, comments, Gamma URL, PDF export URL) are saved | ||
Optional Parameters
Name | Type | Default |
|---|---|---|
maxPostsPerSubreddit | number | 10 |
Maximum number of top posts to extract per subreddit | ||
maxSubreddits | number | 3 |
Maximum number of top subreddits to scan for posts, ranked by weekly contributions | ||
