Youtube

55 Google Apps Script Videos Playlist from YouTube Learn more about apps Script

by

Google Apps Script is a scripting language based on JavaScript that allows users to extend and automate the functionality of various Google services such as Sheets, Docs, Forms, and Gmail. It provides a wide range of services and methods for interacting with Google Apps and allows users to create custom scripts and applications that integrate … Read more

Creating and Updating Slides with Google Apps Script #tips

by

Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) The first function makeSlides() creates a new Google Slides presentation titled “Laurence Test2”. The function then retrieves the first slide in the presentation and inserts a new text … Read more

Modify Form Content with Google Apps Script #FormUpdate

by

Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) The code modForm() does the following: The variable id is assigned the ID of an existing Google Form. The openById() method of FormApp is used to open the … Read more

Creating HTML Email Table with Google Sheets Data #mail

by

Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) Sets the id variable to a specific Google Sheets ID. Opens the Google Sheets file with the given id, selects the sheet named “users”, and retrieves all the … Read more

Folder contents tracker and creator in Google Drive #tips

by

Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) dataFolder() function The dataFolder() function does the following: Sets the sid variable to a specific Google Sheets ID. Sets the id variable to a specific Google Drive folder … Read more

Retrieve Data from Google Sheet as Database #AppsScript

by

Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) The getUserInfo() function takes an id parameter and returns an object containing information about a user. It first sets a variable sid to a string value, which is … Read more

Create Required Fields & Multiple Choice Form with Google Apps Script #Forms #Code

by

Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) This code creates a new Google Form with a title, a text question, and a multiple choice question with three choices. It also logs the URL of the … Read more

Accessing and Modifying Google Sheets

by

Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) The modData() function does the following: Sets the id variable to a specific Google Sheets ID. Opens the Google Sheets file with the given id and selects the … Read more

Sending Personalized Emails with Google Sheets and Apps Script

by

Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) Sets the id variable to a specific Google Sheets ID. Opens the Google Sheets file with the given id and selects the sheet named “users”. Gets the data … Read more