Your research sheet, in seven small steps

1Create a blank sheet

Go to sheets.new and name it, e.g. HuntGo Pipeline. Don't create any tabs — the script builds them all.

2Paste the script

1. In the sheet: Extensions → Apps Script.
2. Delete everything in the editor, then paste the script:

For appsscript.json: Project Settings ⚙ → tick “Show appsscript.json”, open it, paste over. It sets the London timezone and the exact permissions. Save with ⌘S / Ctrl+S.

3First run

1. Function picker → formatSheets → Run.
2. Google asks to authorise: your account → Advanced → Go to … (unsafe) → Allow. It's your own script in your own account.
3. Wait ~1 minute for “Execution completed”. Every tab now exists.

4Deploy as a web app

1. Still in the Apps Script editor, click the blue Deploy button (top-right) → New deployment.
2. In the dialog, click the ⚙ gear next to “Select type” and choose Web app.
3. Fill the three fields:
   · Description — anything, e.g. HuntGo
   · Execute as — Me (your email)
   · Who has access — Anyone ← this one matters
4. Click Deploy. If Google asks to authorise again: Authorise access → your account → Advanced → Go to … (unsafe) → Allow.
5. You'll see two URLs. Copy the Web app one — it ends in /exec — with the Copy button under it. Then click Done.

“Anyone” does not expose your sheet. The script refuses every request that does not carry your own api_token, which it creates for you in Step 3 — so the URL on its own opens nothing. You copy that token in Step 5.

5Connect the extension

Two things go into the extension: the URL, and the token your sheet made for you. Both are required.

1. Copy your token: open your Google Sheet → the Settings tab at the bottom → the value next to api_token (a 32-character code). Not there? In the Apps Script editor pick showApiToken in the function list and press Run — it prints the token in the log.
2. In Chrome, click the HuntGo icon in the toolbar (pin it via the 🧩 puzzle icon if hidden).
3. Click the ⚙ gear at the top of the popup — the Settings page opens.
4. In the Pipeline section paste your /exec URL into Pipeline URL and the 32-character code into Pipeline token.
5. Click Test connection. Expect: “Connected — HuntGo pipeline v93”.
6. Click Save settings (bottom-left).

Without the token every request is refused, so nobody who finds your /exec URL can read or write your sheet. To change it later: clear the api_token cell, run formatSheets again, and paste the new code into the extension.

6Your free trial key

HuntGo needs a key even to try it — the trial is 5 hunts and 5 Terapeak validations.

1. Get a free key at pycodeltd.gumroad.com/l/huntgo-trial — your email, no card. The key appears on the next page and in your inbox.
2. In the extension's ⚙ Settings → Plan, paste it into Licence key and press Activate.
3. Ready for more? Starter and Pro lift the limits to 50 or 100 a day.

7Tune it (optional)

The sheet's Settings tab controls winner-alert emails, your eBay fee model (business or private, category fee %, VAT) — edit a cell and every winner row's profit recomputes live.