Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
GROW YOUR SKILLS Quiz: Web Design Fundamentals Quiz: Advanced Web Design Challenge Question 1: HTML5 Semantics Which tag is used to define an independent, self-contained content? Question 2: CSS3 Properties Which CSS property is used to create rounded corners? Question 3: JavaScript ES6 What does the const keyword represent? Question 4: Responsive Design Which unit … Read more
Web Designers Quiz: Test Your Knowledge! Web Designers Quiz: Test Your Knowledge! Question 1: HTML Document Structure What element defines the document’s body? Question 2: CSS Styling Which property is used to set the background color of an element? Question 3: JavaScript Syntax How do you create a function in JavaScript? Question 4: Responsive Design … Read more
GROW YOUR SKILLS Quiz: Web Design Fundamentals Quiz: Web Design Mastery Question 1: Semantic HTML Which element is used for the main navigation block in HTML5? Question 2: CSS Flexbox Which CSS property defines the direction of items in a flex container? Question 3: JavaScript Variables Which keyword is used to declare a block-scoped variable … Read more
FrontEnd Web Developer QUIZ Test Your Knowledge GROW YOUR SKILLS Quiz: Web Design Fundamentals Question 1: HTML Basics What does HTML stand for? Question 2: HTML Elements Which of the following HTML elements is used for making any text bold? Question 3: CSS Basics What does CSS stand for? Question 4: CSS Selectors Which CSS … Read more
Write a simple script to log a custom message in the Google Apps Script log Instructions: Explanation: This script defines a function logMessage that creates a variable message containing a string. It then uses Logger.log() to print this message to the Google Apps Script log. function logMessage() { const myName = ‘Laurence’; const message = … Read more
Append a row of data to the end of the current sheet Instructions: Explanation: This script appends a new row to the bottom of the active sheet with the data provided in the rowData array. function appendMyRow(){ const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘Sheet1’); const rowData = [‘New’,’Laurence’,’Svekis’]; sheet.appendRow(rowData); //Logger.log(sheet.getName()); } Google Apps Script code snippet appends a … Read more
Objective: Use Google Apps Script to send an email to a specific recipient. Instructions: Explanation: This script uses the MailApp.sendEmail() method to send an email. It requires the recipient’s email address, the subject of the email, and the body of the email as parameters. Code: function sendMyEmail(){ const recipient = “email@gmail.com”; const subject = ‘Test … Read more
Programmatically create a new Google Doc and insert text into it Instructions: Explanation: This script creates a new Google Doc titled “New Google Doc” and then inserts a paragraph of text into the document. Code: function createGoogleDoc(){ const paraContents = ‘My Name is Laurence Svekis’; const doc = DocumentApp.create(‘New Google Doc’); const body = doc.getBody(); … Read more
Objective: Read and log data from the first cell in a Google Sheets spreadsheet. Code: function readSpreadsheetData() { const ss = SpreadsheetApp.getActiveSpreadsheet() const sheet = ss.getSheetByName(‘Sheet1’); const range = sheet.getRange(‘A1’); const value = range.getValue(); Logger.log(value); } Instructions: Explanation: This script gets the active sheet of the current spreadsheet, accesses cell A1, reads its value, and … Read more
Check out our comprehensive guide on “Getting Started with Google Apps Script If you’re looking to level up your Google Apps Script skills, this guide is a must-read. It covers 50 Exercises and 55 Quiz Questions to help you become a scripting pro. 🤓 🔥 Here are some key objectives covered in the guide: #GoogleAppsScript … Read more