Connect your redirect Sheet
Browsers can't see another site's redirects, so this tab sends your paths to the script in your redirect Sheet and Google checks them. You set this up once.
- Open your redirect Sheet, then Extensions → Apps Script.
Code.gs should be v3.2.
- Click + next to Files, choose Script, name it
WebApp, paste in WebApp.gs and save.
- In the function list at the top, pick
createDashboardKey and click Run. Approve the permission prompt. Copy the key from the Execution log.
- Deploy → New deployment, click the gear, choose Web app. Set Execute as Me and Who has access Anyone. Click Deploy and copy the Web app URL (it ends in
/exec).
- Paste both below and click Save and test.
If you edit the script later, publish the change with Deploy → Manage deployments → pencil → Version: New version. The URL stays the same.