Apps Script Code Examples

Creating a Reminder System Build a Reminder System with Google Apps Script

by

Set up automated reminders based on your Google Sheets data: Step-by-Step Guide: function sendReminders() {var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var data = sheet.getDataRange().getValues();var now = new Date();for (var i = 1; i < data.length; i++) {var email = data[i][0];var reminderDate = new Date(data[i][1]);if (reminderDate <= now) {MailApp.sendEmail(email, ‘Reminder’, ‘This is your reminder!’);}}} Explanation:

Sending Calendar Invites Automate Calendar Invites with Google Apps Script

by

Automate your calendar invites based on Google Sheets data. Here’s how: Step-by-Step Guide: function sendInvites() {var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var data = sheet.getDataRange().getValues();for (var i = 1; i < data.length; i++) {var title = data[i][0];var date = new Date(data[i][1]);var guests = data[i][2];CalendarApp.getDefaultCalendar().createEvent(title, date, date, {guests: guests, sendInvites: true});}} Explanation:

Creating a Menu Item Add Custom Menu Items in Google Sheets with Apps Script

by

Custom menu items can enhance user experience. Here’s how to add one: Step-by-Step Guide: function onOpen() {var ui = SpreadsheetApp.getUi();ui.createMenu(‘Custom Menu’).addItem(‘Show Alert’, ‘showAlert’).addToUi();} function showAlert() {SpreadsheetApp.getUi().alert(‘Hello, world!’);} Explanation:

Fetching Data from an API Fetch Data from External APIs Using Google Apps Script

by

Google Apps Script can fetch data from external APIs and populate your Google Sheets. Here’s how: Step-by-Step Guide: function fetchData() {var url = ‘https://api.example.com/data’;var response = UrlFetchApp.fetch(url);var data = JSON.parse(response.getContentText());var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();sheet.getRange(1, 1, data.length, data[0].length).setValues(data);} Explanation:

Automating Data Sorting Automate Data Sorting in Google Sheets with Apps Script

by

Sorting data manually can be tedious. Automate it with Google Apps Script: Step-by-Step Guide: function sortData() {var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var range = sheet.getRange(1, 1, sheet.getLastRow(), sheet.getLastColumn());range.sort({column: 1, ascending: true});} Explanation:

Creating Custom Functions Enhance Your Google Sheets with Custom Functions Using Apps Script

by

Custom functions in Google Sheets can significantly enhance your data processing. Here’s how to create one: Step-by-Step Guide: Explanation:

Sending Automated Emails Based on Spreadsheet Data

by

Automate Your Emails with Google Apps Script: A Step-by-Step Guide Google Apps Script makes it easy to automate emails based on your Google Sheets data. Here’s how to set it up: Step-by-Step Guide: function sendEmails() {var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var data = sheet.getDataRange().getValues();for (var i = 1; i < data.length; i++) {var emailAddress = data[i][0]; // … Read more

Using rowLength and columnLength to Select Specific Columns in a Spreadsheet with Google Apps Script

by

Google Apps Script provides a powerful way to automate tasks in Google Sheets. If you’re looking to manipulate specific columns in a spreadsheet based on their lengths, this blog post will guide you through the process using rowLength and columnLength. Step-by-Step Guide function selectSpecificColumns() { // Open the spreadsheet and get the active sheet var … Read more

How to Copy Data from One Sheet to Another in Google Sheets Using Apps Script

by

Google Apps Script is a powerful tool for automating tasks in Google Sheets. One common task is copying data from one sheet to another without creating duplicates. In this post, we’ll walk through a script that accomplishes this using Google Apps Script. Scenario Imagine you have a sheet named “Orders” that contains statements of orders. … Read more

Automate Removing Whitespace from Every Line in Google Docs with Google Apps Script

by

If you frequently work with Google Docs, you might encounter documents with inconsistent whitespace at the beginning or end of lines. Manually removing these spaces can be tedious and time-consuming. Fortunately, Google Apps Script provides a way to automate this task, ensuring your document is clean and well-formatted. In this blog post, we’ll walk through … Read more