Google Apps Script for Beginners: Start Automating Google Sheets
Вставка
- Опубліковано 26 лип 2024
- Master Google Apps Script, a powerful Javascript-based coding platform within Google Workspace. This tutorial is perfect for beginners looking to automate tasks in Google Sheets. Discover how to write your first function and explore three effective ways to trigger it:
Creating a custom menu in Google Apps Script.
Designing a button in Google Apps Script.
Setting up a timed trigger with Google Apps Script.
Access the complete code used in this video here: github.com/analyticswithadam/...
Don't forget to like, subscribe, and click the bell icon for more tutorials on Google Apps Script and other automation tools! - Навчання та стиль
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!
ua-cam.com/video/xOMhzBSVPK4/v-deo.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
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
In the ribbon or on the page?
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 UA-camr 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.