Reporting & Automation

Build a Custom AI Dashboard

Describe your view, Claude builds and schedules the script.

Command

Use the Peec MCP to pull the following default dashboard view: one row per tracked brand with columns for visibility score, sentiment score, share of voice, and week-on-week change for each metric, covering the last 7 days. Once you have the data, write a Google Apps Script that formats it exactly this way and outputs it to a new Google Sheet. Use conditional formatting to highlight any cell where the week-on-week change is negative. Include comments in the script explaining each step and add instructions for scheduling it to run automatically each week. If I have a custom layout in mind, I can describe it and you can adapt the script accordingly.

What this use case can do for you

What this use case
can do for you

The gap between the dashboard you want and the dashboard you have is usually a developer request away. That request sits in a backlog, gets deprioritized, and you end up exporting CSVs manually every week for the next 18 months.

This closes that gap without touching the development queue. Describe the view you want in plain language, and Claude writes the script that builds it: connected to live Peec data, formatted exactly the way you specified, and set up to refresh automatically on whatever schedule you choose.

Railsware's Eugene built exactly this kind of custom view with Peec data using the MCP. The same approach works for any layout, any metric combination, and any destination: Google Sheets, Notion, Coupler.io, or wherever your team already works.