Challenge with "Call a script" feature in AppSheet – Script picker doesn't find any file

[Racine]

Hi everyone,

I'm currently building an app in AppSheet and wanted to use the "Call a script" automation task to run a custom Google Apps Script function — specifically for generating Stripe payment links based on a table.

I followed all steps:

• Created a script project in script.google.com

• Added and saved my .gs

• Made sure I'm using the same Google account connected to AppSheet

• Tried refreshing AppSheet and re-authenticating

However, when I try to select the script under the "Apps Script Project" picker, it shows no available projects — even though my script is clearly saved and visible in my Google account.

I’ve also tried:

• Using .gs and .txt files

• Storing the project in My Drive

• Renaming the script and adding comments/function headers

Still nothing shows up in the Appsheet script picker. Webhook-based integrations could work fine, but I’d really prefer the native Apps Script call for cleaner automation.

Has anyone successfully used "Call a script" with a custom script that wasn't created inside an AppSheet-attached Google Sheet?

Any workaround or requirement I may be missing?

Thanks in advance!