Google Sheets Script Not Running? Here’s What To Do

Your Google Sheets Apps Script isn’t running, nothing happens when you execute it, triggers fail, or you get authorization/runtime errors.
This usually happens due to permission issues, incorrect function setup, trigger problems, or script errors.

Why the Issue Happens

• Script not authorized properly
• Function name mismatch
• Trigger not configured correctly
• Runtime errors in code
• Missing permissions/scopes
• Script attached to wrong spreadsheet
• Browser/session issues
• Exceeded Apps Script quotas

Step-by-Step Fixes

Step 1: Run the Script Manually First

Go to:

• Extensions → Apps Script

Select function and click Run

This helps identify:

• Authorization issues
• Syntax errors
• Runtime failures

Step 2: Authorize the Script

First-time scripts require permission approval.

Fix:

• Click Run
• Review permissions
• Select Google account
• Click Allow

Without authorization, scripts won’t execute.

Step 3: Check Function Name

Wrong:

function myscript() {

}

Trying to run:

myScript()

Correct:

• Function names are case-sensitive

function myScript() {

}

Step 4: Check for Syntax Errors

Common issues:

• Missing brackets
• Missing semicolons
• Invalid variables

Wrong:

function test() {
  Logger.log("Hello"
}

Correct:

function test() {
  Logger.log("Hello");
}

Step 5: View Execution Logs

Go to:

• Apps Script → Executions

Or use:

Logger.log("Test");

Then:

• View → Logs

Helps identify where script fails.

Step 6: Fix Trigger Issues

If automation isn’t running:

Go to:

• Apps Script → Triggers

Check:

• Correct function selected
• Correct event type
• Trigger enabled

Step 7: Verify Spreadsheet References

Wrong spreadsheet reference causes silent failure.

Example:

SpreadsheetApp.getActiveSpreadsheet()

may fail if script isn’t bound correctly.

Better:

SpreadsheetApp.openById("SPREADSHEET_ID")

Step 8: Handle Permissions Properly

Some methods require advanced scopes.

Example:

• GmailApp
• DriveApp
• UrlFetchApp

Fix:

• Re-authorize script after adding new services

Step 9: Avoid Quota Limits

Apps Script has limits:

• Email sending
• Execution time
• API calls

If exceeded:

• Wait for reset
• Optimize script

Step 10: Test with Simple Script

Use a minimal test:

function test() {
  SpreadsheetApp.getActiveSpreadsheet()
    .getSheetByName("Sheet1")
    .getRange("A1")
    .setValue("Working");
}

If this fails:

• Problem is setup/permissions, not logic.

Common Mistakes

• Forgetting authorization
• Running wrong function name
• Misconfigured triggers
• Ignoring execution logs
• Using wrong spreadsheet reference
• Exceeding Apps Script quotas

Pro Tips

Use Logger.log() extensively during debugging

Break large scripts into smaller functions

Use try...catch for error handling:

try {

} catch(error) {
  Logger.log(error);
}

Test scripts on small datasets first

Bottom Line

Fix script issues in this order:

1. Run script manually
2. Authorize permissions
3. Check syntax and function names
4. Verify triggers
5. Review execution logs
6. Test with simple script

Most Apps Script problems come from authorization or trigger configuration, not the code itself.

Other Google Sheets Fixes:

• VLOOKUP not working
• FILTER Function Issues
• Query Errors
• IMPORTRANGE Problems

More guides added daily