Track Daily Social Media Automation Posts
Automatically monitor top content creators in the automation/AI space, track their latest YouTube and TikTok posts, analyze trends, and generate video ideas with daily Slack notifications.
Last updated
January 15, 2025
Connectors used
Tags
Key Takeaways
- Tracks YouTube and TikTok daily - Searches for each creator's latest posts from the past 48 hours
- Generates video ideas - AI analyzes trends and suggests 3 YouTube and 3 TikTok ideas
- Saves to Google Sheets - Video ideas are written to separate sheets with duplicate detection
- Slack notifications - A daily summary is sent to your marketing channel
- Customizable - Add more creators, change platforms, or adjust the schedule
What This Workflow Does
This workflow monitors a list of content creators in the automation/AI space. Every day it reads your creator list from Google Sheets, searches the web for their latest YouTube and TikTok content (within 48 hours), analyzes trends, generates video ideas, saves them to Google Sheets, and sends a summary to Slack.
Use cases:
- Stay on top of trending content in the automation/AI space
- Generate video ideas based on what top creators are posting
- Keep your marketing team informed with daily Slack digests
How It Works
| Step | What Happens |
|---|---|
| 1. Scheduled trigger | Fires daily at 7am UTC |
| 2. Read creator list | Fetches names, focus areas, and social URLs from Google Sheets |
| 3. Parse creators | A code node converts sheet rows into structured creator objects |
| 4. Research YouTube content | For each creator, AI searches the web for their latest YouTube videos |
| 5. Research TikTok content | In parallel, AI searches for each creator's latest TikTok videos |
| 6. Generate YouTube ideas | AI analyzes all YouTube findings and suggests 3 video ideas |
| 7. Generate TikTok ideas | AI analyzes all TikTok findings and suggests 3 video ideas |
| 8. Save to Google Sheets | Ideas are written to separate YouTube and TikTok sheets (duplicates filtered) |
| 9. Merge results | YouTube and TikTok ideas are combined |
| 10. Send Slack notification | A formatted summary is posted to your marketing channel |
Setup Instructions
- Create a Google Sheet with columns: Name, Focus Area, YouTube URL, TikTok URL, Notes
- Add your creators to the sheet
- Update the sheet URL in the Google Sheets read node
- Connect your Google Sheets account in the workflow
- Create two output sheets (one for YouTube ideas, one for TikTok ideas)
- Replace
<YOUR GOOGLE SHEET URL HERE>in both AI nodes that write to Sheets - Connect your Slack workspace and select the target channel
- Click "Use template" and run the workflow
Customization
| What You Can Change | How |
|---|---|
| Creators | Add or remove rows in your Google Sheets creator list |
| Schedule | Change the cron expression in the trigger node (default: 0 7 * * *) |
| Platforms | Add new code/AI node paths for Instagram, LinkedIn, or Twitter/X |
| Number of ideas | Edit the AI prompt to generate more or fewer video ideas |
| Slack channel | Change the target channel in the Slack node |
| AI model | Change the model in any AI node (default: GPT-4.1) |
FAQ
Q: What does the creator list sheet need to look like? A: It needs columns for Name, Focus Area, YouTube URL, TikTok URL, and Notes. Each row is one creator.
Q: How does it avoid duplicate ideas in Google Sheets? A: The AI nodes that write to Sheets are instructed to read existing rows first and only add ideas that are not already present.
Q: Can I track platforms other than YouTube and TikTok? A: Yes. You can duplicate the research path and adjust the AI prompts and code nodes to target other platforms.
Q: Why 48 hours instead of 24? A: The 48-hour window gives a buffer for content that may have been published late in the previous day or indexed with a slight delay.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
