How add a script?

[misha_057]

Trying to create a bot with my Apps script. I see the name of sheet from file, but why I can't see my script?

[Markus_Malessa · Accepted solution]

Did you click this button?

Also if you created the script in Google Sheets then you need to move it to a free standing script file.

[misha_057]

If I make free standing script file, how i can use it it my Sheet?

[Markus_Malessa]

First understand that you may need to rewrite the script to interact with the records in Appsheet vs currently it appears your script interacts directly with the spreadsheet. Typically that means what you want to do is put variables inside function add_Roll(infopassedfromappsheet) then process the info inside the script. I would suggest looking at the documentation here https://support.google.com/appsheet/answer/11997142?hl=en

Most importantly we don't know what your script does so it is hard to provide very detailed help. But to add a script in a process you need to click on that button I highlighted which will direct you to your Google Drive and from there you need to find your script file for starters.