WP Plugin Which Creates Posts Everytime Lines Are Added to Google Spreadsheet

One of the things which I’ve developed recently and is in active use on a couple websites at the moment is a WordPress plugin which will make posts out of lines in a spreadsheet stored on Google Drive. Doesn’t sound too impressive? What if I told you that the plugin not only handles multiple sheets, it allows the user to create headings at the top of their spreadsheet which can be used as variables in a template for each post, each sheet and template can be updated at different intervals and the plugin will even remotely fetch featured images automatically if told to use one of the fields as an image. The field to store as featured image must be a url and the plugin will download and store the image as an attachment to the new post.

One of the things which I’ve developed recently and is in active use on a couple websites at the moment is a WordPress plugin which will make posts out of lines in a spreadsheet stored on Google Drive. Doesn’t sound too impressive? What if I told you that the plugin not only handles multiple sheets, it allows the user to create headings at the top of their spreadsheet which can be used as variables in a template for each post, each sheet and template can be updated at different intervals and the plugin will even remotely fetch featured images automatically if told to use one of the fields as an image. The field to store as featured image must be a url and the plugin will download and store the image as an attachment to the new post.

I’ve included some images of the plugin interface. It is still in testing mode but seems to be working well. It works awesome coupled with something like IFTTT (If This Then That) which can add lines to the spreadsheet in response to actions you do around the web such as “like” a song on Soundcloud, “favorite” a video on YouTube, and the plugin will check independently to see if new lines were added to a handful of spreadsheets on your Google Drive at regular intervals and update your website accordingly.

So, the plugin has two methods by which it can grab the spreadsheets. The first is by using API credentials from your Google account to give the plugin permission to check and download the sheets on its own. This is the best option but at the moment it only works in versions of PHP >= 5.4.0 because of limitations of the Google API PHP Client. The other option which still works as well but hasn’t been proven yet over longer periods of time is to set the plugin to download the spreadsheet from a sheet which has been published to the web as a url which is very easy enough to accomplish from the menu bar of Google Sheets. This is a good option if you don’t own the sheet or if you don’t know how to get an API key for Google Drive. (I began making a video to demo this).

My GDrive to Posts plugin UI. Variables from the sheet are shown so that the author knows how to template in different columns of the sheet as variables.

So this plugin will be up and available for download very shortly. I might not even have to do much more work to it but I would like to make sure that the plugin doesn’t have any oversights before I do proceed to release to the public. When it is released the plugin will be free because that’s just the kind of guy that I am.