AI

ChatGPT Prompt Links in Google Sheets with HYPERLINK()

PromptClick 1.2.0 makes ChatGPT prompt links in Google Sheets work with a plain HYPERLINK() formula. What changed, why, and how to update old links.

By Makeinfo Team
#promptclick #chatgpt #gemini #google-sheets #chrome-extension #release-notes

If you tried to build ChatGPT prompt links in Google Sheets with PromptClick before this week, you probably hit a wall at the formula. You could type a link by hand, but HYPERLINK() wouldn’t touch it. PromptClick 1.2.0 fixes that. Prompt links are now ordinary web addresses, so one formula can turn a whole column of rows into one-click prompts.

This post covers what changed, the two problems behind it, and what to do if you already have links in a sheet.


The short version

  • New link format. Links now start with https://makeinfo.co/opengpt?prompt=. The old opengpt: links are gone.
  • HYPERLINK() works. You can generate a prompt link per row from your own data.
  • New-tab clicks are caught. Sometimes Sheets opens a link in a fresh tab instead of letting the extension see the click. PromptClick now handles that case too and closes the leftover tab.

The full list lives in the PromptClick changelog.


PromptClick used to listen for links like opengpt:?prompt=Summarize%20this. A made-up link scheme seemed tidy. Nothing else on the web would claim it, so the extension could safely grab every one.

The trouble is that Google Sheets doesn’t treat a made-up scheme as a link. HYPERLINK() is built for web addresses. Hand it an opengpt: URL and you get plain text, not a clickable cell.

That broke the whole point of the product. PromptClick exists so you can keep a sheet of products, leads or survey answers and fire a prompt off each row. If you have to create every link by hand, a sheet of 200 rows is an afternoon of clicking. Nobody does that twice.

So we stopped fighting the spreadsheet. A link that starts with https:// is something Sheets understands without complaint.


Make sure PromptClick is installed from the Chrome Web Store. Then pick the formula that fits your sheet.

One cell, one prompt

If column A holds the full prompt, put this in column B:

=HYPERLINK("https://makeinfo.co/opengpt?prompt=" & ENCODEURL(A2), "Ask AI ↗")

ENCODEURL() turns spaces, line breaks and symbols into a form that’s safe inside a web address. Don’t skip it. Without it, the first & or # in your prompt cuts it short.

A prompt assembled from your columns

This is where the change pays off. Say column A is a product name and column B is its main feature:

=HYPERLINK(
  "https://makeinfo.co/opengpt?prompt=" &
  ENCODEURL("Write a 2-sentence product description for " & A2 & ". Lead with this benefit: " & B2),
  "Write copy ↗"
)

Fill it down and every row gets its own tailored prompt. Edit the wording once and drag it again to update them all.

Prompts full of quotes

Double quotes inside a formula need escaping as "", which gets ugly fast. If a prompt is a mess of quotes and symbols, open the PromptClick popup and go to the Base64 tool. Paste the prompt, then copy the finished link. It ends in &encoding=base64, and the extension decodes it back to the original text.


Changing the address created a new problem.

PromptClick works by watching for clicks inside your spreadsheet. When it sees a prompt link, it cancels the normal navigation and opens ChatGPT or Gemini instead. With a real web address, though, Sheets doesn’t always play along. Sometimes it opens the link in a new tab before the extension ever sees the click.

Without a fix, that’s a dead end. You click a link and land on a makeinfo.co tab with no AI in sight.

Version 1.2.0 covers both routes:

  1. The click is caught in Sheets. Same as before: the extension cancels it and opens your AI tab.
  2. Sheets opens a new tab anyway. PromptClick also runs on makeinfo.co/opengpt. It reads the prompt from the address, opens ChatGPT or Gemini, then closes the makeinfo.co tab, so you don’t end up with a stray tab.

Either way you land in the same place, with your prompt typed in and ready to send. If auto-submit is on in the popup, it’s already sent.

A note on privacy

In the first route, the prompt never leaves your browser. The click is cancelled before any request goes out.

In the second route, your browser does request the makeinfo.co address, prompt included. That’s true of any link you open. PromptClick has no backend and keeps no record of your prompts. Even so, if a prompt contains something you wouldn’t paste into a URL, keep it out of a link.


Old opengpt: links don’t work in 1.2.0. The extension no longer looks for them. The fix takes about a minute per sheet:

  1. Open the sheet and press Ctrl+H (Cmd+Shift+H on Mac) to open Find and replace.
  2. Find: opengpt:?prompt=
  3. Replace with: https://makeinfo.co/opengpt?prompt=
  4. Tick Also search within formulas, then click Replace all.

Click one of the updated links to check it works. If it opens the AI tab, you’re done.


Who this update is for

It helps most if you run the same kind of prompt across many rows. Product copy, lead research and survey summaries all fit that shape. A formula you fill down beats a hand-made link every time.

It changes little if you mostly use the right-click Send selection to ChatGPT menu on web pages. That feature doesn’t use links at all and works exactly as before.


Try it

PromptClick is free. Install it from the Chrome Web Store, paste one of the formulas above into a sheet, and click. For more ways to cut busywork out of your spreadsheets, see our Google Sheets productivity tips, or read about everything else PromptClick does.