Month: March 2016
Two Way Synchronization between Google Spreadsheet and AWS RDS using Google Apps Script
Two Way Synchronization between Google Spreadsheet and AWS RDS using Google Apps Script Google Spreadsheet can be a very nifty tool to satisfy dynamic data storage needs for any small to medium data analytics projects. Using Google Apps Script, Google Spreadsheet can fetch data from any RESTful API and act as an easily editable data source. Google Spreadsheet can be directly used as a data source to most of the major analytical dashboard platforms like Tableau as well as operational dashboard platforms like Klipfolio. However, connectivity from Google Spreadsheet to Tableau is not perfectly stable yet and may run into issues on Tableau Server. One way of getting a more robust method of connectivity from Tableau to Google Spreadsheet…
