Score content virality with OpenAI, Google Sheets and Slack
VerifiedScores content virality with AI and logs results via HTTP.
What this workflow does
This automation accepts content via webhook or cron, retrieves external signals over HTTP, and uses an AI Agent powered by OpenAI to produce structured virality predictions and engagement estimates.
It suits marketing and content teams that need automated scoring and structured output without manual data aggregation.
Who is this for?
Content marketers, social media managers, and growth teams who publish regularly and want data-driven scoring before distribution.
What problem it solves
Evaluating content virality manually is slow and subjective; this workflow automates signal collection, AI scoring, and team alerts in one flow.
Live workflow preview
Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.
Open the template on n8n to import and run it. View source template →
What it automates
Blog post pre-check
Score draft articles on weekdays at 9am using historical sheet data and trends before publishing.
Social media submissions
Accept webhook posts from creators, score them instantly, and notify Slack only on high/moderate potential.
Weekly content review
Log all scores back to Google Sheets while routing low-score items to SendGrid for revision notes.
How the workflow works
The 4 nodes in this automation, in order.
- 1HTTP RequesthttpRequest
- 2Codecode
- 3AI Agent@n8n/n8n-nodes-langchain.agent
- 4OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
Apps & integrations used
How to set up Score content virality with OpenAI, Google Sheets and Slack
- 1Add OpenAI API credentials to the AI Agent and OpenAI Chat Model nodes.
- 2Update Google Sheets nodes with your spreadsheet ID and credentials for historical reads and logging.
- 3Configure HTTP Request nodes with SerpAPI key and analytics API base URL plus token.
- 4Replace Slack webhook paths in the notification nodes with your incoming webhook URL.
- 5Set SendGrid Authorization header and email addresses in the email node for LOW-score alerts.
- 6Activate the workflow and test with the webhook URL or weekday cron trigger.
How to customize this workflow
- →Swap GPT-4.1-mini for another OpenAI model in the chat node.
- →Change the trigger from cron to always-on webhook only.
- →Add a filter node after scoring to route different score tiers to separate Slack channels.
- →Extend the Sheets log with extra columns for custom metadata fields.
Score content virality with OpenAI, Google Sheets and Slack: pros & cons
Pros
- +Pulls both historical and real-time signals before scoring
- +Clear tier thresholds (HIGH/MODERATE/LOW) drive actionable notifications
- +Logs every result automatically for later analysis
- +Beginner-friendly with standard n8n nodes
Cons
- –Needs multiple paid API keys (OpenAI, SerpAPI, SendGrid)
- –Virality predictions remain estimates, not guarantees
- –Setup requires manual credential and URL replacements
Frequently asked questions
It accepts content via webhook or schedule, gathers performance and trend data, uses OpenAI to predict a 0-100 virality score, then alerts Slack or email and logs results to Sheets.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other ai & llm automations worth a look.