WP Sync is a simple plugin that helps you to import Google Spreadsheet rows into WP posts. This plugin is useful for example if you want to import lot of rows from a spreadsheet into separate posts and it is intended to be used for those who need a simple way to enter blog posts and don’t like to use the Quick Post feature at WordPress.
Instead, you can just write your post drafts into a spreadsheet and configure the plugin to synchronize your rows with WordPress.
I coded this plugin for my personal use but after getting some user’s feedback I decided to publish it on the WP plugin’s directory. You can use this plugin to import a Google Spreadsheet as individual blog posts. The plugin also will help you to import custom post types for example if you are preparing a business directory or event website.
What you can expect from this plugin:
- Helps you importing rows from a Google Spreadsheet into individual posts in WordPress.
- Use the Google Spreadsheet to enter ideas and post drafts, for example if you are developing domain names with WordPress or niche websites, but also useful for directories (ie: with local info, phone numbers, custom fields, etc.)
- Import spreadsheet rows as individual posts or custom post types.
- Support custom fields and taxonomies (categories, tags, etc.)
What you shouldn’t expect from this plugin (at least in the initial releases):
- In the initial version the utility works from Google Spreadsheets into WordPress but not viceversa. We’ll eventually add the opposite direction soon.
- This version doesn’t writes back any change on the Google Spreadsheet so the Spreadsheet is only used as read only.
- Google Spreadsheets doesn’t support rich text format, so if you need HTML for your content you can do that by using HTML tags in the cells
Nothing here yet
Markdown uses email style notation for blockquotes and I’ve been told:
Asterisks for emphasis. Double it up for strong.
<?php code(); // goes in backticks ?>
- Activate the plugin through the ‘Plugins’ menu in WordPress
- Go to WPSync settings page and configure your Spreadsheet key
In order to use your Spreadsheet created in Google Docs, you need to:
- Create a new spreadsheet in Google Docs
- Create a few mandatory fields (column names): id, post_title, post_content (see the Plugin Settings page for more info and to find a template)
- Publish your spreadsheet and get the spreadsheet KEY from the shared URL (use the share button in Google Spreadsheet)
- Copy the KEY and paste it in the WPSync settings page.
- Plugin is not working, nothing is synchronized. What to do next?
Google Sheets have changed lot of things since the first version of this plugin was developed. Even the product name was changed
and renamed to Google Sheets. However, it is possible to make the plugin work and here are a few things you can check:
1.1. Go to the spreadsheet in Google Sheets that you want to import into WordPress and then go to File -> Publish option.
1.2. Click Publish Entire Document (or any particular sheet).
1.3. Click Start Publishing button under « Published content & settings » section. Make sure Automatically republish when changes are made is checked.
1.4. Copy the key and paste it in the WP Magn Sync plugin settings page. Now click Preview and see if the rows are shown in the screen.
Another reason that could be preventing the plugin to work is if you are using custom post types. If you are using the column post_type in
the spreadsheet, make sure the post_type is registered in your WordPress installation. The plugin uses get_post_types function in WP to get
a list of post types registered.
- Does the plugin overwrites the spreadsheet?
No, it doesn’t writes the spreadsheet. It is only accessed read only mode (at least for now)
- Is this plugin free?
Yes, it is free.
Contributors & Developers
“Magn WPSync” is open source software. The following people have contributed to this plugin.Contributors
- Changed query to include registered post types instead of ‘any’
- Small bug fixes
- Fix the trim bug in the list of custom values to update
- Major upgrade to support new Google Docs API
- Now the required fields are id, post_title, post_content
- Custom post types and taxonomies are supported
- Update from spreadsheet is supported