# Get a sign-up dashboard for your event that updates itself

> If sign-ups stall a few days before your event, it tells you. If nothing changes, it stays quiet.

Point ChatGPT Work at the Google Sheet your sign-up form fills. It builds a private dashboard of registrations, sources and trends, refreshes it each weekday, and messages you only when something changes.

- Page: https://thesolocreators.com/prompts/self-updating-signup-dashboard/
- Category: Put your business on autopilot
- Made for: Coaches, Creators, Small business owners, Consultants
- Works in: ChatGPT
- Time: About 30 minutes to set up
- Effort: Advanced
- Note: Uses ChatGPT Work with Sites and a scheduled task. Web checks run with your laptop off. Sharing always needs your OK.

## The prompt

Fill in the parts in [square brackets], or leave them and the AI will ask you for them.

```text
Use Sites and Google Drive to build a private dashboard from my sign-up sheet: [SHEET LINK]. It's for [EVENT NAME, e.g. my April online workshop] on [EVENT DATE, e.g. April 24], and my goal is [SIGNUP GOAL, e.g. 60 sign-ups].

Show: total sign-ups against the goal, sign-ups per day, where people heard about it, ticket types if listed, and a last-updated time. First check for duplicates, blank rows and odd dates, and tell me what you found.

Then check the sheet every weekday morning and update the dashboard. Message me only when something matters, like a jump or a stall in sign-ups, a data problem, or the goal being reached. If nothing changed, stay quiet. Don't publish, share or change any permissions without asking me.
```

## Step by step

1. Connect Google Drive in ChatGPT under Customize, then Plugins.
2. Copy the link to the Google Sheet your sign-up form fills.
3. Paste the prompt in Work and check the dashboard it builds.
4. Approve the weekday check, and share the dashboard only if you choose to.

## What you'll get

A private, always-current sign-up dashboard and short alerts only when registrations jump, stall or hit your goal.

## Good to know

**Which AI tools does this work in?** It works in ChatGPT. On this page, ChatGPT opens with your prompt already typed in. Uses ChatGPT Work with Sites and a scheduled task. Web checks run with your laptop off. Sharing always needs your OK.

**How long does it take?** About 30 minutes to set up. It's rated "Advanced". There are 4 steps, listed above.

**What do I need before I start?** Just your details for 4 blanks: sheet link, event name, event date and signup goal. You can skip any, and your AI will ask for them.

**What will I get back?** A private, always-current sign-up dashboard and short alerts only when registrations jump, stall or hit your goal.

Idea spotted on the official docs, shared by OpenAI: https://learn.chatgpt.com/codex/use-cases/analyze-data-export. The prompt is The Solo Creators' own version.

## Go further

Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: Second Brain (Give your AI a memory it reads across every project, so it finally knows your business); Watch It For Me (Drop any video link and get the step-by-step playbook, the full timestamped transcript, and the best quotes. Without watching it).

From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.