📱 Validate social media posts in Google Sheets and send issues to Slack
⚡ 1 views · 📱 Social Media & Email Marketing
Description
Quick overview
This workflow manually checks social media post drafts stored in Google Sheets, validates required fields and duplicates per platform, optionally alerts a Slack channel about new or changed issues, and writes status and validation results back to the sheet.
How it works
- Starts when you manually execute the workflow in n8n.
- Reads all post rows from a Google Sheets worksheet.
- Validates each row (unique post_id, supported platform, non-empty content, image URL format) and flags duplicate content per platform, producing READY_FOR_REVIEW or NEEDS_FIX statuses.
- If any post has new or changed validation issues, sends a formatted alert message to a specified Slack channel.
- Updates the corresponding rows in Google Sheets (matched by post_id) with status, validation_result, and checked_at.
Setup
- Create a Google Sheet with columns post_id, platform, content, image_url, status, validation_result, and checked_at, and ensure each row has a unique, non-empty post_id.
- Add Google Sheets credentials in n8n and replace the spreadsheet ID and target sheet in both Google Sheets nodes.
- Add Slack credentials, set the target Slack channel, and ensure the Slack app/bot is invited to that channel.
🔗 Nodes Used
Google Sheets, Slack
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File