You can create your online database application in Zoho Creator by importing data from Google Spreadsheets and Google Forms. The data submitted through Google Forms are stored in excel files. For example, the data submitted in the Google Form named "Tasks" is stored in excel format as shown in the screen-shot below:
Now let us create an application in Zoho Creator by importing the Google spreadsheet.
1. Click on the Create New application button in your Zoho Creator Home page and select the Import File -> Google Docs option. Specify the Application Name in the Application Name text box. Click on the Browse From Google Docs option. The Google spreadsheets and Google Forms created in your Google Docs account will be listed in Import from Google list box. Select the file to be imported to Zoho Creator and click on Create button, as shown in the screen-shot below.
2. The Importing Data dialog will display the data in the following format, as shown in the screen-shot below.
3. Click Finish to create the application with data. The application "Zoho Tasks" is created in Zoho Creator with the "Zoho Tasks" form and the "Zoho Tasks form" view, as shown in the screen-shot given below.
Zoho Creator Tasks Form
Zoho Creator Tasks View