...
You can use either private or public Google spread sheets as the data source. If the spread sheet is Private, you will be prompted to enter the user name and the password. For example,
Click Save. You have added a Data Source to your Web Service. Click Next to proceed.
...