Support

If you need assistance, want to report an issue, or would like to request a new feature for SheetOps, please contact us.

---

Get Direct Technical Support for SheetOps

You can drop an email directly to Vignesh:

[email protected]

Please include "SheetOps - Support" in the subject line, along with a description of the issue and screenshots if applicable.

---

Troubleshooting Common SheetOps Issues

1. Resolving Permission Denied Errors on Apply

• Symptom: You check Apply Changes but receive a dialog saying access is denied, or the checkboxes automatically untick themselves.
• Reason: For security, SheetOps ties sheet operations to the specific administrator account that completed onboarding (stored in the document property triggerUser). If another user tries to apply changes, it is blocked.
• Solution: Ensure you are logged into Google Sheets with the exact Google Workspace administrator account that initialized the sheet. Alternatively, clear the document properties or reinstall the trigger with the active user.

---

2. Upgrading After Hitting the 20 Writes Limit

• Symptom: You receive a dialog prompting you to upgrade to a premium plan after executing updates, and cells remain yellow.
• Reason: Free accounts are capped at 20 write operations (insert, update, delete combined).
• Solution: Click the link in the upgrade prompt to purchase a premium license. Once upgraded, your quota restrictions will be automatically removed.

---

3. Recreating the Missing Auxiliary Reference Sheet

• Symptom: You receive a warning that the auxiliary sheet _aux_{entity} is missing.
• Reason: SheetOps uses hidden sheets prefixed with _aux_ to compare current cell values with the baseline values in Google Workspace (to detect changes and highlight them yellow). If a user manually deletes these hidden sheets, change tracking breaks.
• Solution: The script will automatically attempt to recreate the auxiliary sheet by fetching fresh data. If it fails, simply reload the active entity by going to the main menu and re-running the fetch (e.g., Extensions → SheetOps → Users → Fetch All).

---

4. Resolving Directory API Authorization Failures

• Symptom: A custom styled permission checklist dialog pops up when trying to export or modify groups/OUs.
• Reason: You may not have administrative privileges over that resource, or the API Advanced Service is blocked by your organization's Google Workspace settings.
• Solution: Verify that your account is a Super Admin or has a Custom Admin Role with "Admin API privileges" enabled. Ensure third-party API access isn't blocked in the Google Admin Console under Security → API Controls.

---

Frequently Asked Questions (FAQ)

How long does it take for support to respond?

We typically respond to support inquiries within 24 hours on business days. Please provide your Google Workspace domain name and spreadsheet URL if applicable, which helps us troubleshoot faster.

Where can I check my current write quota usage?

Your quota usage is tracked in the user properties of the spreadsheet. If you want to check your status, run any write operation, and if you are close to the limit, a notification toast will display your current write count.

Why does SheetOps require my Google Sheets to be in English?

SheetOps parses spreadsheet formulas, headers, and sheet names. To prevent translation mismatches (e.g. Google Sheets localizing sheet names), we recommend setting your spreadsheet settings to English in File → Settings → Locale.

---