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!

[PauloExpert]

You're not alone — what you're experiencing is a known limitation of AppSheet’s “Call a script” task: it can only detect Google Apps Script projects that are bound to the same Google Sheet (container-bound scripts), not standalone Apps Script projects.

🔍 Why Your Script Isn’t Showing

Even though your script is saved and accessible at script.google.com, AppSheet only lists bound scripts — those directly attached to a Google Sheet that's already linked as a data source in your AppSheet app.

If your script was created:

As a standalone Apps Script project (not bound to a Sheet)

Or in a different context (like from the Apps Script dashboard directly)

…it won’t appear in the “Apps Script Project” dropdown.

✅ Solutions and Workarounds

✅ Option 1: Attach Your Script to a Google Sheet Bound to Your App

1. Open the Google Sheet that's already connected to your AppSheet app.

2. Click Extensions > Apps Script.

3. Paste your .gs code here (or import it).

4. Save it.

Now go back to AppSheet > Automation > Tasks > "Call a script". Your bound script should now appear in the picker.

Bonus: AppSheet will auto-link that script and let you choose your custom function by name.

✅ Option 2: Use a Webhook Instead (Call an Apps Script Web App)

If you want to keep the script standalone:

1. In Apps Script:

Convert your script into a web app.

Use doPost(e) to accept POST requests and call your createStripeLink() function.

Deploy the web app (Deploy > Manage deployments > Web app).

2. In AppSheet:

Create a webhook task using a POST method.

Use JSON body to pass data to your Apps Script Web App endpoint.

✅ Works cleanly, and you can log, debug, and authorize more flexibly.

🧪 Pro Tip: Add Logging to Script for Debugging

If you're having issues even after binding, use Logger.log() or console.log() in your Apps Script to check what AppSheet sends when your automation runs. This makes debugging much easier.

Summary

Goal Best Approach

Native “Call a script” integration Use a bound script in a connected Google Sheet

Custom or standalone script logic Deploy as web app, call via webhook from AppSheet

[scott192]

All of this is nonsense.  It is literally the opposite of what you are stating here.

Appsheet does NOT show or use container bound scripts.  That is scripts that are added to a spreadsheet or a doc/form/slide.

Appsheet only uses standalone scripts.  You can invoke a new standalone script by typing script.new into the url bar of your browser or you can go to script.google.com in the url bar of your browser or you can open a google drive folder, position your mouse in the blank space of the folder and right click-->more-->Google Apps Script  or you can open your google drive and click the + button in the top left hand corner -->more--> Google App Script.

All of the above will get you to a point where you can start creating your functions.

[TeeSee1]

First of all, AppSheet can call only standalone script files

Assuming you have the first condition cleared, how are you searching your Apps Script project?

Here is a partial list of my projects.

As you can see, I have now issues searching for stand alone projects

but not container bound ones.

[Racine]

Hi both,

Thanks for the responses.

Indeed, I should perhaps try the standalone option. I have all created and bound to a googlesheet currently (Extensions>App Script) but can't find it. 

Let me try it and let you know.