Google Apps Script

15 Nov 2018

Download Gmail Attachments to Google Drive with Apps Script

Nov 15, 2018

The Save Gmail Attachments add-on for Google Drive downloads file attachments from an email message to a specific folder in your Google Drive.

01 Nov 2018

How to Get Hidden and Filtered Rows in Google Sheets with Google Script

Nov 1, 2018

You can hide entire rows in Google Sheets manually or use filters and hide on or more or rows in the sheet that matches your specified criteria.

11 Sep 2018

Create YouTube Playlist with Google Script and Sheets

Sep 11, 2018

This Google Scripts reads the list of YouTube Video IDs from a Google Spreadsheet and adds them all to an existing playlist in YouTube.

11 Sep 2018

Search YouTube with Google Script and YouTube API

Sep 11, 2018

This Google Script shows how to query the YouTube API to search videos by keywords. The source data is in a column in Google Spreadsheet and we connect to the YouTube Data API via Google Apps Script.

06 May 2018

How to Check if the Google User has a G Suite Account

May 6, 2018

This Google Apps Script will help your add-on determine whether the current logged-in user is on GSuite (Google Apps) or if they are using the consumer (free) Google Account.

22 Mar 2018

Get List of Google Team Drives with Apps Script

Mar 22, 2018

This Google Apps Script returns a list of Team Drives that the authorized user is part of.

16 Dec 2017

Generate Screenshots of Google Slides with Google Script

Dec 16, 2017

The new TallTweets app uses the Google Apps Script to convert Google Apps Script into GIF images.

19 Nov 2017

Find Driving Directions, Distance and Time with Google Maps API and Apps Script

Nov 19, 2017

Use Google Apps Script with the Google Maps API to find the driving distance, time and the driving route between any two points.

30 Oct 2017

Upload Google Drive Files to Dropbox with Google Apps Script

Oct 30, 2017

Learn how to upload any Google Drive file to your Dropbox folder using Google Apps Script.

30 Oct 2017

Download Web Files to Dropbox with Google Apps Script

Oct 30, 2017

Use Google Apps Script with the Dropbox API to download any file from the Internet and upload it directly to the Internet without saving it to your computer.

30 Oct 2017

Extract Text from PDF files with Google Apps Script

Oct 30, 2017

You can use Google Apps Script to extract text from a PDF file and save the extracted text as a new document in Google Drive.

07 Oct 2017

Post Messages to Discord Channel via Google Apps Script & Webhooks

Oct 7, 2017

Discord a hugely popular voice and text chat app for gamers. Like Slack, it offers text chat channels to help you stay connected with the community.

13 Sep 2017

Tutorial: Google Cloud Speech API with Service Account

Sep 13, 2017

This tutorial explains how to use the Google Cloud Speech API with Google Apps Script. We’ll use a Service Account to authenticate the application to the Cloud Speech API and the source audio file is stored in a Google Cloud Storage bucket.

13 Sep 2017

How to Use the Google Natural Language API with Apps Script

Sep 13, 2017

Google Natural Language API helps you make sense of unstructured data. You can pass a string, like a tweet or transcribed speech, to the Natual Language API and it will detect the entities (like person, places, products, events), the sentiment (whether customers are happy or mad at your brand), and the syntax (parts of speech).

13 Sep 2017

Unsubscribe from Summary of Failure Emails from Google Apps Script

Sep 13, 2017

You may sometimes receive a “Summary of failures for Google Apps Script” email notification from Google (apps-scripts-notifications@google.com).

13 Sep 2017

Convert Audio to Text with Google Cloud Speech API

Sep 13, 2017

The Online Dictation app uses the HTML5 Speech Recognition API to transcribe your voice into digital text.

08 Aug 2017

Add the Edit Response URL of the Google Form to Google Spreadsheet

Aug 8, 2017

This Google Apps Script code will insert the Form Edit Response URL to the Google Spreadsheet when a new Google Form is submitted.

02 Aug 2017

Web Scrape Instagram to Get User Profiles with Google Apps Script

Aug 2, 2017

This example shows how to screen scrape the Instagram website to extract the profile information and statistics of any user on Instagram.

02 Aug 2017

Using Zoho API with Google Apps Script

Aug 2, 2017

This example shows how to connect to Zoho Books using Google Apps Script and the Zoho APIs.

13 Jul 2017

How to Use Google Cloud APIs with Apps Script – Sample Application

Jul 13, 2017

The Google Cloud Vision API helps you identify text, objects and places inside pictures. The images may be hosted on a public website, you could store them inside a Google Cloud Storage bucket or you can encode the images to a base64 string.

12 Jul 2017

Build a REST JSON API With Google Apps Script

Jul 12, 2017

This example shows how to build a simple JSON REST API with Google Apps Script. You can make a jQuery AJAX request to the Google Script and the server returns a JSON response.

15 Jun 2017

Delete Blank Rows from Tables in a Google Document with Apps Script

Jun 15, 2017

This Google App Script snippet will help you quickly delete all the blank rows of any tables inside your Google Document.

11 Jun 2017

Search Books with Goodreads API and Google Apps Script

Jun 11, 2017

The Goodreads API helps you query the entire database of books on the Goodreads website. You can find the ratings of books, fetch book reviews, search books by author or even publish your own reviews.

27 May 2017

How to List all your Team Drives in Google Drive with Apps Script

May 27, 2017

Google Team Drives are shared spaces in your Google Drive where you can store files and they instantly become available to all members of the Team Drive.

12 Jul 2017

Send Data to Google Analytics with Measurement Protocol and Google Apps Script

Jul 12, 2017

This example shows how to send data to Google Analytics using the Measurement protocol. The event data is sent via POST because it allows for a larger payload.

29 Jun 2017

Post an Update to Twitter with Google Apps Script

Jun 29, 2017

You can use Google Apps Script to post status updates (tweets) to Twitter. This example generates an OAuth 1.0a HMAC-SHA1 signature that is converted to base64 and is passed to the Twitter API via an HTTP POST request.

23 Apr 2017

How to Update Multiple Cell Values in Google Sheets with Apps Script

Apr 23, 2017

The SpreadsheetApp service of Google App Script offers the range.setValues() method to update a single cell or a range of cells inside a Google Spreadsheet.

22 Apr 2017

Find the Visitor’s Browser and OS with Google Apps Script

Apr 22, 2017

The HTML Service of Google Apps Script lets you create HTML and JavaScript based applications that can be served as standalone web apps or they can be used for building user interfaces (like a form) contained inside Google Sheets and Google Docs.

20 Apr 2017

How to Convert Microsoft Excel to Google Spreadsheet Format with Apps Script

Apr 20, 2017

If your colleagues have been emailing you Microsoft Excel spreadsheets in xls or xlsx format, here’s a little snippet that will help you convert those Excel sheets into native Google Spreadsheet format using the Advanced Drive API service of Google Apps Script.

13 Apr 2017

Google File Picker API with Google Drive – Working Example

Apr 13, 2017

The Google File Picker API lets users easily upload files to Google Drive and also select existing files and folders from Drive.

14 Apr 2017

Using the Google Slides API with Apps Script for Document Merge

Apr 14, 2017

Google Slides API lets you programmatically create new presentations and edit existing ones. You can pull data from an external data source, like a Google Spreadsheet or Salesforce CRM, and create a nice-looking report in the form of a presentation.

15 Mar 2017

Send SMS with Google Forms

Mar 15, 2017

A teacher has created a Google Form where students enter their name, the course they’ve enrolled into and their parent’s mobile number.

31 Jan 2017

Load External JavaScript Libraries in Google Scripts with eval()

Jan 31, 2017

You can include external JavaScript libraries or any other script in your Google Apps Script projects in multiple ways.

14 Dec 2016

Bounced Email Parsing with Google Scripts

Dec 14, 2016

The Google Script scans your Gmail mailbox for messages from mailer-daemon@gmail.com and prepares a bounce email report logging the failed deliveries in a Google Spreadsheet.

30 Nov 2016

Get List of Email Aliases with Gmail API

Nov 30, 2016

Gmail users can send emails of behalf of any other email address that is set as an alias in their primary account.

06 Oct 2016

Case Studies – Google Scripts and G Suite

Oct 6, 2016

Google Apps Script helps you automate tasks across G Suite and other Google products. Here are some interesting problems that people have solved with Google Scripts and G Suite (formerly known as Google Apps).

07 Sep 2016

How to Publish Google Script as a Web App

Sep 7, 2016

You can publish a Google Apps Script as a web app and anyone can run your scripts directly from their browsers.

06 Sep 2016

How to Import CSV Files into Google Spreadsheets with Google Apps Script

Sep 6, 2016

You can easily import CSV files into Google Spreadsheet using the Utilities.parseCsv() method of Google Apps Script.

21 Jul 2016

Convert Excel Files to CSV in Google Drive with Apps Script

Jul 21, 2016

The Google Apps Script uses the Advanced Drive API to covert Microsoft Excel files (XLS, XLSX) into CSV files and saves them into a specific Google Drive folder.

29 May 2016

How to Learn Google Apps Script

May 29, 2016

The best resource for learning Google Script is the official documentation available at developers.google.com. Here are other video tutorials and online learning resources where you can get up to speed using Google Apps Script that will let you programmatically access various Google Apps and services include Gmail, Google Drive, Calendar, Google Forms, Google Docs and more.

14 May 2016

Download Unsplash Photos to Google Drive

May 14, 2016

Unsplash is the best source for free images on the Internet. The images have the Creative Commons zero license meaning you can do anything with the photos.

15 Apr 2016

Copy Email Messages in Gmail with Apps Script

Apr 15, 2016

This example shows how to create email copies in Gmail with Google Apps Script and the Gmail API.

12 Apr 2016

Upload and Post Images to Twitter with Google Script

Apr 12, 2016

There are two ways to post tweets that contain images. You can either upload the picture(s) to an image hosting service and then paste the image URL into the tweet.

05 Jun 2016

Copy Google Spreadsheet Data to another Sheet with Apps Script

Jun 5, 2016

The cloneGoogleSheet() function will copy data (all rows and columns, but no formatting styles) from one Google Spreadsheet to any other Google Spreadsheet under the same Google Drive.

29 Mar 2016

Send SMS with Google Scripts and Twilio

Mar 29, 2016

The Twilio service helps you send SMS and MMS programmatically. They have a REST API that you can call through Google Apps Script and send SMS text messages from your Google Apps based projects.

22 Mar 2016

Make AJAX Request to Google Script Web App with jQuery

Mar 22, 2016

You have published a Google Apps Script as a public web app that returns data as JSON but when you try to make an AJAX call to this web app using jQuery, you get the “Cross Origin” error.

09 Mar 2016

A Custom Google Spreadsheet Function for Tracking Pageviews

Mar 9, 2016

GOOGLEANALYTICS is a custom Google Spreadsheet function that tracks Spreadsheet views with the help of Google Apps Script.

10 Feb 2016

Create Google Calendar Event with File Attachment

Feb 10, 2016

The Google Script will create a new event in the specified Google Calendar and will attach a file from Google Drive into the event.

08 Feb 2016

Get QuickBooks Data into Google Sheets with Apps Script

Feb 8, 2016

A recent project involved pulling payments, invoices and accounting data from QuickBooks online into a Google Spreadsheet in near real-time.

10 Feb 2016

Use the Twitter Search API without the OAuth Library

Feb 10, 2016

Google doesn’t recommend using script libraries inside add-ons based Apps script projects as they tend to impact performance.

Nov 15, 2018

Nov 1, 2018

Sep 11, 2018

Sep 11, 2018

May 6, 2018

Mar 22, 2018

Dec 16, 2017

Nov 19, 2017

Oct 30, 2017

Oct 30, 2017

Oct 30, 2017

Oct 7, 2017

Sep 13, 2017

Sep 13, 2017

Sep 13, 2017

Sep 13, 2017

Aug 8, 2017

Aug 2, 2017

Aug 2, 2017

Jul 13, 2017

Jul 12, 2017

Jun 15, 2017

Jun 11, 2017

May 27, 2017

Jul 12, 2017

Jun 29, 2017

Apr 23, 2017

Apr 22, 2017

Apr 20, 2017

Apr 13, 2017

Apr 14, 2017

Mar 15, 2017

Jan 31, 2017

Dec 14, 2016

Nov 30, 2016

Oct 6, 2016

Sep 7, 2016

Sep 6, 2016

Jul 21, 2016

May 29, 2016

May 14, 2016

Apr 15, 2016

Apr 12, 2016

Jun 5, 2016

Mar 29, 2016

Mar 22, 2016

Mar 9, 2016

Feb 10, 2016

Feb 8, 2016

Feb 10, 2016

Site Search

About The Author

Top Lists