This plugin hasn’t been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

GData Importer

Description

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”]

Screenshots

  • Spreadsheet Key
  • Worksheet Name
  • Data in Spreadsheet
  • Imported Data in wordpress

Installation

  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

FAQ

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

Contributors & Developers

“GData Importer” is open source software. The following people have contributed to this plugin.

Contributors

Translate “GData Importer” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

1.0.2

Bug Fixes.
Added Title for Sheets.

1.0.1

Bug Fixes.

1.0.0

Initial Release.