Javascript, Software Architecture expert required

I need a javascript function that extracts data from google spreadsheets. ([login to view URL]) I need a function(paramater): parameter: array of querys query = {page: string (default:1), ranges: ['A2:C2','D7:D14']}; //if ranges is undefined it returns the whole page. that returns a meaningful JSON for allowing the data display. auth credentials must be cleary apart for easy editing.