Thanks Troy. Already made a video on the topic if your interested Google Sheets with Gemini API: Create AI-Powered Functions Using App Script! ruclips.net/video/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
@analyticswithadam I don't know anything about code, all I can do is copy and paste I watched a tutorial in which the RUclipsr 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?
Hi Adam! How much JavaScript knowlege is required for this? I came across this while going though a job description & I am thinking to learnt this tool. I only know python & R language.
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
@@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.
Great video, Adam Thanks so much! Looking forward to the upcoming tutorials, especially the genAI integrations!
Thanks Troy. Already made a video on the topic if your interested Google Sheets with Gemini API: Create AI-Powered Functions Using App Script!
ruclips.net/video/xOMhzBSVPK4/видео.html .. Going to go a lot more indepth in the future
Do you know how to write the script to make a save/enter button, if so can I pay you to write me one
In the ribbon or on the page?
how does the script reconnect the google form with the spreadsheet on the original sheet
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
hello When there is no module to integrate an API, do you have to use appscript?
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 RUclipsr 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?
Hi Adam!
How much JavaScript knowlege is required for this?
I came across this while going though a job description & I am thinking to learnt this tool. I only know python & R language.
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.