AppSheet Call a script task stuck on Loading Apps Script Project information

Hi everyone,

I’m trying to inspect an existing AppSheet automation using a Call a script task.

The bot is enabled and its event and table configuration are visible. However, when I open the task settings:

  • The Apps Script project selector remains on “Loading Apps Script Project information…”

  • The script function and parameter mappings never appear.

  • The task input panel displays “Data could not be loaded” or “Data fetching failed”.

  • The editor otherwise shows “No issues found”.

The task was previously configured with an Apps Script function and an expression mapping a request ID.

I need to verify the currently saved function and parameter mapping, without accidentally changing or executing the automation.

Has anyone encountered this issue?

Is there a reliable, read-only way to inspect the persisted Call a script task configuration when the editor cannot load the project information?

I’d appreciate any suggestions that do not require restoring an earlier app version, saving configuration changes or running the automation.

Thanks!

Hi @Mistdana, there is a read-only way to see the saved function and parameters, even while the picker is stuck. I tested it this week on a test app.

Why the picker and the saved settings are separate

When the editor opens a Call a script task it makes two separate requests:

  • loadApp loads the app definition, which includes what the task has saved.
  • getAppsScriptProjectInfo/<script id> asks for the project’s name and function list to fill the picker.

The second one is what’s stuck for you. The saved function and mappings come from the first one, so they’re still there.

How to read them (read-only, nothing is saved or run)

  1. Open the app in the editor, open Chrome DevTools (F12 or Cmd+Option+I) and go to the Network tab.
  2. Reload the page.
  3. In the Network filter box type loadApp, click the request and open Response (or Preview).
  4. Search the response for AppWorkflowActionAppsScript (it may show with extra backslashes, that’s normal). Each Call a script task shows up like this:
"ScriptId":"1AbC...your script id...",
"FunctionName":"testTask",
"FunctionArguments":[{"Name":"jobId","Expression":"=[ID]"},
                     {"Name":"note","Expression":"=\"saved mapping test\""}]

That’s the saved function and every parameter mapping. Close the editor without pressing Save and nothing changes.

Finding out why it’s stuck

In the same Network tab, filter for getAppsScriptProjectInfo and look at its response. A working project returns "success": true with the project name and functions. When I asked for a project ID that doesn’t exist it returned "success": false with a fairly generic error (INVALID_ARGUMENT). Yours may be just as vague, but it confirms the picker request is the part failing.

You can also put the ScriptId into https://script.google.com/d/SCRIPT_ID/edit to check the project still exists and that the app owner’s account can open it. AppSheet runs the script as the app owner, so a project that was deleted, moved to someone else’s Drive or not shared with that account is the first thing I’d check. If the bot has run before, the project’s Executions page should also show which function ran and when, though I didn’t test that part.

Two things I didn’t check: what the error message says for a project that exists but isn’t shared with you, and the App Documentation page, which lists the bot and step but not the function or the mappings.