When a magic button is clicked, add a row to a Google Sheet
Create your own WordPress analytics by tracking session data, such as button clicks.
Runs for: everyone, including visitors
Free plugin40,000+ WordPress sitesno per-task fees
A recipe is a deterministic automation: a trigger, optional conditions, and the actions that run when it fires, the same way every time. Built with your AI or by hand; runs without it.
Get this recipe on your site in three steps
-
Install Uncanny Automator free
In WordPress go to Plugins > Add New, search for Uncanny Automator, then install and activate. The plugin is free.
Start free -
Import the template
Go to Automator > Recipe templates, search “Magic Button” and click Import recipe to your site. It opens as a draft, with Install and Connect buttons if Magic Button or Google Sheets is missing.
-
Choose your settings and go live
Pick the settings for the Magic Button trigger and the Google Sheets action, then switch the recipe from Draft to Live. From now on it runs on its own, and every run is in the log.
Or build it by asking your AI
Connect ChatGPT, Claude, Gemini or any AI to your site, then paste the prompt. Your AI writes the recipe through Uncanny Automator’s MCP server and saves it as a draft you can open and edit. Built with AI. Runs without it.
ChatGPT
Claude
Gemini
Copilot
Perplexity
and any AI app that supports remote MCP servers
Works on the free plan, up to 150 tool uses a day.
When a magic button is clicked, add a row to a Google Sheet. Save it as a recipe and leave it in draft so I can review it.
Your AI finds the Magic Button trigger and the Google Sheets action, fills the fields, and hands you a link to open the draft in the builder. The Magic Button trigger still needs Automator Pro to run.
No AI subscription? Uncanny Agent is built in.
Related templates
Same trigger, different outcome
Same outcome, different trigger
More for Magic Button and Google Sheets
What is Uncanny Automator?
Uncanny Automator connects your AI to your WordPress site, so you can manage and automate the site with the AI you already use. It is an MCP server for WordPress with a built-in automation engine: ChatGPT, Claude, Gemini, Copilot, Perplexity or any AI app that supports remote MCP servers can act across every plugin and app on your site, and any task becomes a recipe that keeps running after the chat ends.
Manage your site with AI
Free, up to 150 tool uses a day. Posts, pages, users, orders, settings and the plugins you run.
The WordPress MCP server
Automations that keep working after the chat ends
Recipes like this one: built with your AI or in the visual builder, deterministic, editable, with every run logged.
Automations
Your plugins and apps, connected
Hundreds of WordPress plugins and apps working together, with no per-task fees.
IntegrationsLite is free for as long as you like. Pro adds every trigger, action and token plus conditions, queues, schedules, loops and data tools.
Is this template free?
Installing Uncanny Automator is free, and the Google Sheets action in this recipe is included in Lite. The Magic Button trigger is part of Automator Pro, so this recipe needs Pro to go live.
What is a recipe?
A recipe is a deterministic automation: one or more triggers, optional conditions, and the actions that run when they fire, running the same way every time. Built with your AI or by hand; runs without it. More about automations
What is an MCP server?
An MCP server is how AI apps such as ChatGPT or Claude connect to other software. Uncanny Automator is an MCP server for WordPress with a built-in automation engine: it connects your AI to your WordPress site, so you can manage and automate the site with your AI. The WordPress MCP server
Does the recipe need my AI to stay connected?
No. Your AI writes the recipe; Uncanny Automator runs it every time the trigger fires, whether or not an AI is connected. Built with AI. Runs without it.
Can I change the template after importing it?
Yes. It is an ordinary recipe in the visual builder: edit any field, add actions, pause it, duplicate it, and read every run in the log.
What if I don't have an AI subscription?
Import the template or build the recipe by hand in the visual builder. Uncanny Agent is also built in if you want an assistant without setting anything up.
Does it work with something other than Google Sheets?
Yes. The same Magic Button trigger also works with Mailchimp and Zoom Webinars: see the related templates below. Or browse every Magic Button template and the integrations directory.
Get this recipe running today
Free plugin, and the recipe is yours to edit. Import the template, or connect your AI and ask for it.