You can create data sources to expose data in Google spreadsheets as services using the WSO2 Data Services Server. To begin, follow the steps in Creating Data Sources. When you select Google Spreadsheet as the data source type at the time a data source is created, the Google-specific options appear. For example: Google Spreadsheet datasources allow you to create a data service using a Google spreadsheet as the data storage type.
You can get the Add New Datasource screen shown below on the management console by executing steps 1 to 3 in creating a data service. Then, select Google Spreadsheet as the Datasource Type. It opens the spreadsheet-specific options 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.
...