You can create datasources to expose data in Google spreadsheets as services using the WSO2 Data Services Server. To begin, follow follow the steps in Creating Datasourcesfrom 1 to 3 in creating a data service using various data sources. When you select get to the Add New Data Source screen, select Google Spreadsheet as as the datasource type at the time a datasource is created, the data source type. The Google-specific options appear. For example: will now be available for editing as shown below.
The example above uses a private Google spreadsheet. When you select Visibility as private, you are asked to provide credentials. You can also tick the Use as a Secret Alias option to specify an alias name for the password instead of giving the actual password. For more information, see Securing Passwords.
...