Anyone who can open your sheet can read the key in the formula. That is why a Sheets key is a separate key: it only reads data as a table, and you can switch it off without touching your API key. New here? Create a free account and you get a Sheets key and starting credit to try this.
What a Sheets key can do
| Sheets key | API key | |
|---|---|---|
Read data as a table (format=csv) | yes | no |
| Read data as JSON | no | yes |
| Use MCP or webhooks | no | yes |
| Change anything on your account | no | no |
| Goes in an address | yes | never |
A Sheets key spends your credit, at most once a day per link.
If a sheet was shared too widely
- Open Team and keys Go to Team and keys in your dashboard.
- Switch the key off Under Google Sheets keys, choose Switch off on the key. Every formula with that key stops loading at once and shows a line saying the key is off.
- Create a new key Choose Create Google Sheets key and copy your formulas again from Templates.
Good habits
- One key per shared sheet. You can have up to 5. If one sheet leaks, the others keep working.
- Never paste your API key into a cell. The API refuses an API key in an address and says so.
Can someone with my Sheets key run up a bill?
Each different link costs once a day, so a person would have to load many different addresses. Switch the key off the moment you see calls you did not make.
Does Narwhal store the key?
Only a scrambled form of it. You see the full key once, when you create it. If you lose it, use Replace to get a new one.
Published .