New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Errors›Apps script authorization required

Google Sheets · Verified tutorial

Apps script authorization required in Google Sheets

The custom Apps Script function in G2 is blocked by authorization. Replace it with the native formula exactly =SUM(B2:B4).

Verified by JosephineJuly 25, 2026About 75 seconds

Quick answer

The custom Apps Script function in G2 is blocked by authorization. Replace it with the native formula exactly =SUM(B2:B4).

Step-by-step

1

Select the targetThe custom Apps Script function in G2 is blocked by authorization.

2

Apply the changeReplace it with the native formula exactly =SUM(B2:B4).

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

G2 uses the native fallback formula and displays 500.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select G2 and repeat the final action. G2 uses the native fallback formula and displays 500.

Example spreadsheet data

This is the clean fixture used for the verified run.

Item	Amount
Hosting	80
Software	120
Design	300

Video transcript

Open the prepared Authorization fallback spreadsheet.
Select the target. The custom Apps Script function in G2 is blocked by authorization.
Apply the change. Replace it with the native formula exactly =SUM(B2:B4).
G2 uses the native fallback formula and displays 500.