Export and Import JetEngine Post Types with Google Sheets

Post author:Diego Portillo
Post published:October 12, 2023
Post category:Google Sheets Sync / Guides

In this tutorial, we will show you how to export and import JetEngine post types with Google Sheets.

JetEngine is a plugin that allows you to create dynamic content and custom post types for your WordPress site.

In previous tutorials, we have shown you how to:

Here, you’ll see how to connect your WordPress site to your Google Sheets account, and then export and import posts using Google Sheets.

We will use the WP Sheet Editor plugin, which allows you view and manage posts, pages, and custom post types using a spreadsheet.

You can download the plugin here:

Download Posts, Pages, and Custom Post Types Spreadsheet Plugin - or - Check the features

We will also use the Google Sheets Sync service, which allows you to export and import WordPress content with Google Sheets.

You can sign up to the service here:

You need to follow the steps in the sections below in order to export and import JetEngine content with Google Sheets.

1- Set up the Custom Post Type Maker spreadsheet

You can follow this setup guide to generate a spreadsheet bulk editor for any of your post types created with the JetEngine plugin.

In this case, we will export and import a JetEngine post type called “Deals”.

Note → After generating the spreadsheet, come back to this tutorial.

2- Connect WordPress to Google Sheets

When you sign up to the Google Sheets Sync service, you’ll get a helper plugin that allows you to connect your WordPress site to your Google account, the Google API, and the WP Sheet Editor API.

You can follow this set up guide to learn how to connect your WordPress site to your Google Sheets account through WP Sheet Editor.

3- Export from JetEngine to Google Sheets

After connecting your WordPress site to your Google Sheets account, you can proceed to export your JetEngine content to Google Sheets.

Start by opening the Export tool.

You need to select these values when exporting JetEngine post types to Google Sheets:

What columns do you want to export: You can type specific column names, export all active columns, or all columns.
Which rows do you want to export: In this case, we will export all the posts.
What app will you use to edit this file: Select the Google Sheets app.
Name of this export (optional): You can add a name for this export, and the Google Sheets file will inherit this name.
Click on Start new export.

Once your JetEngine content is exported to Google Sheets, you’ll see the View Google Sheet link.

If you click on that link, you’ll open the Google Sheet that has been generated with this export.

4- View and manage JetEngine content in Google Sheets

As you can see in the screenshot below, we have exported the content of our JetEngine post type to Google Sheets.

We can save this Google Sheet as a backup, edit existing post data, or even add new posts to import changes or new posts from Google Sheets to WordPress.

5- Import JetEngine post types from Google Sheets

There are some things you need to keep into account before importing from Google Sheets into WordPress:

To protect your privacy, our Google Sheets Sync service doesn’t read files that have not been created with the service itself.
In other words, the service doesn’t recognize files that were not first exported from WordPress to Google Sheets using the service.
This means that we don’t have any access to other files on your Google account; not even to other Google Sheets files.
Therefore, to import a Google Sheets file, you’ll need to first export the info.
Once you’ve exported it, you can edit existing data or create new data in Google Sheets.

First, open the Import tool.

Second, select the Google Sheets file you want to import.

Just select these values in the Import tool:

Source: Google Sheets
Google Sheet file: Select the file you’ll import here. If you don’t find it, click on “refresh”.
Click on Next.

Third, select the columns you will import from Google Sheets into WordPress.

You can Import all the columns or Select individual columns to import.

Note → If you don’t want to import a specific column, you can select the second option and select “Ignore this column” for every column you don’t want to import.

Fourth, select how you want to import the JetEngine data from Google Sheets.

In this example, we will Create new items and update existing items.

Note → If you select any option to update existing items, you need to match the rows in the Google Sheet with the rows on WordPress by using a specific field as an identifier. In this case, we will use the ID field as an identifier.

Click on Next.

Finally, you will see a preview of the data on the spreadsheet.

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