See llms.txt for all machine-readable content.

Back to Templates

Audit and fix WordPress pages against a Sheets fact sheet with Gemini and Slack

Created by

Created by: toshiyuki kikuchi || cmr-kikuchi
toshiyuki kikuchi

Last update

Last update a day ago

Categories

Quick overview

Audits your website against a Google Sheets fact sheet and fixes it in WordPress. A Gemini agent drafts a minimal edit for each outdated price, name or number; you tick fixes in Slack; n8n applies them, re-checks the live page and replies ✅ Fixed in its thread.

How it works

  1. Runs daily or weekly on a schedule, or starts on demand from an n8n Form submission.
  2. Loads the fact sheet from Google Sheets, fingerprints it, fetches the site sitemap, and compiles the list of page URLs to audit.
  3. Downloads each page, extracts readable text, matches it to the corresponding WordPress page/post source via the WordPress REST API, and skips pages that haven’t changed unless re-audit is forced.
  4. Checks each page for outdated values and conflicting numbers, then uses a Google Gemini agent to confirm ambiguous issues and draft minimal WordPress text replacements when possible.
  5. Posts new issues and proposed fixes to Slack, records them in n8n Data Tables, and updates existing findings as still open or fixed (replying in the Slack thread when resolved).
  6. Collects all proposed fixes at the end of the run, requests approval in Slack via an interactive form, and applies the approved edits to WordPress before re-checking the live page and updating Slack and the tracking tables with the result.
  7. Sends a Slack audit summary when something changed, and posts a weekly Slack report summarizing open issues, fixes, and time-to-fix metrics.

Setup

  1. Create and populate a Google Sheets fact sheet tab (for example “Facts”) with columns like fact_id, label, value, outdated, keywords, pages, and severity.
  2. Add Google Sheets credentials, a Google Gemini API connection, and Slack credentials with permissions to post messages and add reactions.
  3. Create a WordPress Application Password (or equivalent) and configure HTTP Basic Auth credentials for the WordPress REST API requests.
  4. Update the Workflow Configuration values for the Google Sheets URL/tab, sitemap URL, WordPress site URL, Slack channel ID, timezone, and applyMode (set to off to only propose fixes).
  5. If using the on-demand audit, copy the n8n Form URL and share it with reviewers who should be able to start audits and optionally provide a list of page URLs.

Requirements

  • Google Sheets with a Facts tab (fact_id, label, value, outdated, keywords, pages, severity), a WordPress site with an Application Password (Basic Auth), Google Gemini API key, Slack bot with chat:write and reactions:write, n8n with Data Tables

Customization

  • Set applyMode to off to only propose fixes, change the schedule, page limit or review language in Workflow Configuration, or scope facts to pages with the pages column (e.g. /pricing*).