Google Apps Script for Beginners: Start Automating Google Sheets 

Thanks Troy. Already made a video on the topic if your interested Google Sheets with Gemini API: Create AI-Powered Functions Using App Script! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xOMhzBSVPK4.html .. Going to go a lot more indepth in the future

Two possible ways - this is a bound script which means it’s attached to the sheet. For an unbound script or a bound script attaching to another sheet you just capture the sheets id and connect to it that way

In the ribbon or on the page?

It’s a good option to do curl commands and it can handle outputs. What are you looking to plug in?

@analyticswithadam I don't know anything about code, all I can do is copy and paste I watched a tutorial in which the RU-vidr explained how to copy and paste the openAI API into a Google sheet module in order to use chatgpt in Google sheet and so I ask you how can I use another API when there is no module available?

​@@analyticswithadam​ I'm asking you this question because I don't know anything about coding and I'm starting to use make software And I'm wondering about other automation software, what other software do you use? Do you also create Chrome or WordPress extensions? Do you also use custom gpt?

@@chrisder1814 Hi Chris, I use Power Automate which is a microsoft tool but people in my company use UI Path for automation. It depends on the tech stack they are all similar. I do not create extensions, just focused on data analytics for finance so use whatever helps me there

Hi Vivek , A little bit of JS to customise but its mostly internal api functions with the Google workspace apis. I’ve been getting help off Claude and chat gpt with the coding… there is a good course on Udemy too that’s fairly cheap.

If you have a good handle on basic programming syntax it’s not a heavy lift. I’m building some super useful things at my company and am not an expert at JS

Another great way to learn is to record a macro then look at the code it’s created

@@analyticswithadam Recording with macro & seeing the code seems a cool idea. One more..unrelated question as you seem to be working in tech. Sorry to bother 😅 Actually learning JavaScript was on my mind but I couldn't decide it. I am not from Engineering background. I am trying to make a career change from non-tech field. I learned data analytics tools and techniques, build projects also but the market is bad right now for career transitioners. I am thinking to reconsider my goals and learn web development but that requires a lot of time. I got some career gap as I am not working. Would learning Front End to start working in tech be a good decision at this point? I know some basic html and costs stuff. I have a JS course on Udemy. My only problem is my huge career gap which may impact when applying. Pretty entangled and don't have friends in tech who could help. So, thought to ask you.

*html and css stuff.