Google Spreadsheets

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 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.

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.

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.

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.

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.

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 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.

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.

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.

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.

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

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.

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.

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.

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.

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

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.

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.

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.

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

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.

Nov 1, 2018

Jun 11, 2017

Apr 23, 2017

Apr 20, 2017

Sep 6, 2016

Jul 21, 2016

Jun 5, 2016

Mar 9, 2016

Feb 8, 2016

Jul 11, 2019

Jan 4, 2016

Dec 18, 2015

Dec 12, 2015

Dec 10, 2015

Dec 5, 2015

Oct 25, 2015

Jun 26, 2015

Jun 4, 2015

May 26, 2015

Jun 15, 2015

May 5, 2015

Apr 30, 2015

Mar 22, 2016

Apr 30, 2015

Feb 19, 2015

Site Search

About The Author

Top Lists