FAQ & Troubleshooting

📌 Resolving the "Organization Administrator" Access Error

Why is this happening?

This error is triggered by Google Workspace's security policies, not by the Zeto Sheet Automation add-on itself. It happens for one of two reasons:

• Corporate Security Policies: Your company or school's Google Workspace Administrator has restricted third-party applications from running by default.
• Multiple Logged-in Accounts (Google Bug): You are logged into multiple Google accounts (like a personal @gmail.com and a work account) in the same browser, causing Google to mix up your permissions.

✅ Solution 1: If you are using a Work or School Account (Google Workspace)

By default, many organizations block third-party add-ons. Even if you install the add-on, Google prevents it from running inside your sheet. You will need to ask your IT/Google Workspace Administrator to "Trust" the add-on.

Share these steps with your IT Administrator:

1. Go to the Google Admin console (admin.google.com).
2. Navigate to Security > Access and data control > API Controls.
3. Under App access control, click Manage Third-Party App Access.
4. Click Configure new app > OAuth App Name or Client ID.
5. Search for Zeto Sheet Automation.
6. Select the add-on and change its access level to Trusted: Can access all Google Workspace services.

✅ Solution 2: If you are logged into multiple Google Accounts

Google Apps Script has a known bug where it gets confused if you have multiple Google accounts logged into the same browser. It might try to run the add-on using your personal email instead of your work email.

Steps to fix this:

• Option A (Recommended): Use a dedicated Google Chrome Profile for the specific account you are trying to use.
• Option B: Open your Google Sheet in an Incognito / Private browsing window, log in with only the correct account, and open the add-on.
• Option C: Log out of all Google accounts in your browser, and log back in using only the account that needs to use the add-on.

📌 Resolving the "Too many scripts running simultaneously" Error

Why is this happening?

Google Workspace limits the number of automations that can run at the exact same time to 30. If too many changes happen in your spreadsheet in a fraction of a second, Google's servers temporarily block new automations from starting to prevent crashes.

Common Causes & Solutions:

• Rapid Deletions or Edits: Deleting or editing 50 rows one-by-one very rapidly.
  Solution: Select all the rows you want to delete/edit and do it in one single action. Google processes a single bulk update safely as 1 automation, whereas 50 individual deletes count as 50 automations.
• Third-Party Integrations (Zapier, Make, etc.): If you use an external tool to push data to your Google Sheet, it might be firing row updates too quickly.
  Solution: If your tool supports it, use "Bulk Add Rows" modules instead of single "Add Row" modules, or add a small 1-second delay between row creations.
• Drag-Down Formulas: If you drag a formula down hundreds of rows and the formula triggers a sheet update, it can overload the limits.

📌 Why do I see an "Authorization Required" error?

Why is this happening?

This is a known issue called the "Multi-Account Login Bug" in Google Workspace. It happens when you are signed into multiple Google Accounts (e.g., a personal Gmail and a work G-Suite account) in the same browser session. Google sometimes loses track of which account has granted permission to the Add-on.

How to Fix:

• Incognito Mode (Fastest): Open your spreadsheet in an Incognito or Private browser window. This forces Google to focus on a single account session.
• Browser Profiles (Recommended): Use Google Chrome "Profiles" to keep your work and personal accounts completely separate. This prevents the bug from happening entirely.
• Sign Out: Sign out of all Google accounts in your current browser, then sign back into only the account you are using for the spreadsheet.