Make a spreadsheet with ChatGPT
Marketers can give ChatGPT a quarterly budget and a channel mix and get back a month-by-month plan with targets. With the MagicSlides connector, ChatGPT saves the plan as a spreadsheet instead of a table you have to copy out of the chat.
Set up MagicSlides in ChatGPT (one time)
Custom MCP connectors need a paid ChatGPT plan with developer mode or custom apps turned on.
https://www.magicslides.app/api/mcp/mcp- 1.In ChatGPT settings, open Apps & Connectors (or Plugins) and turn on developer mode under Advanced if asked.
- 2.Choose Create or Add custom MCP server, name it MagicSlides and paste the URL.
- 3.Set authentication to OAuth, save, and log in with MagicSlides.
Example: what you type in ChatGPT
Plan a Q1 2027 paid media budget of about $66k for Fernway Travel (fictional travel agency) across search, social, video and retargeting. Show monthly budgets, target CPA, expected leads and an owner per channel, and save it as a MagicSlides sheet.
- Split about $66k across 10 lines, weighted to booking channels
- Raised March budgets ahead of spring travel planning
- Calculated expected leads as Q1 spend divided by target CPA
- Called create_sheet with 12 rows including a totals row
The Q1 plan is saved as a MagicSlides sheet. It totals $66,200 with 1,372 expected leads, and Google Search and Meta take half the budget.
| Channel | Objective | Jan budget ($) | Feb budget ($) | Mar budget ($) | Q1 total ($) | Target CPA ($) | Expected leads | Owner |
| Google Search | Bookings | 6000 | 6000 | 7000 | 19000 | 38 | 500 | Lena |
| Meta (Facebook + Instagram) | Bookings | 4500 | 4500 | 5000 | 14000 | 45 | 311 | Lena |
| YouTube | Awareness | 2000 | 2000 | 2500 | 6500 | 0 | 0 | Omar |
| Traffic | 1200 | 1200 | 1500 | 3900 | 30 | 130 | Omar | |
| TikTok | Awareness | 1500 | 1500 | 2000 | 5000 | 0 | 0 | Priya |
| Microsoft Ads | Bookings | 800 | 800 | 900 | 2500 | 35 | 71 | Lena |
| Email (newsletter sponsorships) | Leads | 1000 | 1000 | 1000 | 3000 | 25 | 120 | Priya |
This is the real output from that prompt, made with the MagicSlides MCP. Open it to click through or download it.
How it works
- 1.In ChatGPT, turn on developer mode under Connectors or Apps
- 2.Add a custom MCP server with https://www.magicslides.app/api/mcp/mcp and log in
- 3.Give ChatGPT the budget, channels and goals, and ask for a MagicSlides sheet
- 4.Open the editor link, sign in and adjust numbers with your team
Tool used: create_sheet. Prefer a web app? AI spreadsheet generator does the same without an agent.
FAQ
Can ChatGPT use last quarter's numbers?
Yes. Upload last quarter's CSV or XLSX into the chat and ask ChatGPT to base the plan on it.
Does the sheet keep the formulas?
ChatGPT sends the values it calculated as rows. You can add formulas in the MagicSlides editor after it is created.
Why do I need to sign in to open it?
Sheets come back as an editor link, which opens in MagicSlides after you sign in.
Which ChatGPT plans support this?
Custom MCP servers are added with developer mode on paid ChatGPT plans.
More with ChatGPT
Sheets in other agents
Connect MagicSlides to ChatGPT
One MCP server for decks, docs, sheets and reels. Log in with your MagicSlides account, no API key. Making a deck from your own copy uses no AI credits.