Web application development attendance management

kosipoy770

GIG holds study sessions on various themes every month, and they are currently being held online to prevent the spread of coronavirus infection. This time, Mr. Niida, an engineer from the `` LeadGrid '' division, spoke on the theme of ``GAS.'' Below you will find detailed information. ■Speaker profile Hikaru Niida engineer. During his university years, he was involved in machine learning research for image recognition and work as a network engineer at an ISP company. After graduating, he engaged in system development as a systems engineer. His interest in web services increased and he joined GIG in March 2019. What is GAS (Google App Script)? Niida: First, let's start with basic knowledge of GAS. GAS is an abbreviation for "Google App Script" and is a programming language provided by Google. You can automate and improve work efficiency by linking Google apps such as Gmail, Sheets, and Google Drive.

GAS does not require any development environment such as tools, and can be easily started as long as you have an internet environment. You can create and run scripts on your browser. In addition, you can set execution triggers such as ``regular execution Phone Number List time'' and ``inquiry from form'' on GAS without starting the PC, and it will be executed automatically when the time comes. I'm also happy that it's basically free to use. In what areas can GAS improve work efficiency? Niida: Now, let's get to the main topic. GAS can be combined with various services to improve operational efficiency. for example…… Automate routine tasks Aggregate daily sales from sales management spreadsheets and report to boss via email An email will be sent early in the morning to prevent omissions in reminder tasks. Web Scraping Obtain Amazon's best-selling products once a week and store them in a spreadsheet.




tool Just hearing this, don't you think it's pretty useful? But of course, GAS is not omnipotent, so there are some things it cannot do. for example, Processes that take a long time to execute The maximum execution time is 30 minutes, and the free version is 6 minutes. Processing using large files There are limits such as 50MB for Google Drive and 1.5MB for Google Documents. Processes that operate the browser It is not possible to launch the browser at 9 a.m. and search for the weather forecast on Google. It's a really useful tool if you understand it and use it! We also demonstrated how to improve work efficiency using GAS at the study session, but we can't show it on the blog, so please give us a shout when you come to GIG! GIG is looking for people who can build a good is good team! GIG is currently looking for motivated colleagues who want to grow while learning together! If you would like to hear more details, please click here !