WP Sync is a very simple plugin for WordPress that helps you to import Google Sheets into individual WP posts. You can use this plugin to import a Goo
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.
No, it doesn't writes the spreadsheet. It is only accessed read only mode (at least for now)
Yes, it is free.