GData Importer

A wordpress plugin which imports Google Spreadsheet Data into the WordPress Page/Post using shortcode.
You have to provide Sheet Key, Worksheet Name, Username and Password in shortcode.

Usage:
[gdata_import key=”spreadsheet_key” worksheet=”worksheet_name” user=”your_username” pass=”your_password”]

Example:
[gdata_import key=”0AqJJ6fnIoHPYdE1qTFF0OWtFX2xfRHU1OC1oY0JIeVV”
worksheet=”Sheet1″ user=”your_username” pass=”your_password”]

1. Upload gdata-importer to the /wp-content/plugins/ directory
2. Activate the plugin through the ‘Plugins’ menu in WordPress
3. Place shortcode [gdata_import key=”spreadsheet_key”
   worksheet=”worksheet_name” user=”yourusername” pass=”yourpassword”] in your post

Where to get spreadsheet key?

You can get the spreadsheet key from the Spreadsheet URL.

Example Spreadsheet URL: https://docs.google.com/spreadsheet/ccc?key=0AqJJ6fnIoHPYdE1qTFF0OWtFX2xfRHU1OC1oY0JIeVV#gid=0

Then your Spreadsheet key is: 0AqJJ6fnIoHPYdE1qTFF0OWtFX2xfRHU1OC1oY0JIeVV

Where to get worksheet parameter?

The worksheet parameter refers to the worksheet name.

Example: Sheet1

I am getting error “ERROR: Unable to Connect to ssl://docs.google.com:443. Error #110: Connection timed out”

Some hosting providers do not allow https connections to be made from their servers, Contact your Hosting to assist & solve the problem.

Refer: https://developers.google.com/gdata/articles/php_client_lib#appendix_issues_proxy

1. 

   Spreadsheet Key

2. 

   Worksheet Name

3. 

   Data in Spreadsheet

4. 

   Imported Data in wordpress

1.0.2

Bug Fixes.
Added Title for Sheets.

1.0.1

Bug Fixes.

1.0.0

Initial Release.