Magn WPSync

Description

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

Link to Magn and author’s profile Julian Magnone

Nothing here yet

Here’s a link to WordPress and one to Markdown’s Syntax Documentation.
Titles are optional, naturally.

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 ?>

FAQ

Plugin is not working, nothing is synchronized. What to do next?
  1. 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.

  2. 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.

Reviews

does not work as of now.

orangecopper

the plugin does not work.
and regarding the "key" access. theres no proper documentation.
I wished this works with the current wp version., please clarify why not.
thanks again for the idea and efforts,,,

Read all 10 reviews

Changelog

1.0.10

  • Changed query to include registered post types instead of ‘any’
  • Small bug fixes

1.0.7

  • Fix the trim bug in the list of custom values to update

1.0.6

  • 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

Contributors & Developers

Magn WPSync is open source software. The following people have contributed to this plugin.

Contributors

Translate Magn WPSync into your language.

Interested in development?

Browse the code or subscribe to the development log by RSS.