Library / Files & Cloud Storage
Files & Cloud Storage
Automate Google Drive + Reddit
On a schedule, it manages files with Claude using Google Drive, Reddit.
What it does
## Automatic Weekly Digital PR Stories Suggestions A weekly automated system that identifies trending news on Reddit, evaluates public sentiment through comment analysis, extracts key information from source articles, and generates strategic angles for potential digital PR campaigns. This workflow delivers curated, sentiment-analyzed news opportunities based on current social media trends. The final comprehensive report is automatically uploaded to Google Drive for storage and simultaneously shared with team members via a dedicated Mattermost channel for immediate collaboration. ### Set up instructions: 1. Add a new credential "Reddit OAuth2 API" by following this guide and Jina API key in the "Set Data" node. You can obtain your Jina API key here in the Mattermost node. You can follow this [guide]({{ $env.WEBHOOK_URL }} 6. You can adjust the cron if needed. It currently run every Monday at 6am.
The steps
- Split Topics into Items
- Search Posts
- Upvotes Requirement Filtering
- Set Reddit Posts
- Remove Duplicates
- Loop Over Items
- Get Comments
- Extract Top Comments
- Format Comments
- Set for Loop
- Get News Content
- Set Final Report
- Convert to File
- Compress files
28 steps in total.
Similar automations
Content Writing & GenerationTurn Reddit Pain Points into Comic Ads with GPT-4o23 stepsLead Generation & EnrichmentFind Sales Leads in Reddit Posts with OpenAI16 stepsLead Generation & EnrichmentAnalyze Reddit Posts for Leads and Draft Replies18 stepsContent Writing & GenerationFind LinkedIn Post Ideas from Reddit Posts with OpenAI17 steps