Skip to content
Signalcrest
Back to feed
stackoverflowweb

Google Apps Script Web App gives "Sorry, unable to open the file" error for other users despite "Execute as: Me" and openById()

Diagnoses a Google Apps Script web-app permission error affecting other users.

Steady
Signal score
18
Trajectory
Cooling
7-day est. ~9

Why this scored 18

every term, weighted
Velocity+0.0 / 40

Engagement gained per hour since the last capture, against the fastest item on its own source

Acceleration+11.5 / 25

Whether that velocity is itself speeding up, as a per-hour rate

Cross-source spread+0.0 / 25

How many independent communities are talking about the same entity

Recency+7.4 / 10

Decays to zero over 14 days

Saturation penalty1.0 / 30

Subtracted once something is big and old — we rank what's next, not what's peaked

Composite17.9

Weights are hand-tuned, not learned — we're calibrating them against realized trends as history accumulates. On a topic's first sighting there's no previous reading to compare against, so acceleration starts from a neutral prior rather than a measurement, and velocity falls back to engagement over its whole lifetime until a second reading exists. Full methodology

Outlook

low confidence · estimate, not a guarantee

7-day

~9

range 020

14-day

~0

range 014

30-day

~0

range 019

Signal history

7-day window (free)
946

projected trajectory (estimate, not a guarantee)

Entities

google apps scriptgoogle sheets
Embed a live signal badge
Signalcrest signal badge
[![Signalcrest signal](https://www.signalcrest.app/api/badge/so%3A80004304)](https://www.signalcrest.app/topic/so%3A80004304)

Drop this in a README or blog post — it updates automatically as the score moves.