n8n

How to Automate WordPress Summaries and Team Alerts?

Turn every new or updated WordPress post into a short, clean summary without busywork. Editors and marketers get a fast way to add consistent highlights to articles while keeping a clear record and alerting the team. It fits teams that publish often and want quality and speed.

You can run it on a schedule or trigger it by webhook when a post is published. The workflow pulls posts, loops through each one, and checks Google Sheets to see if a summary already exists. It then grabs the raw post, converts HTML to Markdown, and uses a text classifier to detect if a summary is already in the content. If not, it sends the post to OpenAI to create a neat HTML summary. The summary is added at the top of the post while the original excerpt is preserved. A new row is saved in Google Sheets for tracking, and Slack sends a message to your channel.

Set up WordPress access, an OpenAI API key, a Google Sheet with matching column names, and a Slack connection. Choose schedule for batch processing or webhook for near real time. Expect faster publishing, fewer errors, and a clear audit trail. This suits content teams, agencies, and companies that run WordPress blogs and need reliable, repeatable summaries at scale.

What are the key features?

  • Multiple triggers including manual test, schedule, and secured webhook for flexibility
  • Date and time offset ensures only new posts are processed on a schedule
  • WordPress post retrieval in edit context to access raw content safely
  • HTML to Markdown conversion for cleaner AI input and better structure
  • AI text classifier to detect existing summaries and avoid duplicates
  • OpenAI model generates a styled HTML summary ready for WordPress
  • WordPress update call prepends the summary and preserves the excerpt
  • Google Sheets row check prevents reprocessing and logs final results
  • Slack channel notification informs the team when a post is summarized
  • Loop over items handles one or many posts in a single run

What are the benefits?

  • Reduce manual summary writing from 15 minutes to about 2 minutes per post
  • Automate up to 90 percent of blog summarization work with consistent output
  • Eliminate duplicate summaries by checking both Google Sheets and in-post content
  • Speed up team awareness with instant Slack notifications
  • Keep a reliable audit trail in Google Sheets for reporting and QA
  • Support both batch runs and near real time updates without extra effort

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with WordPress, OpenAI, Google Sheets and Slack. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, connect WordPress: double click any WordPress node, choose Create new credential, enter your site URL and either an application password or your chosen auth method, then test and save.
  4. Connect OpenAI: open the OpenAI node, create a new credential, paste your API key from the OpenAI account API keys page, then test and save.
  5. Connect Google Sheets: open the Google Sheets nodes, create a new Service Account or OAuth credential, follow on screen steps, and share your Sheet with the service account email if using a service account.
  6. Connect Slack: open the Slack node, create a new OAuth credential, approve the app in your workspace, then select the target channel.
  7. Choose your trigger mode. For scheduled runs, open Schedule Trigger and set the interval, then confirm Date and Time Subtract matches your interval.
  8. For webhook runs, open the Webhook node, keep header auth enabled, copy the URL, and configure your WordPress site or custom code to POST the post_id and required fields to this URL after publish.
  9. Open the WordPress Get Last Posts or Get All Posts nodes and confirm filters. In testing, keep the limit small to avoid high AI costs.
  10. Open the HTML to Markdown node and leave the default mapping to clean post content before AI processing.
  11. Open the Text Classifier node and confirm categories for summarized and not_summarized. Leave the selected model and template or adjust if your format differs.
  12. Open the OpenAI generation node and customize the system prompt to match your site theme and desired HTML style.
  13. Open the WordPress Update Post node and verify the content merge expression so the new summary appears before the original content, and confirm the excerpt logic.
  14. Open the Google Sheets Add Row node, pick your Sheet and tab, and ensure column names match the field names used in the Set node.
  15. Run a manual test. Confirm the post shows the new summary at the top, a row appears in Google Sheets, and a Slack message is posted. Run again to verify duplicates are skipped.
  16. Troubleshooting tips: if WordPress fails, check permissions or application password; if Sheets fails, share the document with the service account; if Slack does not send, check channel access; if costs rise, lower batch size or increase schedule interval.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Slack

Sign up

Free plan: $0 / mo; limited to 10 apps (third-party or custom) and usable via Slack API

WordPress

Sign up

Free plan: $0 / mo (WordPress.com REST API supports creating posts)

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.