Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Apps Script Coding Examples Google Apps Script is a scripting platform that lets you extend Google Workspace by adding custom functionality to your Google Sheets, Docs, Forms, and Gmail. Google Apps Script is a cloud-based scripting language that provides easy ways to automate tasks across Google products and third-party services. Top Tips for Google Apps … Read more
10 tips to help you improve your Google Apps Script coding:
Bullet code copy example of how you can copy a bulleted list from one Google Document to another using Google Apps Script: // Function to copy the bulleted list from one document to another function copyBulletedList() { // Get the source document const sourceDoc = DocumentApp.getActiveDocument(); // Get the list items from the source document … Read more
Form Submit custom triggers and logs Google Form Auto respond and custom Logger source code for form project how to create a custom apps script Logger. Google Form Submit Capture onSubmit custom Google Apps Script Code Create custom Logger Lesson Download PDF
Send Doc as HTML email or output to webapp Send Doc as HTML email or output to webapp Use the document ID along with a fetch request to the URL to return the web contents as HTML. function getContent() {const url = ‘https://docs.google.com/feeds/download/documents/export/Export?id=’+DOCID+’&exportFormat=html’;const param = {method : ‘get’,headers : {‘Authorization’ : ‘Bearer ‘+ ScriptApp.getOAuthToken()},muteHttpExceptions: true};let … Read more
Apps Script Doc word Counter App Example Count the words within a Google doc using Google Apps Script code. The code in this lesson will demonstrate how to use apps script within a bound script to select the text content from a Google Doc, and then use typical javascript methods to replace all the double … Read more
doPost and doGet as an endpoint for web applications. You can setup your webapp to serve as an endpoint for web applications. In this example we explore how to make both GET method requests and POST method requests to the endpoint, retrieving and returning data from a spreadsheet into the JavaScript code as data from … Read more
Google Apps Script PDF maker from Google Doc template. Send PDFs as Emails. Setup files and folders 1Add data and set up the template Doc 2Create the Script – Connect to Spreadsheet data 3Get the data from each row within the sheet data 4Select the Google Doc Template 6Populate the Doc with Sheet Data 6Set … Read more
Google Apps Script Images and Files File variables 1How to create a Google Spreadsheet and give it a name, get its ID. 2How to Create a Folder and Get the ID of the Folder 2How to create a sheet and move the file into a specific folder 2How to select a file and move it … Read more
Apps Script – Search Active Sheet to find matching text results of cells Use of the createTextFinder method to search a sheet object and return back the matching results. To get the first value use the method findNext() in the results which is an iterator. To convert all the matching results into an array object … Read more