Tag Archives for " Google Apps Script "

How to get input from HTML form using Google Apps Script

There are different ways to display an HTML form from Google Apps Script. You can display a form in a Google Sheet (from a custom menu for example) or you can create a standalone web app and display the web form. Let us first see how to display an HTML form from a Google Sheet. […]

Continue reading

How to use Google Apps Script to send email with attachment

send mass email from google sheets

This example shows you how to send email from a Google Sheet with an attachment. Suppose we have a Google Sheet with all the clients and their email addresses. We need to get a PDF form filled and signed by each of these clients. The plan is to send the PDF form as attachment to […]

Continue reading

From Google Sheets, how to send email based on date

Suppose you want to send reminder emails automatically from your Google Sheets. The email needs to be sent when the invoice is overdue. So it requires to check the current date with the invoice due date. Let us see how to do that in Google Sheets using Google Apps Script. We have a Google Sheet […]

Continue reading

How to send HTML email in Google Apps Script

You can send HTML email from Google Apps Script. For example, suppose you want to send emails from your Google Sheet when certain events occur. You can send email using MailApp.sendEmail() function like this: MailApp.sendEmail({ to: email, subject: “This is a test email”, htmlBody: message }); where the message is a string with HTML content. […]

Continue reading

How to get cell value in Google Sheets using apps script

There are different ways to get the cell values. This article shows you different ways to get cell values from the Google Sheet. Some of the methods (like getCell(row, col) ) will be easier if you want to iterate through the cells. Get selected cell value in your Google Sheet Script First, let us add […]

Continue reading

Building Single Page Apps (with Vue and Bootstrap) on Google Apps Script

Building a complete web app on Google Apps Script

This is the second part on my Series on Google Apps Script advanced projects. See the first part of the article here. In the first part, we used ES6 and npm modules in the server side of Google Apps Script. In this article, we will move on to the client-side. We will create a Single […]

Continue reading

Using ES6 and npm modules in Google Apps Script

Google’s Apps Script should be of interest to all JavaScript developers. Apps Script is good for automation. Through it, you can directly access Google’s many services, such as Google Sheets, Gmail, Google Docs, Google Calendar, and more. With a little bit of imagination, you can create very exciting Apps and add-ons using Google Apps Script. […]

Continue reading