Code Archives - Web Geek

03 Aug 2019

Singleton Pattern in JavaScript

Aug 3, 2019

In the Singleton Pattern in JavaScript, there is exactly one instance of a class and there is no way to create multiple instances of the same class.

29 Jul 2019

How to Verify Google API OAuth Token

Jul 29, 2019

The Creator Studio add-on fetches the OAuth2 access token for the projects using the Google Apps Script API that is then used to authorize the Google Client JavaScript API and fetch the Slide Screenshots.

29 Jul 2019

Convert Google Slides Presentation to Image Sequence

Jul 29, 2019

The Creator Studio add-on for Google Slides can export your Google Slides presentation to a variety of formats including animated GIF images, MP4 video and a sequence of images in PNG format.

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.

30 Dec 2017

What are Closures in JavaScript

Dec 30, 2017

Closure in JavaScript, according to Douglas Crockford, is an inner function that always has access to outer function’s variables and parameters, even after the outer function has returned.

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

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.

16 Jun 2017

How to Upload Files with UploadCare JavaScript API

Jun 16, 2017

UploadCare, like FileStack, lets users upload files to the cloud from their local computer or they can pull existing files from online cloud storage services like Google Drive, Dropbox, OneDrive and more.

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.

15 Jun 2017

Build an Image Uploader with Imgur API and JavaScript

Jun 15, 2017

If you are building a file uploader app that would allow users to upload images from the local disk to the web, Imgur is a good platform to start with.

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.

11 Apr 2017

List All Users of a Google Apps Domain in Google Spreadsheets

Apr 11, 2017

The enterprise editions of Google Drive Auditor and Gmail Address Extractor use the Google Apps Admin SDK (Directory API) with Google Apps Script to create a list of all users that are part of a G Suite (Google Apps) domain.

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.

27 May 2017

Differences between Google Team Drive and My Drive

May 27, 2017

G Suite Enterprise and G Suite Business users get unlimited storage and they can create Team Drives inside Google Drive.

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.

17 Jan 2017

Google OAuth 2.0 Service account with PHP and Google APIs

Jan 17, 2017

This sample code uses Google Service Accounts with PHP to get a list of users in a Google Apps Domain using the Admin Directory API.

17 Jan 2017

How to Create Google Service Accounts

Jan 17, 2017

This step by step tutorial will walk you through the steps to create a Google service account using the Google developer console.

17 Jan 2017

Service Accounts and Google APIs – Introduction

Jan 17, 2017

When a user connects to an application that uses OAuth 2 authentication, they are presented with a consent screen that describes what information about their account will be shared with the application and it may also includes a list of various Google APIs that the application has requested access to.

17 Jan 2017

Configure OAuth2 Service Accounts for Domain-wide Delegation

Jan 17, 2017

The tutorial describes how the Google Apps domain of a G Suite domain can configure an OAuth2 Service account application for domain wide delegation.

17 Jan 2017

Using Google Service Accounts with Google Apps Script

Jan 17, 2017

This sample code shows how to use OAuth in Google Apps Script using Service Accounts. The G Suite admin can access the Google Drive files of any user – the username or email address of the user you are trying to impersonate specified with the method setSubject.

16 Jan 2017

Tutorial: Create Application with Google APIs and OAuth 2

Jan 16, 2017

Now that you understand the basics of Google OAuth 2, let’s build a simple application that uses OAuth 2.0 for connecting to Google API’s on user’s behalf.

16 Jan 2017

An Introduction to OAuth 2 and Google APIs

Jan 16, 2017

OAuth 2, in simple English, is a simple protocol that makes it easy for third-party applications to access a user’s account without the user having to give out their username and password to the application.

16 Jan 2017

Connect to Google API with PHP and OAuth2 – Sample Code

Jan 16, 2017

This sample application describes how your PHP application can connect to the user’s Gmail account using the Google PHP client library and OAuth2.

30 Jan 2017

Using Gmail JavaScript API to Search Email Threads

Jan 30, 2017

This code uses the Gmail JavaScript API to search the inbox of the authenticated user (userId = me) for email threads that match the specified query.

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.

24 Nov 2016

Extract and Replace Links in HTML with JavaScript RegEx

Nov 24, 2016

For the Mail Merge project, I need to extract all the hyperlinks in the email message and append email tracking parameters to each of the links.

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.

23 Aug 2016

Spintax (Spin Syntax) with JavaScript

Aug 23, 2016

Spintax, short for spin syntax, is a list of text phrases, sentences, and synonyms separated by the pipe (|) character.

12 Aug 2016

Convert Image to Base64 Data URI

Aug 12, 2016

In Spreadsheet Paintings, you upload a photograph from the local disk and it transforms the picture into pixel art.

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.

13 Sep 2016

How to Center a DIV with Flexbox

Sep 13, 2016

Centering a div element on a web page is easy with Flexbox. The element is centered both vertically and horizontally and the method uses no JavaScript.

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.

29 Mar 2016

Post Google Forms Reponse into Insightly CRM

Mar 29, 2016

An organization uses Google Forms to capture leads and would like to automatically post the form submissions as open leads into Insightly for pursual by their sales team.

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.

08 Mar 2016

Call JavaScript Function by String Name

Mar 8, 2016

You can use eval() method to invoke a JavaScript function whose name is stored in a string variable but there’s a better method that doesn’t require eval.

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.

08 Feb 2016

Authorization Errors with Apps Script Execution API

Feb 8, 2016

A web form was built using the Google Apps Script Execution API and it would only be using to users who have successfully authenticated using their Gmail / Google Apps account.

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.

07 Jan 2016

Use the Gmail API to Send Emails with Attachments

Jan 7, 2016

This example shows how you can easily send email messages with file attachment using the Gmail API.

11 Jul 2019

Convert and Email Google Spreadsheets as PDF Files

Jul 11, 2019

You can set up a cron job in Google Drive using Google Apps Script that will send any Google Spreadsheet, or any other document or file in the Drive, to one or more email addresses at a specified time.

29 Mar 2016

Move File to a Different Folder in Google Drive

Mar 29, 2016

Google Apps Script doesn’t offer a method for moving files from one folder in Google Drive to another one but there’s an option to add a file in Drive to multiple folders (similar to symbolic links in Unix).

04 Jan 2016

Convert Google Sheet to Excel XLSX Spreadsheet

Jan 4, 2016

The previous example shows how to convert Google Sheets to XLS format using the Google Drive API.

03 Jan 2016

Update Gmail Picture of Google Apps Users with Google Script

Jan 3, 2016

An organisation is running on Google Apps and, as part of a branding exercise, they need to update the profile pictures of all Gmail users.

28 Dec 2015

Update Gmail Signatures of Employees with Google Apps Script

Dec 28, 2015

Google Apps allows domain administrators to update the Gmail signatures programatically. This helps you maintain a standard email signature for all users of your organisation but certain fields like employee’s name, email address, title or phone number can be variable.

23 Dec 2015

Send Emails with Attachments with Google Apps Script and Mandrill

Dec 23, 2015

Gmail sending limits are restricted especially when you are sending emails programatically as in the case of Mail Merge.

18 Dec 2015

How to Write JSON to a Google Spreadsheet

Dec 18, 2015

The WriteJSONtoSheet method take a JSON object and appends it as a new row in a Google Spreadsheet.

18 Dec 2015

How to Suspend Execution of a Google App Script While it is Running

Dec 18, 2015

A commonly requested feature of Mail Merge was that users wanted the ability to stop the merge process (and thus the underlying Google Script) after hitting the start button.

18 Dec 2015

Check if a Date is Valid with JavaScript

Dec 18, 2015

An HTML form requires users to select the year, month and date in separate dropdown fields without using a date picker.

17 Dec 2015

Create Google Contacts from Google Voice Mail

Dec 17, 2015

Google Voice sends you an email notification where there’s a missed call or a voicemail for you.

12 Jan 2016

Use the Google Translate API for Free

Jan 12, 2016

The official Google Translate API is available for businesses only but you can use Google Apps Script to create your own Google Language Translation API without having to pay the enterprise license fee.

14 Jan 2016

Validate an Email Address with PHP

Jan 14, 2016

Before sending email via SMTP, the client computer initiates a transaction with the SMTP email server that is listening for commands on TCP port 25.

12 Dec 2015

Display RSS Feed on a Web Page with Google Feed

Dec 12, 2015

You can use the Google Feeds API to fetch and display the content of any RSS feed on a web page.

12 Dec 2015

Get the Amazon Sales Rank by ASIN in Google Spreadsheet

Dec 12, 2015

Given the Amazon ASIN number, the getAmazonSalesRank() method with return the overall Sales Rank of the item using the Amazon Product Advertising API.

12 Dec 2015

Create RSS Feed for YouTube Search Results

Dec 12, 2015

Based upon the Twitter RSS Feed, a Maryland based Rails developers has created a Google Script that creates a RSS feed of YouTube videos matching your search terms.

12 Dec 2015

Convert Word, Excel and PowerPoint files to Google Docs with Google Script

Dec 12, 2015

You can store your Microsoft Office files (Word Documents, PowerPoint Presentations and Excel Spreadsheets) in Google Drive in their native format but then it takes up storage space, the files cannot be edited in the cloud and you’ll not be able to embed the files on other web page.

10 Dec 2015

Share Files in Google Drive without Email Notifications

Dec 10, 2015

The File.addViewer() or File.addEditor() methods of Google Apps Script allow you to share files in Google Drive programmatically.

10 Dec 2015

Save Paypal Email Receipts in Google Spreadsheet

Dec 10, 2015

When you make a purchase through PayPal, the payment company sends you an email receipt with the details of the transaction.

09 Dec 2015

Indian Numbering Function for Google Sheets

Dec 9, 2015

If you would like to represent numbers using the Indian Numbering system (lakhs, crores) inside a Google Spreadsheet, the INR() custom function by Amit Wilson will help.

09 Jan 2016

Apps Script Execution API Error – Permission Denied

Jan 9, 2016

The Apps Script Execution API lets you call Google Apps Scripts from standard HTML pages. I’ve been working on a project that involved Apps Script Execution API, it was running perfect in the developer account but as soon as the code was migrated to the client’s Google account, it failed.

05 Jan 2016

Extract Text from Images with Google Drive OCR

Jan 5, 2016

Google Drive supports OCR for image and PDF uploads. That means if you upload a, say, JPEG file containing text, Google Drive can automatically extract the text from the image and save it to an editable Google Document.

05 Dec 2015

Upload Files using the Multipart Post Method with Google Script

Dec 5, 2015

This code snippet shows how you can use the use the multipart post method to upload a file from Google Drive to Box using the Box API and Google Script.

05 Dec 2015

Connect to Box API with Google Apps Script

Dec 5, 2015

You can use the OAuth2 library with Google Apps script to connect to the Box API.

05 Dec 2015

Build a Charts Dashboard with Google Sheets and HTML Service

Dec 5, 2015

The school has a Google Form where teacher enter the performance grades of their students. This form data is stored in a Google Spreadsheet and they are using Google Charts with the Google Visualization API to convert these tables of rows into visual charts that can be easily visualized.

03 Dec 2015

Import CSV File into Google Cloud SQL from Cloud Storage

Dec 3, 2015

You can upload one or more CSV files to a specific bucket in Google Cloud Storage and then use Google Apps Script to import the CSV files from Cloud Storage into your Google Cloud SQL database.

23 Dec 2015

Autoreply to Filtered Gmail Messages with Google Scripts

Dec 23, 2015

This Google Script, originally published by @rboyd, scans for lengthy emails in your Gmail mailbox (messages that have more than 100 words) and sends an auto-reply requesting the sender to resend the email after editing to less than 100 words.

07 Jan 2016

Create Draft Messages with Attachments using Gmail API

Jan 7, 2016

The GmailApp service of Google Apps Script doesn’t support drafts creation but you use the Gmail API to programatically create drafts in your mailbox.

07 Nov 2015

How to Use HTML5 Data Attributes with JavaScript

Nov 7, 2015

HTML5 supports data attributes that you can use to store extra information with any DOM elements.

05 Jan 2016

Count Number of Pages in PDF with Google Script

Jan 5, 2016

The Google Documents API doesn’t offer a method to get the number of pages in a document.

03 Nov 2015

Caret (Arrow) Symbol in CSS

Nov 3, 2015

C^ret is an online tool that helps you create a caret (or an arrow symbol) in pure CSS.

03 Nov 2015

HR with Centered Text

Nov 3, 2015

This HTML/CSS snippet creates an HR element with text in the middle of the line. The text is supplied in the data-* attribute of the HR element.

01 Nov 2015

Use OCR in Google Docs to Extract Text from Images

Nov 1, 2015

Google Docs supports OCR so you can upload a scanned PDF file or an image to Google Drive and it will extract the text from the file.

27 Oct 2015

Center a DIV with Pure CSS

Oct 27, 2015

This CSS Snippet will place the DIV at the centre of a page. The div is centered both horizontally and vertically without requiring any jQuery or JavaScript.

27 Oct 2015

Insert Inline Image in a Google Document

Oct 27, 2015

The Apps Script snippet will insert an image at the current cursor position of the Google Document.

09 Mar 2016

Gmail Tracking with Google Analytics and Apps Script

Mar 9, 2016

This Google Script inserts the Google Analytics code in your outgoing email messages to help you track delivery and opens.

23 Dec 2015

Create Trello Cards from a Google Form

Dec 23, 2015

Trello provides you a unique email address (like xyz@boards.trello.com) for any board in you account and any email message sent to this address is added as a new card to the Trello Board.

22 Oct 2015

Fetch Google Search Results with the Site Search API

Oct 22, 2015

Google Site Search offers a JSON API allowing you to query Google Search results from your app.

18 Dec 2015

Post Google Forms Submissions to Slack

Dec 18, 2015

Andy Chase has published a Google Script that will let you automatically post Google Form submissions to a Slack channel.

06 Jan 2016

How to Send Tweets with Google Scripts and Twitter API

Jan 6, 2016

This example shows how you can setup your own Twitter Client using Google Apps Script and publish tweets programmatically from inside a Google Document, a spreadsheet or even a web app.

08 Oct 2015

Upload Files to Google Cloud Storage with Google Scripts

Oct 8, 2015

One of my recent project involved uploading files from Google Drive to a particular bucket in Google Cloud Storage.

14 Dec 2015

Google Apps Script Library for Gmail API

Dec 14, 2015

The Gmail API offers extra functionality not available inside the Gmail service of Google Apps Script.

14 Dec 2015

Google Apps Script Library for Google Drive API

Dec 14, 2015

The advanced Google Drive API offers access to functionality that is not available with the Drive API inside Google Apps Script.

25 Oct 2015

Parse Gmail Messages to Extract Data

Oct 25, 2015

A mailbox has 1000s of email messages sent though legacy contact forms that contain data like the name, email and address of the senders.

10 Aug 2015

Send Email Messages from Gmail to Slack Channel

Aug 10, 2015

The Google Apps Script, courtesy @andrewwilson, uses incoming webhooks to post email messages from your Gmail mailbox into Slack channel.

03 Aug 2015

Twitter Bot for Auto-Favoriting and Retweeting Tweets

Aug 3, 2015

The Twitter bot, written with Google Apps Script, will auto-favorite and retweet tweets every few minutes.

01 Oct 2015

Get the Full Path of a File in Google Drive

Oct 1, 2015

In Google Drive, you can have a file inside a folder which can be located inside another folder and so on.

26 Jan 2019

Upload Files to Google Drive with Google Apps Script

Jan 26, 2019

Google Forms do not offer the file uploads feature but you can use Google Apps Script and let anyone upload files to Google Drive through an HTML web form.

22 Jul 2015

Using Blogger API with Google Apps Script

Jul 22, 2015

Like WordPress, you can also manage your Blogger blogs using Google Apps Scripts. You need to enable the Blogger API from your Google Developers console and also include the Apps Script oAuth2 library in your Google Apps script project.

31 Oct 2015

Search Twitter with Google Apps Script

Oct 31, 2015

The Twitter Search Archiver uses the OAuth1 library for Google Apps Script to talk to the Twitter Search API.

07 Jul 2015

Automatically Print Files Placed in Drive with Google Cloud Print and Apps Script

Jul 7, 2015

With Google Cloud Print, you can manage your printers and create print jobs from any computer or mobile device even if they are not connected to the printer or they are on a different network.

04 Jul 2015

Know Who Changed a File in Google Drive with Apps Script

Jul 4, 2015

Google Drive maintains a history of all edits made to a file and this information comes if you are trying to figure out who modified the files in your Google Drive.

04 Jul 2015

Get EXIF Data and GPS Location of Images in Google Drive

Jul 4, 2015

When you upload your images to Google Photos, they also become available in Google Drive and you can these access these image files with Google Apps Scripts and the Google Drive API.

03 Nov 2015

Basic Modal Window Popup with Pure CSS

Nov 3, 2015

This HTML link will open a modal popup that itself can be formatted using HTML and CSS.

26 Jun 2015

Export Formulas and Notes from a Google Spreadsheet

Jun 26, 2015

Dan Thareja has written a Google Script that will let you export all the formulas, cell values and notes from a Google Spreadsheet as a JSON file.

24 Jun 2015

Convert Text to Images with JavaScript

Jun 24, 2015

TallTweets uses the HTML2Canvas library to convert text into PNG images. The generated images is converted into base64 (data URI) which is then sent to the server over a HTTP POST request for uploading to twitter.

25 Sep 2015

How to Make a Twitter Bot with Google Scripts

Sep 25, 2015

You can easily write a Twitter bot with the help of Google Apps Script. It fetches tweets addressed (@mentions) to the bot through the Twitter API, computes the answer with Wolfraph Alpha and replies with a tweet.

04 Jun 2015

Save Gmail Messages to a Google Spreadsheet

Jun 4, 2015

The Google Script from @oshliaer will save the body of email messages from Gmail to the currently active worksheet inside Google Spreadsheet.

26 May 2015

Connect to Insightly API using Google Scripts

May 26, 2015

You can use Google Apps Script to talk to the Insightly API and the project data can be integrated with other Google Services like Google Spreadsheet or Gmail.

26 May 2015

Send Gravity Forms Data to Google Spreadsheet or Email

May 26, 2015

Gravity Forms is an extremely popular Forms plugin for the WordPress. When someone submits a form created with Gravity Forms, the form data is saved inside the MySQL database associated with your WordPress installation.

15 Jun 2015

Get Google Spreadsheets Data as JSON in your Website

Jun 15, 2015

You can retrieve the content of any public Google Spreadsheet in your web app using JSON feeds.

23 May 2015

Find Location & IP Address of Email Sender

May 23, 2015

If you would like to know the IP Address and Location of email sender in Gmail, Google Scripts can help.

22 May 2015

Upload Files to HTML Form with Google Scripts

May 22, 2015

The Google Script will automatically download a file from the Internet and upload it to another HTML form with an HTTP POST request.

22 May 2015

Archive Old Email Messages in Gmail Automatically

May 22, 2015

The Google Script will archive all email threads in a specific Gmail label that have been inactive for more than a week.

22 May 2015

Convert Image to PDF to Google Script

May 22, 2015

The Google Script will fetch an image file, convert it to PDF and sends it as an image attachment using the Gmail service.

22 May 2015

Save Gmail Messages as Google Documents

May 22, 2015

The Google Script will save any Gmail message (or thread) in your Google Drive as a native Google Document with proper formatting.

15 May 2015

Replace Adobe Forms Central with Google Forms

May 15, 2015

Adobe is retiring their Forms Central product in the next few weeks. You’ll be download the Form Responses to Excel, CSV, or PDF formats.

14 May 2015

Using Google Picker with Google Apps Script

May 14, 2015

The Google Picker API lets you select files and folders in Google Drive visually. It can used inside Google Spreadsheet, Google Docs or a standalone HTML web app.

13 Jul 2015

Make an RSS Feed with Google Apps Script

Jul 13, 2015

ThinkAmI uses the XMLService of Google Apps Script to create a valid RSS feed that is served to the browser using ContentService with the MIME type set as RSS.

05 May 2015

Search Files inside Sub-folders in Google Drive

May 5, 2015

Like the previous script for listing Google Drive files, this Google Script will find all files of any particular MIME type in your Google Drive.

05 May 2015

Reorder Worksheets in Google Spreadsheets by Name

May 5, 2015

You have a Google Spreadsheet with multiple worksheets and, to making organization easier, you would like to reorder or sort the various sheets inside the spreadsheet by name.

06 May 2015

Export Tweets from Twitter with Google Apps Script

May 6, 2015

The Twitter Archiver app will archive tweets for any hashtag to a Google Spreadsheet using the Twitter API and Google Apps Script.

03 May 2015

Authenticate WordPress Users with Google Apps Script

May 3, 2015

You can use the XMLRPC library with Google Scripts to authenticate users that are members of your WordPress or Blogger website.

21 Jul 2015

Save Gmail Drafts with Google Apps Script

Jul 21, 2015

The Mail Merge Add-on uses the new Gmail API to create and save draft messages Gmail programmatically, something which cannot be done using the standard GmailApp or MailApp service of Google Apps Script.

16 Apr 2015

Get Book Details by ISBN with the Google Books API

Apr 16, 2015

The Google Books API can return details of any book from the ISBN code. You get to know the book title, author names, publishing date, publisher and so on.

27 Jul 2015

Make a Copy of Folders in Google Drive with Google Scripts

Jul 27, 2015

In Google Drive, there’s no easy way to clone a folder. You can make a copy of individual files but there’s no command for creating duplicate folders that are a mirror of another folder.

03 May 2015

Post to WordPress with Google Scripts using XML-RPC API

May 3, 2015

You can use Google scripts to publish blog posts to any Blogger and WordPress website using the XML-RPC API.

27 Oct 2015

Prevent Google Scripts from Exceeding the Maximum Execution Time Limit

Oct 27, 2015

Google Apps scripts can run for a maximum period of 4-5 minutes and you’ll get the error “Exceeded maximum execution time” if the script takes more than the allowed time to complete.

30 May 2015

Backup Web Pages to Google Drive Automatically

May 30, 2015

This Google Script will take a daily snapshot of a particular web page and saves it as an HTML file in the Google Drive.

09 Mar 2015

Gmail to Evernote with Google Scripts

Mar 9, 2015

The Gmail to Evernote program will automatically send your Gmail message to your Evernote account using Google Scripts.

30 Apr 2015

Save Google Sheet as JSON

Apr 30, 2015

The ExportSheetAsJSON() method will save the currently active sheet of a Google Spreadsheet as a JSON file and saves it to your Google Drive.

30 Apr 2015

Convert PDF Files to Text with OCR

Apr 30, 2015

Google Drive can extract text from regular PDF files as well as scanned PDFs though OCR.

22 Mar 2016

Convert Google Documents and Spreadsheets with Apps Script

Mar 22, 2016

You can easily convert any Google Spreadsheet or Google Document in your Google Drive to other formats like PDF, XLS, etc with Google Apps Script and either email the converted file or save it back to Google Drive.

30 Apr 2015

Publish Google Spreadsheets as JSON with Apps Script

Apr 30, 2015

The previous snippet on getting Spreadsheets as JSON required you to make a sheet public and also publish as HTML before other apps can pull data as JSON from the sheet.

19 Feb 2015

PHP’s print_r() for JavaScript

Feb 19, 2015

PHP offers print_r() and var_dump() methods that can print the values of arrays and objects recursively with values indented so it’s easy to debug code.

19 Feb 2015

Find Matching Rows in Google Spreadsheets

Feb 19, 2015

You have a Google Spreadsheet and you need to programmatically find if a cell with particular value exists in that sheet.

19 Feb 2015

See your Fitbit Data in Google Spreadsheet

Feb 19, 2015

The Google Script will download your Fitbit data via the Fitbit API and insert it into a Google spreadsheet.

18 Feb 2015

How to use cURL with PHP – Basic Example

Feb 18, 2015

cURL is a PHP library and a command line tool (like wget) that helps you send files and also download data over HTTP and FTP.

17 Feb 2015

JavaScript Trim Method

Feb 17, 2015

The trim() methods in JavaScript removes spaces and other whitespace characters from both ends of a string.

30 Apr 2015

How to Merge Multiple Google Documents

Apr 30, 2015

You can use Google Apps Script to merge two or more Google Documents into a single document.

08 Mar 2015

Google URL Shortener with Google Scripts

Mar 8, 2015

You can use Google Apps Script with the Google URL Shortener API to convert any long URL into a short one served through the goo.gl

06 Feb 2015

Google Maps Functions for Google Spreadsheets and Apps Script

Feb 6, 2015

The Maps Service of Google Apps lets you reverse-geocode and geocode postal addresses without using the Google Maps API.

09 Feb 2015

Automatically Unsubscribe from Newsletters in Gmail

Feb 9, 2015

The bulk email messages in Gmail have an “unsubscribe” link that you can click to remove your email address from the mailing list.

04 Feb 2015

Publish Email Messages to Slack with Google Scripts

Feb 4, 2015

You can easily publish important email messages coming into your Gmail to a Slack channel using Google Apps Script.

04 Feb 2015

Converting Excel with Macros to Google Spreadsheets

Feb 4, 2015

One of my recent project involved converting a finance related Microsoft Excel Spreadsheet into a web based Google Spreadsheet that can be accessed from a web browser.

04 Feb 2015

Scrape Yahoo Finance with Google Scripts

Feb 4, 2015

If you know the the stock symbol like MSFT or GOOG, you can get the full name of the corresponding company by scraping the Yahoo Finance website for that symbol.

04 Feb 2015

Get Stock Data from Yahoo Finance in Google Spreadsheets

Feb 4, 2015

Google Finance is no longer integrated with Google Apps Script but you can still use Yahoo Finance with the URLFetch service to bring stock data from the Yahoo website into your Google Spreadsheet.

04 Feb 2015

Edit your Response URL in Google Spreadsheets

Feb 4, 2015

When a user submits a Google Form, the entry is saved as a new row in the Google Spreadsheet that is collecting the responses.

01 Feb 2015

Extract Name and Email Address from Gmail Header

Feb 1, 2015

The Gmail Extractor will soon let you extract both the name and the email address of the sender from the email message.

30 Apr 2015

Send Gmail Drafts containing Inline Images with Google Scripts

Apr 30, 2015

The Gmail Scheduler takes your Gmail drafts and send them at the schedule date and time.

31 Jan 2015

How to Validate Date Input in JavaScript

Jan 31, 2015

A Date instance can be created in JavaScript by passing the date time string as the parameter in yyyy-mm-dd format as in Date(“2015-01-31”).

30 Jan 2015

Merge Multiple Google Spreadsheets into One

Jan 30, 2015

Google Spreadsheets include an import features to help you copy subsheets from another spreadsheet into the currently open sheet.

30 Jan 2015

Connect to Google Cloud SQL from Apps Script

Jan 30, 2015

You can use the JDBC service of Google Apps Script to connect to any MySQL or Google Cloud SQL database.

30 Jan 2015

Get Email Notifications for Edits in Google Spreadsheet

Jan 30, 2015

A client wants to receive email notifications as soon as someone edits a Google Spreadsheet that is shared with a team of people.

10 Sep 2015

Move Files to Another Folder with Google Scripts

Sep 10, 2015

The File or Folder class in Google Scripts offers no direct method to move files from one folder in Google Drive to another.

28 Jan 2015

Duplicate a Sheet in Google Spreadsheets

Jan 28, 2015

You have a master sheet in a Google Spreadsheet and you want to use it as a template.

25 Jan 2015

Google Search Scraper written in Google Scripts

Jan 25, 2015

Google search will block your IP address temporarily if you use a download utility like wget to download search pages for scraping Google.

30 Apr 2015

Save Google PageSpeed Score in Google Sheet

Apr 30, 2015

The Google PageSpeed score helps you understand how fast your website will load on a desktop or mobile phone.

25 Jan 2015

Parse XML Response of Amazon API with Google Scripts

Jan 25, 2015

The Amazon API returns the response in XML format with the ItemAttributes node containing the bulk of the information about the product including the title, author’s name, list price, physical dimensions and so on.

30 Apr 2015

Make your YouTube Playlists Private with Google Scripts

Apr 30, 2015

The Google Script will check the privacy status of each of your YouTube playlists and set the visibility status of the ones that are either public or unlisted to private.

24 Jan 2015

Export Phone Numbers and Profile Pictures from WhatsApp

Jan 24, 2015

The JavaScript bookmarklet for extracting WhatsApp Contacts traverses through the DOM of the WhatsApp Web client and gets the profile picture, the name and the phone number (with the country code) of all your WhatsApp contacts.

22 Jan 2015

Get Book Details from Amazon with Google Apps Script

Jan 22, 2015

Google Apps Script can connect to the Amazon Product Advertising API to get the product details, price and availability of any book (by ISBN) or any other item listed on the Amazon website (by ASIN).

21 Jan 2015

Get your Twitter Followers with Google Script

Jan 21, 2015

The Google Script fetches your Twitter followers and appends the list to a Google Spreadsheet. It fetch the Twitter avatar and add it to the cell using Image formula.

18 Jan 2015

Translate Documents with Google Apps Script

Jan 18, 2015

The LanguageApp service of Apps Script can be used to translate any selected piece of text in a Google Document from one language to another.

18 Jan 2015

Daily Email Summary of your Google Calendar Events

Jan 18, 2015

What’s the agenda for today? The Google Script will send you a daily email digest of all the events that are scheduled for today.

18 Jan 2015

Convert HTML to PDF with Apps Script

Jan 18, 2015

With Google Script, you can convert any HTML content into a PDF file with a few lines of code.

18 Jan 2015

Save Gmail Files to Google Drive

Jan 18, 2015

The Google Script will save file attachments from Gmail threads marked with a particular label to a specific folder in Google Drive.

17 Jan 2015

Blogger to WordPress Redirection

Jan 17, 2015

The Blogger to WordPress tutorial uses this PHP snippet to redirect visitors on the Blogger blog to the corresponding post on the WordPress site.

30 Apr 2015

Send Draft Emails with the Gmail API

Apr 30, 2015

The Gmail API, like the GmailApp service, can help you interact with your Gmail mailbox through Google Apps Script.

13 Jan 2015

HTML Service Examples for Google Scripts

Jan 13, 2015

The HTML Service of Google Apps Scripts lets you serve HTML web pages with standard CSS and client side JavaScript as a web app.

13 Jan 2015

Create RSS Feeds from Amazon Listings

Jan 13, 2015

If an Amazon Category page does not offer RSS feeds, you can use PHP to easily create one.

13 Jan 2015

Web Scraping Amazon with PHP

Jan 13, 2015

There are two ways to get the price of any product listed on the Amazon website.

30 Apr 2015

Convert XML to JSON with Apps Script

Apr 30, 2015

The XMLService class of Google Apps Scripts lets you parse and navigate the nodes of any XML file.

04 Jan 2015

Create the Loading Dots Animation with CSS & Javascript

Jan 4, 2015

If you happen to a click a link pointing to the Apple apps store on your desktop, the browser opens a temporary web page with a message saying “Connecting to the Mac App Store..”

31 Dec 2014

Twitter API – Error Messages

Dec 31, 2014

If your app is posting to Twitter using using the API v1.1, it should be able to handle the following errors: 1.

30 Apr 2015

Generate List of all Files in a Google Drive Folder

Apr 30, 2015

This is like running the `ls` Linux command for listing all the files and their details in a particular Google Drive folder.

18 Dec 2014

Show Trimmed Content in Gmail

Dec 18, 2014

The Gmail Bookmarklet will add a unique string to the email signature to prevent Gmail from trimming the content.