Automation6 min read
Frank A.
Send a WhatsApp satisfaction survey in 5 minutes: ChatGPT builds the Google Form, Levvo MCP delivers it to your contacts
Ask ChatGPT: "Write a Google Apps Script that creates a satisfaction Form (NPS + 3 open questions) and gives me the link." Copy it. Paste https://be.levvo.space/mcp in ChatGPT, authorize on Levvo's consent screen, and ask: "Send this link to all contacts with closed-won chats in the last 30 days in my shared inbox, Tuesday at 10 AM." ChatGPT uses its task scheduler and fires. No manual Google Forms, no copy-pasting numbers, no expensive survey tools.
The problem: you want to measure satisfaction, but the process stops you
Month ends, you want to know how the client experienced it. Real options:
- Typeform / SurveyMonkey / Manual Google Forms: build form, copy link, open WhatsApp Web, hunt contacts one by one, paste, send. 45 minutes for 50 contacts.
- WhatsApp Business API templates: need Meta pre-approved template, rigid variables, per-message cost, 24-48h wait.
- CRM native surveys: HubSpot, Pipedrive have modules, but clients don't log into portals. The reply lives in WhatsApp.
- Ask IT / Marketing: ticket, sprint, two weeks.
Result: you don't send it. Or you send to 10 contacts "by hand" and the data is useless.
The solution: ChatGPT builds the Form, Levvo MCP distributes it. You just approve.
Two steps, one ChatGPT conversation:
Step 1 — ChatGPT generates the Google Form (Google Apps Script)
Write a Google Apps Script that: 1. Creates a Google Form titled "Satisfaction Survey [Month] - [Your Company]" 2. Includes these questions: - Question 1 (0-10 scale, required): "How likely are you to recommend [Your Company] to a colleague?" (NPS) - Question 2 (Open): "What did you value most about the experience?" - Question 3 (Open): "What could we have done better?" - Question 4 (Open, optional): "Anyone on the team you want to highlight?" 3. Configures response collection in a linked Google Sheet 4. Returns the public Form link and Sheet ID for real-time responses
ChatGPT returns the script. Copy, paste in script.google.com, hit ▶️ Run, authorize. 10 seconds later: live Form + link.
Step 2 — Levvo MCP distributes the link to your contacts
You have access to Levvo's MCP. Do the following: 1. Identify in my Shared Inbox all contacts that: - Have tag
closed-won- Last chat within the last 30 days - Have an assigned owner (any team member) 2. Deduplicate by phone number (one contact = one send, even with multiple chats) 3. Draft the send message: > "Hi [Name], thanks for trusting [Your Company]. 2 minutes for this satisfaction survey: [FORM_LINK]. Your feedback makes us better. Thanks!" 4. Schedule sending for next Tuesday at 10:00 AM (peak WhatsApp B2B open window). 5. Confirm the final list: Contact, Owner, Last chat, Scheduled date/time. 6. Execute automatic send at date/time via MCP. Notify me per send.
ChatGPT shows the table. You review, say "confirmed." Tuesday 10 AM messages fire automatically.
Why this beats any survey tool / CRM
| Survey Tool / CRM | Levvo MCP + ChatGPT |
|---|---|
| Build form in their UI, generic link | ChatGPT generates custom Form (questions, logic, branding) in 1 prompt |
| Upload CSV / hunt contacts manually | MCP reads your live inbox and filters by tag, date, owner |
| Bulk send, same time for all | Schedule whenever (ChatGPT task scheduler) |
| Don't know if client already replied | Live Sheet + MCP can check "replied?" and skip resend |
| Cost per response / subscription | $0: Google Forms free, MCP included in Levvo |
| Rigid Meta template | Free, human message with name and direct link |
Master prompt (copy, paste, run)
Block 1 — Generate Form (in ChatGPT without MCP):
Write a Google Apps Script that creates a Google Form titled "Satisfaction Survey [Month] [Company]" with: (1) NPS 0-10 required, (2) "What did you value most?" open, (3) "What would you improve?" open, (4) "Who to highlight?" open optional. Link to Sheet. Give me Form link and Sheet ID.
Block 2 — Distribute via MCP (in ChatGPT with Levvo MCP active):
You have access to Levvo's MCP. Identify contacts in Shared Inbox with tag
closed-wonin last 30 days, deduplicate by phone. Draft: "Hi [Name], thanks for trusting [Company]. 2 min for your feedback: [FORM_LINK]. Thanks!" Schedule Tuesday 10:00. Confirm list (Contact, Owner, Last chat, Scheduled). Execute via MCP.
Variants that solve other cases
Variant A: Only lost deals (closed-lost)
Filter tag
closed-lastlast 60 days. Message: "Hi [Name], we didn't close. Your feedback is gold: what was missing? [FORM_LINK]. 2 min. Thanks."
Variant B: Per rep (each sends to their own leads)
Group by Owner. For each owner, generate message: "Hi [Name], it's [Owner]. Your thoughts on our work: [FORM_LINK]". Schedule staggered (Owner A 09:30, Owner B 10:00, Owner C 10:30) so responses don't flood the Sheet.
Variant C: Automatic 48h reminder
Add to prompt: "If 48h after send no response in Sheet for that contact, resend reminder: 'Hi [Name], in case you missed it: your feedback in 2 min [FORM_LINK]. Thanks!'"
Variant D: Transactional NPS (post-support / post-delivery)
Filter tag
support-resolvedordelivery-confirmedlast 7 days. Contextual message: "Hi [Name], your case/delivery closed yesterday. How was it? [FORM_LINK]"
Security: you control what, to whom, and when
| Control | Implementation |
|---|---|
| Pre-approval | ChatGPT shows full table BEFORE scheduling. You confirm or tweak. |
| MCP token scopes | Only send_message on own lines. No delete, no billing, no cold outbound. |
| Auto-deduplication | One phone = one send. Even if contact has 5 chats with 3 reps. |
| Opt-out exclusion | If contact has tag no-surveys or opt-out, MCP auto-excludes. |
| Daily limit | Configurable quota (e.g., max 200 surveys/day). Excess queues to next day. |
| Instant revocation | Levvo Panel → MCP → Revoke. Pending tasks fail safe. |
| Full audit | Every send logged: contact, owner, message, timestamp, Form link. |
What you see in the Google Sheet (real-time)
| Column | Value |
|---|---|
| Timestamp | When they replied |
| NPS (0-10) | Score for overall NPS and per-rep NPS |
| What valued | Qualitative strengths insights |
| What improve | Qualitative weakness insights |
| Who highlight | Internal recognition, team culture |
| Phone (hidden) | Cross-reference with Levvo for owner, tags, history |
DIY dashboard in 1 min: Open Sheet → Insert → Chart → NPS avg by month, by rep, by tag. Free. No BI tool.
Next steps (today, in 10 minutes)
- Open ChatGPT and paste
https://be.levvo.space/mcpin Connectors → Developer mode. - Authorize on Levvo's consent screen with your account.
- Run Block 1 (no MCP) → copy script →
script.google.com→ ▶️ → authorize → save Form link. - Run Block 2 (with MCP) → paste Form link → review table → "confirmed".
- Forget it. Tuesday 10 AM survey hits your clients. Replies land in your live Sheet.
Measuring satisfaction stops being "Marketing project for next quarter" and becomes a 10-minute routine the sales manager runs every month. Real data, in the channel where the client lives, no extra tools, no IT.
Frequently asked questions
- **Do I need ChatGPT Plus/Pro?**
For generating the script (Block 1): no, free tier works. For scheduling the send via MCP (Block 2): yes, need task scheduler (Plus/Pro/Team/Enterprise). Alternative: generate script free, run distribution prompt manually Tuesday 10 AM without "schedule for...".
Works with Lead Tracking (personal lines) and Shared Inbox? Yes. Change prompt: "Identify in my Lead Tracking lines..." or "in my Shared Inbox...". Or both: "in Shared Inbox AND Lead Tracking".
What if contact already answered the survey? Reminder prompt (Variant C) checks Sheet: "If 48h after send no response in Sheet for that phone, resend." If already replied, no resend.
Can I personalize message per rep? Yes. Variant B: "Group by Owner. For each owner, generate message: 'Hi [Name], it's [Owner]...'". Each rep sends to their leads, replies land in same Sheet.
Is the Form link public? Can anyone fill it without being a client? Link is public (anyone with link). To restrict: add
setRequireLogin(true)in script (only your Google Workspace users) or validate in Sheet cross-referencing phone. For B2B post-sale, public link usually fine; message context ("thanks for trusting X") filters.How do I get the MCP token? There's no token to copy. Paste
https://be.levvo.space/mcpin ChatGPT (Connectors → Developer mode), authorize on Levvo's consent screen with your account, and you're connected.Can I use Microsoft Forms instead of Google Forms? Yes. Change Block 1: "Write a Power Automate / Graph API script that creates a Microsoft Form...". Block 2 identical: Levvo MCP just distributes whatever link you give it.
What if ChatGPT crashes on scheduled day? Task scheduler retries. If definitive failure, Levvo logs error in audit and notifies you. You can manual re-run: "Resend pending from yesterday's table."