Packt

JavaScript

Google Sheets

Web Development

Google Docs

Google Apps Script

In this course, we will learn about the Google Apps Script to create custom functions within G Suite that will help you increase your productivity. This course contains 100+ coding examples. For this course, you need JavaScript and basic HTML and CSS knowledge, a Google account, and a basic web development understanding.

Google Apps Script on the New IDE: Complete Course with 100+ Examples

General Admission

<strong>Learn the power of Google Script and see how you can connect Google Spreadsheet as a data source for a post board</strong>
        <p>Group site project with Google Script - Google Site and Web apps - Spreadsheet
Do you want to connect Google Apps Together and make some really amazing things happen?  Course will provide you the foundation to work with Google Script to build a Web App that can be embedded in Google Sites. Within the course we show you how to use Google Spreadsheet as a source for retrieving and storing data.  Power up what you do online, bringing together built in functionality in your Google Suite. JavaScript developers extend your knowledge and learn how you can use your skills to develop apps script bringing together all the power of Google's Apps. 
Course Covers
- Basics of Google Script - how to use the online editor and overview of the functionality
- How to create a bound script to your Google Sheet
- Add new rows and get contents from Google Spreadsheet
- Sort and update Google Sheet data
- How to select sheet contents
- How to use HTTP service to output an HTML file within Google Web apps
- Use web apps to create interactive content
- Use JavaScript within Google Apps and Google client-side pages
- Setup a Google site and embed your Google script
- Use session values and other powerful built-in script methods
- Fine tune and tweak debug web apps
All this and more
Build a nice interactive project from scratch alongside the lessons within the course. Practice JavaScript and data handling, JSON, JavaScript objects, Array and more
Google Apps Script : is based on JavaScript 1.6 with some portions of 1.7 and 1.8 and provides subset of ECMAScript 5 API however instead of running on the client, it gets executed in the Google Cloud. According to Google, Apps Script "provides easy ways to automate tasks across Google products and third party services."Apps Script is also the tool that powers the add-ons for Google Docs, Sheets and Slides."
If you haven't tried it yet, I guarantee you will be BLOWN AWAY at how powerful Google Script can be, and at how easy it is to write.  With just a few lines of code, you can DO A WHOLE LOT!!! Don't take my word for it try it and see.
Taught by an instructor with over 20 years of web development experience, ready to help you learn. What are you waiting for this course is perfect to start writing Google Script and to practice writing Google Script, you have nothing to lose.
All the code and supporting files for this course are available at: https://github.com/PacktPublishing/Google-Apps-Script---A-Project-Based-Exercise-Using-Spreadsheets-and-Web-Apps</p>
        <h2>What You Will Learn</h2><p>?? Create web apps with Google Script<br>?? Build your own post application<br>?? Add Google Scripts apps to Google Sites<br>?? Update and use Spreadsheet data within Google Sites</p>
        <h2>Audience</h2><p>This course is for application developers, anyone who wants to learn about Google Apps Script or wants to create web apps with Google Apps Script and JavaScript developers who want to extend their knowledge.</p>
        <h2>Approach</h2><p>The course will provide you with the foundation to work with Google Script to build a Web App that can be embedded in Google Sites.</p>
        <h2>Key Features</h2><p>You only need JavaScript knowledge. * Perfect course to learn and practice Google Apps Script * Source Code is included so you can build the same app we build in the course, but even better.</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/google-apps-script---a-project-based-exercise-using-spreadsheets-and-web-apps</p>
        <h2>About the Author</h2><h3>Laurence Lars Svekis</h3><p>Laurence Svekis is an experienced web application developer. He has worked on multiple enterprise-level applications, hundreds of websites, business solutions, and many unique and innovative web applications. He has expertise in HTML, CSS, JavaScript, jQuery, Bootstrap, PHP, and MySQL and is also passionate about web technologies, web application development, programming, and online marketing with a strong focus on social media and SEO. He is always willing to help his students experience what technology has to offer and looks forward to sharing his knowledge and experiences with the world.</p>
        <h2>Course Outline</h2><h4>1. Introduction to Building Web Apps with Google Script</h4><p></p><br><h4>2. Bonus Section</h4><p></p>

Programming

Learn the power of Google Script and see how you can connect Google Spreadsheet as a data source for a post board

Google Apps Script - A Project-Based Exercise Using Spreadsheets and Web Apps

<strong>Explore all the amazing things you can do with Google Apps Script with just a few lines of code, such as supercharge your Google Workspace apps, save time, and more. Learn how Google Apps Script allows you to interact with the Google Suite of products and create customized functionality within those products. You need to have prior coding experience to get started on this course.</strong>
        <p>Google Apps Script is by far one of the best coding languages to get started with, as it allows you to access the power of all the Google services that simply work so incredibly well within the script. It is based on JavaScript, which makes it easy to get started.

You will start by learning how to write code in Google Apps Script and understand the features of Google Apps Script. You will learn to create projects and open the project to update and edit the code. Moving on, you will learn how to use the power of the Workspace services and create custom macros adding advanced functions to your spreadsheet with Google Apps Script. You will understand how to interact with Google Workspace services, see examples of using Classes in Workspace services, and learn how to access class methods.

Then we will explore some amazing applications that can be built with Google Apps Script. The projects of this course will demonstrate how to apply Google Apps Script code to create docs, create a web app with both GET and POST endpoints, make use of sheet data, get sheet data, send emails, and much more. We will wrap up the course by creating a web form that can send emails using your Gmail account.

By the end of the course, you will learn to interact with Google Workspace services and learn how to code Google Apps Script.

All resources and code files are placed here: https://github.com/PacktPublishing/Google-Apps-Script---Exercise-Coding-Projects</p>
        <h2>What You Will Learn</h2><p>Connect your code to a Google Workspace document<br>Learn to create customized functionality within Google Workspace<br>Learn to create projects and open the project to update and edit the code<br>Learn to bring your Google Workspace to the next level<br>Explore how to code Google Apps Script<br>Learn how to use spreadsheet data and update it with code</p>
        <h2>Audience</h2><p>This course is for Google Workspace users, web developers, and web designers. It can also be taken by application developers who want to learn Apps Script, Google Workspace users who want advanced and customized functionality, and JavaScript developers who want to learn Apps Script. This course is also useful to anyone who uses Google Workspace and wants custom functionality for Google Workspace users.<br><br>All you need is an internet connection and a Google Account, and you can start creating your coding apps.</p>
        <h2>Approach</h2><p>This course follows a learn-by-doing approach. Each lesson is designed to demonstrate a particular aspect of Google Apps Script coding, with practical exercises to challenge you. It is loaded with exercises and source code along with coding tips to learn Google Apps Script.</p>
        <h2>Key Features</h2><p>Learn to create bound applications that allow you to use the Google Workspace container and create customized interactions within it * Expand your Google Workspace knowledge with exercises and challenges * Learn to connect various Google Workspace services to create applications</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Google-Apps-Script---Exercise-Coding-Projects</p>
        <h2>About the Author</h2><h3>Laurence Lars Svekis</h3><p>Laurence Svekis is an experienced web application developer. He has worked on multiple enterprise-level applications, hundreds of websites, business solutions, and many unique and innovative web applications. He has expertise in HTML, CSS, JavaScript, jQuery, Bootstrap, PHP, and MySQL and is also passionate about web technologies, web application development, programming, and online marketing with a strong focus on social media and SEO. He is always willing to help his students experience what technology has to offer and looks forward to sharing his knowledge and experiences with the world.</p>
        <h2>Course Outline</h2><h4>1. Getting Started with an Introduction to Google Apps Script</h4><p></p><br><h4>2. How to do amazing things with Google Apps Script</h4><p></p><br><h4>3. Google Workspace Services - Docs, Calendar, Drive, Forms, Gmail, Sheets, Slides</h4><p></p><br><h4>4. Getting Started with Google Apps Script Projects</h4><p></p><br><h4>5. JavaScript and Google Apps Script Web App</h4><p></p><br><h4>6. DocumentApp Bound Script Coding Projects</h4><p></p><br><h4>7. Google Apps Script Fetch and API Connections</h4><p></p><br><h4>8. Google Apps Script Coding Examples and Helpful Code Snippets</h4><p></p>

Apps

Google Workspace

Explore all the amazing things you can do with Google Apps Script with just a few lines of code, such as supercharge your Google Workspace apps, save time, and more. Learn how Google Apps Script allows you to interact with the Google Suite of products and create customized functionality within those products. You need to have prior coding experience to get started on this course.

Google Apps Script - Exercise Coding Projects

<div><div><div><div><div><div><div><div><div><div><div><div><p>ð Unlock Your Productivity Potential with 'Maximizing Efficiency Through Google Applications' Online Course! ð</p><p> </p><p>Are you tired of drowning in a sea of unorganized emails, scattered documents, and missed deadlines? Do you wish there was a magic wand to transform your work life into a seamless, efficient, and highly productive experience?</p><p> </p><p>Look no further! Introducing our groundbreaking online course: 'Maximizing Efficiency Through Google Applications.' ðâ¨</p><p> </p><p>ð¥ What's Inside? ð¥</p><p> </p><p>ð <strong>Master the Power of Gmail:</strong> Say goodbye to email overwhelm! Learn advanced techniques to streamline your inbox, automate responses, and effortlessly manage your communication flow.</p><p> </p><p>ðï¸ <strong>Google Drive Mastery:</strong> Discover the art of collaborative document creation and storage. Unleash the full potential of Google Drive to keep your files organized, accessible, and secure.</p><p> </p><p>ð <strong>Calendar Control:</strong> Never miss a deadline again! Maximize your scheduling efficiency with Google Calendar hacks, enabling you to manage your time like a pro.</p><p> </p><p>ð <strong>Data Dominance with Google Sheets:</strong> Turn raw data into actionable insights! Dive deep into Google Sheets and unlock the secrets of data analysis and visualization.</p><p> </p><p>ð¤ <strong>Automation Awesomeness with Google Apps Script:</strong> Become a Google Apps Script wizard! Automate repetitive tasks and customize your Google Apps to work seamlessly for you.</p><p> </p><p>ð¯ <strong>Optimize Your Workflows:</strong> Discover how to integrate various Google Applications to create personalized, efficient workflows tailored to your specific needs.</p><p> </p><p>ð¼ <strong>Business Boost:</strong> Explore how Google Applications can supercharge your business operations, enhance collaboration, and drive success.</p><p> </p><p>ð <strong>Expert-Led Learning:</strong> Benefit from the expertise of industry professionals who have mastered the art of productivity through Google Applications. Learn from real-world examples and practical scenarios.</p><p> </p><p>ð <strong>Accessible Anytime, Anywhere:</strong> Our online course is designed to fit your busy schedule. Access the materials whenever and wherever it suits you, and progress at your own pace.</p><p> </p><p>ð <strong>Transform Your Professional Life:</strong> By the end of this course, you'll not only be a Google Applications pro but also a productivity powerhouse. Transform your professional life and achieve more than you ever thought possible!</p><p> </p><p>ð¨ Don't Miss Out! Enroll Now and Take Control of Your Productivity Destiny! ð¨</p><p> </p><p>Ready to revolutionize the way you work? Click the link below and embark on a journey to maximize efficiency through the unparalleled power of Google Applications!</p><p> </p><p>ð Join the ranks of successful professionals who have harnessed the full potential of Google Applications. Your optimized, efficient, and productive future starts now! ð</p></div></div></div><div><div><p> </p><div></div><div></div></div></div></div></div></div></div></div></div></div></div></div><div></div><div><div><div><h3>
Course Curriculum</h3><div><div><h4>
Basic</h4><div><div><ul><li><div>
<span></span><h5>
Overview</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Base Account Settings</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
G-Mail</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
G-Mail Productivity</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Tasks</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Desktop and Mobile Synchronization</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Sites</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Voice for Audio Contact and SMS</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Voice for Business Tracking</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Photos and Google Sites</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Photos</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Allo-Hangouts and Messenges</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Duo for Video Calling</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Chrome Remote Desktop</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Keep</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Drive</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Calendar for Collaboration</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Custom Search</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Export Google Docs To WordPress</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Conclusion</h5></div><div>
<span>
00:00													</span>
<span></span></div></li></ul></div></div></div><div><h4>
Advanced</h4><div><div><ul><li><div>
<span></span><h5>
Overview</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Create Text With Voice Typing</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Record Audio in Google Chrome</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Publish Audio On Google Podcasts</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Publish Books on Google Play</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Docs for Shared Word Processing</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Sheets for Shared Calcualtion</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Import and Export with Excel</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Slides for Shared Presentations</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Import and Export with PowerPoint</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Recording A Voice Over with Google Slides</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Presenting Live Using Google Slides</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Hangouts for Real Time Video</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Create Branded Video Content With YouTube</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Create Branded Video Content For YouTube</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Publishing Indexed (Google) Documents</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Google Research Tools</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Citation of Sources</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Using Blogger</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Conclusion</h5></div><div>
<span>
00:00													</span>
<span></span></div></li></ul></div></div></div></div></div></div></div>

Compete High

Maximizing Efficiency Through Google Applications

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is designed for business users, educators, students, and knowledge workers in a variety of roles and fields who want to be able to use the apps included in Google Workspace to create and manage various types of files and communicate and collaborate with colleagues.</p>Overview<p>In this course, you will use the various apps included in Google Workspace to work productively as part of a team. You will:<br />Navigate the Google Workspace environment and use Gmail to send and manage email correspondence.<br />Manage schedules using Google Calendarâ¢.<br />Communicate with colleagues over text, voice, and video using Google Chat and Google Meet.<br />Store and share files using Google Drive.<br />Collaborate on documents using Google Docs, Google Slidesâ¢, and Google Keepâ¢.<br />Collaborate on data using Google Sheets and Google Formsâ¢.<br />Collaborate on websites using Google Sitesâ¢.</p><p>The core productivity apps that make up the Google Workspace? suite enable users to work together on a variety of projects and tasks across many different industries and job roles. This course will teach you how to work efficiently and effectively in apps like Gmail?, Google Drive?, Google Docs?, Google Sheets?, Google Meet?, Google Chat?, and more?all while participating in a collaborative team environment.</p></div><div id="course-pills-2"><h4>Lesson 1:Getting Started with Google Workspace</h4><ul><li>Topic A: Navigate Google Workspace</li><li>Topic B: Send and Manage Email Using Gmail</li></ul><h4>Lesson 2:Managing Schedules Using Google Calendar</h4><ul><li>Topic A: Create and Manage Events</li><li>Topic B: Customize Calendars</li><li>Topic C: Create and Share Calendars</li><li>Topic D: Create and Manage Tasks</li></ul><h4>Lesson 3:Communicating Using Google Chat and Google Meet</h4><ul><li>Topic A: Chat Using Google Chat</li><li>Topic B: Participate in Meetings Using Google Meet</li></ul><h4>Lesson 4:Storing and Sharing Files Using Google Drive</h4><ul><li>Topic A: Add Files and Folders</li><li>Topic B: Manage Files and Folders</li></ul><h4>Lesson 5:Collaborating on Documents Using Docs, Slides, and Keep</h4><ul><li>Topic A: Create and Edit Documents Using Google Docs</li><li>Topic B: Design Presentations Using Google Slides</li><li>Topic C: Take Notes Using Google Keep</li></ul><h4>Lesson 6:Collaborating on Data Using Sheets and Forms</h4><ul><li>Topic A: Create and Manage Spreadsheets Using Google Sheets</li><li>Topic B: Design Surveys Using Google Forms</li></ul><h4>Lesson 7:Collaborating on Websites Using Sites</h4><ul><li>Topic A: Create and Edit Sites</li><li>Topic B: Share and Publish Sites</li></ul></div>

Google Apps Script courses in Glasgow

Online Options

Google Apps Script on the New IDE: Complete Course with 100+ Examples

By Packt

Google Apps Script - A Project-Based Exercise Using Spreadsheets and Web Apps

By Packt

Google Apps Script - Exercise Coding Projects

By Packt

Maximizing Efficiency Through Google Applications

By Compete High

Using Google Workspace v1.0

By Nexus Human

Search By Location