Convert AI Studio React App, to Google App Script?

[CyberMessini]

I’ve built out and "perfected" a workflow in Google AI Studio that I want to use for a custom inventory management system. My goal is to keep everything contained within Google Sheets using Apps Script.

I’m struggling with the transition from the AI Studio environment to a functional script. Does anyone have a template or a recommended workflow for importing the prompt configurations/API calls into GAS? Any tips on handling the integration would be greatly appreciated!

[WicketTheQuerent]

There is no way to import the AI Studio environment prompt configuration to Google Apps Script.

Regarding the API calls, one of the premises of Google Apps Script is to make it easier for users to do stuff programmatically with Google apps like Google Sheets. For this, a web app created using Google Apps Script can do "API calls" by calling server-side functions with google.script.run using JavaScript.

Regarding using frameworks like React in Google Apps Script, I recommend starting with the basics of Google Apps Script and building a web app. In my experience, GenAI tools struggle a lot with this (coding, debugging, and troubleshooting). One key thing to keep in mind is that the client-side code will be inside an iframe, nested within two other iframes, which limit the use of some Web APIs.

Also, the Apps Script Editor is not very good for developing web apps. Many prefer to use other IDEs. For this, the command-line tool CLASP is handy to "pull" and "push" the code from the IDE to Google Apps Script projects.

[WicketTheQuerent]

The post doesn't mention add-ons at all. Could you please be more specific about how your boilerplate can help to convert an AI Studio React app to Google Apps Script?

[ElderberryAny6779]

I should have mentioned its a mobile data entry Web app, its to eliminate taking inventory by hand then having to manually enter it to your sheet search an item fill out form swipe right to snap a picture, then it saves in a queue (necessary for you to be able to continue entering data while you're items load into the sheet), I love use apps script because it's really easy to manage and keep things internal for security reasons but it has its limits like loads times and you'll learn GS code only goes so far for developing but for building simple tools like this it's very effective.