It’s been fun working with Google Spreadsheet. We have already published a lot of scripts, tools using Google Sheets and now let’s go beyond it. How about playing games, isn’t it crazy. Of course we can’t expect ‘NFS’ or ‘Clash of Clans’ in a browser and moreover a sheet is not meant for that. But …
Category: Google Apps Script
Fetch Data from MYSQL to Google Spreadsheet
MYSQL is the most popular RDBMS. Also it is open-source and is being used by many tech giants like Google and Facebook. Today in this article we will see how to connect and fetch data from MYSQL to Google Spreadsheet. This is possible in Google Apps Script with JDBC connection. Just put the query in …
Create Form to Upload Files in Google Drive
Today Google form is the most widely used web form service used for many purposes. Some of its attractive features include intuitive drag and drop interface, quick integration with Google Sheets and not to mention add-ons which even enhance its capability. Despite all these features, it misses an important one that is uploading files or …
Create a Countdown Timer in Google Spreadsheet
Whether it may be countdown for Christmas or time elapsed since we started something, we need some sort of counters. Today in this article we will see how to display countdown and countup timer in Google Spreadsheet. We will try to keep it as simple as possible. No script, just be using formula we will try …
Bulk URL Shortener with goo.gl and Google Spreadsheet
Goo.gl is one of the most used service to shorten long URLs provided by Google. But this service does not support shortening multiple urls at once. You have to short one url at a time. Sometimes for marketing and sales, you may need to shorten bulk URLs. There are APIs available for Goo.gl which you …