Guide Analytics, GA4, FAQ Workflow
A Google Apps Script dashboard that pulls Zendesk Guide articles, GA4 Help Center search data, article performance, content gaps, and FAQ draft approvals into Google Sheets and a lightweight web app.
Click to simulate pulling reports and refreshing dashboard metrics with mock data.
| Search Query | Search Count | Best Article | Coverage | Action |
|---|
The production web app runs inside Apps Script and writes all outputs to Google Sheets.
syncZendeskGuideToSheets()
// Dashboard, Tracker, Full Content, Sync LogsyncGA4HelpCenterDashboard()
// Search Queries, Article Pages, Content GapssendFAQReviewToSlack(faqId)
// Approve, Request Revision, Open DocScreenshots from the deployed Apps Script web app, Slack review flow, and generated Google Sheets dashboard.
The deployed web app is not only a command panel. It displays live metrics from Google Sheets, including total articles, GA4 search events, article views, content gaps, FAQ draft count, helpful rate, top searches, and workflow status.
The FAQ tab shows draft status and action buttons for setting up FAQ sheets, refreshing the template, creating a new draft, sending review, syncing approved drafts, and installing automatic sync.
Reviewers receive a Slack DM with the FAQ ID, title, owner, reviewer, review instructions, and action buttons. They can approve, request revision, or open the Google Doc directly from Slack.
The system writes a finished report to the main Dashboard sheet, combining Zendesk content inventory, GA4 search demand, article performance, content gaps, and FAQ workflow metrics.
The production version is designed as an operational dashboard, automated sync tool, and FAQ review workflow in one Apps Script app.
The Pull All Reports action runs Zendesk sync first, then GA4 sync, then refreshes the main Dashboard sheet and web app metrics. This creates one finished report instead of separate manual exports.
The Auto Sync action installs a time-based Apps Script trigger. Approved FAQ drafts can be appended to the master Google Doc automatically on a recurring schedule, so the team does not need to manually check approved rows every time.
Pulls categories, sections, article metadata, labels, votes, promoted/draft state, timestamps, and full article body from the Zendesk Help Center API into structured Google Sheets tabs.
Reads GA4 Help Center data, parses user search terms from Zendesk search URLs, tracks article page views, total users, sessions, engagement seconds, and engagement rate.
Compares GA4 search queries against the Zendesk article tracker. Low match confidence queries are surfaced as content gaps with recommended actions such as creating a new article or improving titles and tags.
The web app has separate sections for Overview, Zendesk, GA4, FAQ, and Tools. It displays KPI cards, top searches, content gaps, top articles, workflow status, and operational action buttons.
Creates new FAQ draft Google Docs from the web app, logs each draft into the FAQ Drafts sheet, supports owner/reviewer/source fields, and keeps a master document for approved FAQ content.
Sends FAQ review requests to Slack with Approve, Request Revision, and Open Doc buttons. The interaction updates the FAQ Drafts sheet so review status stays visible in the dashboard.
Includes formatting helpers for readable Sheets, dropdown status validation for FAQ drafts, and a safe clear action that deletes report tabs while preserving FAQ Drafts and FAQ Template.
Built for support teams who need operational reporting, content gaps, and review workflow in one place.
Every report is written to readable Google Sheets, while the web app presents the same metric in a cleaner dashboard UI.
Parses Help Center search terms from GA4 and compares them against Zendesk content coverage.
Creates draft Google Docs, tracks status in Sheets, and sends Slack review buttons for approval or revision.