Great video, Adam Thanks so much! Looking forward to the upcoming tutorials, especially the genAI integrations!

@analyticswithadam

2 ай бұрын

Thanks Troy. Already made a video on the topic if your interested Google Sheets with Gemini API: Create AI-Powered Functions Using App Script! kzread.info/dash/bejne/qoOBytx7g7m2e5c.html .. Going to go a lot more indepth in the future

how does the script reconnect the google form with the spreadsheet on the original sheet

@analyticswithadam

11 күн бұрын

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

Do you know how to write the script to make a save/enter button, if so can I pay you to write me one

@analyticswithadam

23 күн бұрын

In the ribbon or on the page?

hello When there is no module to integrate an API, do you have to use appscript?

@analyticswithadam

7 күн бұрын

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

@chrisder1814

7 күн бұрын

@analyticswithadam I don't know anything about code, all I can do is copy and paste I watched a tutorial in which the KZreadr 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.

@analyticswithadam

5 күн бұрын

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.

@analyticswithadam

5 күн бұрын

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

5 күн бұрын

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

@vivekjoshi3769

5 күн бұрын

@@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.

@vivekjoshi3769

5 күн бұрын

*html and css stuff.