Google Sheets triggers stop working when Apps Script permissions fail, trigger settings are incorrect, or the script exceeds execution limits.
This usually shows up as automations not running, emails not sending, or scripts only working manually.
Why are Google Sheets triggers not working?
Common causes:
- Trigger was deleted accidentally
- Script authorization expired
- Wrong trigger event selected
- Function name changed after creating trigger
- Script errors stopping execution
- Apps Script quotas exceeded
- Spreadsheet permissions changed
- Trigger attached to wrong project
How do I check if a trigger is active?
Go to:
- Extensions → Apps Script
- Click the clock icon (Triggers)
Check:
- Trigger exists
- Correct function selected
- Correct event type selected
- Trigger is enabled
If no trigger exists, create a new one.
How do I fix Google Sheets triggers not firing?
Fix 1: Recreate the Trigger
Delete the old trigger and create a new one.
Steps:
- Apps Script → Triggers
- Delete broken trigger
- Add Trigger
Select:
- Function name
- Deployment: Head
- Event source
- Event type
This fixes many silent failures.
Why does the trigger work manually but not automatically?
Usually because permissions are missing.
Run the function manually once:
function test() {
Logger.log("Working");
}
Google will ask for authorization.
Approve all required permissions.
How do I fix authorization errors?
Reauthorize the script.
Steps:
- Open Apps Script
- Run function manually
- Click Review Permissions
- Allow access
This is required after:
- Editing scopes
- Adding Gmail/Drive services
- Changing account permissions
Why is my onEdit trigger not working?
onEdit(e) only works for manual edits inside the spreadsheet.
It does NOT trigger from:
- Formulas changing values
- IMPORTRANGE updates
- Script-based edits
- API updates
Correct example:
function onEdit(e) {
Logger.log("Cell edited");
}
Why is my time-driven trigger failing?
Possible causes:
- Apps Script quota exceeded
- Trigger frequency too high
- Script execution too long
Fix:
- Reduce frequency
- Optimize loops
- Use batch operations
How do I check trigger errors?
Go to:
- Apps Script → Executions
Review:
- Error message
- Failed function
- Runtime duration
This is the fastest debugging method.
Why did my trigger stop working suddenly?
Usually because of:
- Expired authorization
- Spreadsheet ownership change
- Renamed function
- Deleted trigger
- Google quota limits
Recreate and reauthorize the trigger.
How do I fix exceeded Apps Script quotas?
Google Apps Script has limits on:
- Emails sent
- Execution time
- API calls
- Trigger executions
Optimize scripts:
Bad:
range.setValue(value);
inside loops.
Better:
range.setValues(data);
Batch operations are much faster.
How do I fix trigger permissions after changing accounts?
Triggers are user-specific.
If the owner changes:
- Old triggers may fail
Fix:
- Recreate triggers under the active account
Why is my installable trigger not running?
Installable triggers require:
- Authorization
- Correct deployment
- Proper permissions
Create properly:
- Add Trigger
- Choose event source
- Save
- Authorize
Best practices for stable Google Sheets triggers
- Keep scripts modular
- Use batch writes
- Avoid infinite loops
- Log errors using
Logger.log() - Use helper functions
- Keep trigger frequency reasonable
Better alternatives for heavy automations
For large workflows:
- Use Google Cloud Functions
- Use Apps Script Web Apps
- Use Make/Zapier for integrations
Apps Script triggers are best for lightweight automations.
FAQs
Why is my Google Sheets trigger not running automatically?
Usually because the trigger is deleted, unauthorized, or configured incorrectly.
Why does my Apps Script work manually but not on trigger?
Manual execution uses your active session, while triggers require separate authorization and permissions.
How do I reset a broken Google Sheets trigger?
Delete the trigger, recreate it, then reauthorize the script.
Why is onEdit not firing?
onEdit() only works on manual edits made by users inside the sheet.
How do I debug Apps Script trigger errors?
Go to Apps Script → Executions and review failed runs and error logs.
What is the most common trigger issue?
Expired permissions and incorrect trigger configuration.
Other Google Sheets Fixes:
More guides added daily