Este plugin no se ha probado con las últimas 3 versiones mayores de WordPress. Puede que ya no tenga soporte ni lo mantenga nadie, o puede que tenga problemas de compatibilidad cuando se usa con las versiones más recientes de WordPress.


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


  1. Upload wpsync folder to /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ menu in WordPress
  3. Go to WPSync settings page and configure your Spreadsheet key

In order to use your Spreadsheet created in Google Docs, you need to:

  1. Create a new spreadsheet in Google Docs
  2. 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)
  3. Publish your spreadsheet and get the spreadsheet KEY from the shared URL (use the share button in Google Spreadsheet)
  4. Copy the KEY and paste it in the WPSync settings page.


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.


3 de septiembre de 2016 1 respuesta
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,,,
Leer todas las 10 reseñas

Colaboradores y desarrolladores

«Magn WPSync» es un software de código abierto. Las siguientes personas han colaborado con este plugin.


Traduce «Magn WPSync» a tu idioma.

¿Interesado en el desarrollo?

Revisa el código , echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.

Registro de cambios


  • 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