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 sheets
Create PDF For Each Row In Google Spreadsheet
Have you ever come across a situation, where you need to generate PDF for each row in Google Spreadsheet. Imagine below scenarios. You have an online shop, after customer purchases an item you may require to send pre-filled ordered data in a particular template. Schools and Universities send score cards to students where the template …
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 …
Share Portion of a sheet in Google Spreadsheet
Google brings us a collaborative spreadsheet interface(the Google Spreadsheet) with tons of features and sharing options. We can share spreadsheets with somebody, protect individual sheets and publish it to web. Still it is lacking a feature which may be useful for its users i.e. share portion of data from a sheet. It comes handy when …
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 …