iPadOS 15环境下Google脚本无法运行及App Script项目无法打开问题求助

Hey there! Let's work through this issue with your Google Sheets scripts on your iPad Pro running iPadOS 15. I’ve dealt with similar mobile Google Workspace quirks before, so here’s how you can troubleshoot:

1. Ensure you’re using the official Google Sheets app (not a browser) #

• iPadOS 15’s mobile browsers have limited support for Google Apps Script—they often don’t expose the script editor or run scripts reliably. Make sure you’re using the official Google Sheets app from the App Store.
• If you’re already in the app, try force-closing it (swipe up from the bottom to open the app switcher, then swipe Sheets away) and reopening to refresh the connection.

2. Enable script access in the Sheets app #

• Open your sheet in the Google Sheets app, tap the three-dot menu (⋮) in the top-right corner.
• Scroll down to look for "Script editor"—if it’s missing, try these fixes:
  • Refresh your Google account sign-in: Go to iPad Settings > [Your Name] > Google, sign out and sign back in to reset permissions.
  • Update the Sheets app: Old versions on iPadOS 15 might lack script support. Head to the App Store, check for updates, and install any available for Google Sheets.

3. Work around to run scripts (if the editor is missing) #

• If you set up a custom menu for your script on your iMac, try accessing it in the iPad app (tap the three-dot menu > "Custom menus"—your script trigger should be there).
• Alternatively, add a script-trigger button on your iMac first: Insert > Drawing, draw a shape, right-click it > "Assign script", then name your script function. On the iPad, tap this button—it should run the script if permissions are correct.
• Note: Avoid desktop-only features in your scripts (like SpreadsheetApp.getUi() pop-up dialogs) since these won’t work on mobile. Replace them with mobile-friendly alternatives, e.g., SpreadsheetApp.toast() for notifications.

4. Check Google Account permissions #

• Go to your Google Account settings > Security > Third-party apps with account access. Make sure Google Apps Script is listed and has permission to access your Sheets.
• If you’re on a Google Workspace domain, ask your admin if mobile script access is restricted by organizational policies.

5. Try the browser-based script editor (limited functionality) #

• If the app still won’t show the script editor, open Safari on your iPad, go to sheets.google.com, sign in, and open your sheet. Tap the browser’s three-dot menu, then look for "Script editor". Keep in mind this version is limited—you might not be able to edit complex scripts, but you can view and trigger them.

内容的提问来源于stack exchange，提问作者SM_Amado