How to Import WordPress Posts from Google Sheets

In this tutorial, we will show you how to import WordPress posts from Google Sheets. Let’s connect our WordPress site to our Google account and import WordPress posts from a Google spreadsheet. With this, we will be able to create new posts or update existing posts from Google Sheets.

Related tutorial:

We are going to use WP Sheet Editor plugin and Google Sheets Sync service.

WP Sheet Editor allows you to view and manage your WordPress posts in an intuitive spreadsheet. You can do advanced searches, edit thousands of posts, export and import posts easily.

Google Sheets Sync is a service provided by WP Sheet Editor. It allows you to export and import content between your WordPress site and your Google Sheets account.

You need to follow these steps to import posts from Google Sheets:

1- Connect your WordPress site to your Google account

After signing up to the Google Sheets Sync service, you’ll get a helper plugin that will allow you to connect your WordPress site to Google Sheets.

You can follow this guide to learn how to do it. We’ll guide you step by step to connect your WordPress site to your Google Sheets account, the Google API, and the WP Sheet Editor API.

2- Prepare the Google Sheet you will import

Note – In order to import a Google Sheets file into WordPress, you will first need to export it, as our service only recognizes files created with the service itself. This is great because we protect your privacy. We do not access other files in your Google account, nor do we store your Google Sheets file information on our servers.

You can follow this tutorial to learn how to export WordPress posts to Google Sheets.

You need to have a Google spreadsheet like this, containing your WordPress posts data:

As you can see, some of our posts contain IDs, but the others do not. The ones with IDs already exist on our site, so we are just going to update them. The ones without IDs do not exist yet, so we are going to create / import them as new posts.

3- Import WordPress posts from Google Sheets

To import your WordPress posts, you need to first open the WordPress posts spreadsheet.

Go to WP Sheet Editor > Edit posts.

Then click on Import.

After opening the Import tool, we need to select the Google Sheets app as the source from which the posts data will be imported.

Then, select the file you want to import in the Google Sheet file field.

Note – If you don’t find the file you want to import, you can click on the refresh button.

Once you have selected the file, click on Next.

Now you need to select which columns you will import into your WordPress site. In this case, we will Import all the columns, but you could manually map specific columns and ignore any column.

Now let’s select how you will import the coupons.

In this step, you can decide if you want to create new items and update existing items, import all rows as new, only create new items, or only update existing items.

Note – If you’re updating existing items, you need to match them using a specific field. We suggest using the ID field.

Click on Next once you’ve selected these values.

Finally, you will see a preview of what the data will look like once the import is complete.

If everything is OK, click on The preview is fine, start import.

As you can see, WP Sheet Editor and Google Sheets Sync allow you to create and update posts from Google Sheets.

You just have to prepare your Google Spreadshet containing the information you are going to import, select the file you are going to import, and start the process.

You can automate post imports from Google Sheets to WordPress.