driveandsheetsapi With this script user can load all his sheets from drive and then can load data from the 3 ranges(columns) for each sheet into webpage. Pls add your client ID and API Key. and modify the ranges as per your need.