In this tutorial, we will show you how to import WooCommerce products from Google Sheets automatically. We will schedule a Google Sheet to be imported at a later date and time, and the automatic import from Google spreadsheets will run in the background.
This means that you just have to connect or sync your WordPress site with your Google account, and you will be able to schedule automatic imports from Google Sheets to WooCommerce / WordPress.
The best thing about the method that we are going to show you is that you do not need browser extensions or run complicated scripts. You can connect your site with your Google account, the Google API and WP Sheet Editor API with a few clicks, without leaving the wp-admin dashboard.
What you need to auto import from Google Sheets
Besides the WooCommerce plugin, you need two more elements to auto import products from Google Sheets.
First, you need the WP Sheet Editor – WooCommerce Products plugin. It allows you to view and manage your products in a spreadsheet, which allows advanced search, bulk edit, export and import.
You can download the plugin here:
Second, you need the Google Sheets Sync service. It allows you to connect your WordPress site to your Google account to export and import content using Google Sheets. It works with all the WP Sheet Editor spreadsheets that run in the backend, so you can automate your WordPress content management with Google Sheets.
You can sign up to the service here:
You can follow this guide to set up the helper plugin you’ll get when you sign up to our Google Sheets Sync service.
Once you have set everything up, you can follow the steps below to schedule automatic imports from Google Sheets to WooCommerce.
1- Prepare the Google Sheet you will import to WooCommerce
The first thing you need is a Google Sheet containing the WooCommerce products you want to import.
At this point, it is necessary to mention that our Google Sheets Sync service only recognizes Google Sheets that have been created with our service.
This means that in order to import your Google Sheet, you must first export at least one product to Google Sheets, and then you need to add the information to that Google Sheet.
You can follow this tutorial to learn how to export WooCommerce products directly to Google Sheets.
After you add the information you want to import into WooCommerce, you can proceed to schedule an automatic export by following the steps in the next section.
2- Schedule an automatic import from Google Sheets to WooCommerce
Go to WP Sheet Editor > Edit products to view and manage your WooCommerce products in the spreadsheet.
Once you’re in the products spreadsheet, open the Import tool.
Now you need to select these values to schedule an automatic import from Google Sheets into WooCommerce:
- Tick the Run this in the future checkbox.
- Select the date and time: Use this field to select when you want this import to run automatically.
- Notify this email address when the process finishes: You’ll get an email notifying you that the process has been completed.
- Select the Run once option.
- Name: Add a name for this scheduled task.
- Source: Google Sheets
- Google Sheet file: You can select the file here. If you can’t find it, you can refresh the list.
- Click on Next.
After that you need to select which columns you want to import.
You can Import all the columns or Select individual columns to import.
If you select the Select individual columns to import option, you will need to map the columns from the CSV file with the fields on WordPress.
Now click on Next.
Now you need to select how you want to import the information by selecting these values:
- Do you want to update or create items: In this dropdown field, you have four options:
- Create new items and update existing items
- Import all the rows as new
- Only create new items, ignore existing items
- Update existing items, ignore new items
- If you select any option that requires to “update existing items”, you will need to match the Google Sheet columns with the fields in WordPress. In this case, we are going to synchronize the information using the product IDs.
- Click on Next.
Finally, you’ll see a preview of what the data will look like in the spreadsheet when imported into WordPress.
If everything is OK, you can click on The preview is fine, start import to schedule this automatic import from Google Sheets into WooCommerce.
Now you can click on the View scheduled imports link.
If you click on it, you will open the Scheduled imports list, where the new scheduled import will appear.
Read this guide to learn how you can take complete control on the Scheduled tasks popup.
When the scheduled import is complete, you will receive an email at the email address you entered.
This email will contain the information of the scheduled task and a link to download the log file of this task so that you can see in detail what has happened in each step of the process.
Sync WooCommerce and Google Sheets
You can automate your WooCommerce products with Google Sheets exports and imports:
- Immediate export
- Scheduled export
- Recurring exports
- Real-time bidirectional sync
- Immediate import
- Recurring import
- Real-time import
With our Google Sheets Sync service, you can automate the management of your WooCommerce products with Google Sheets. You can export and import immediately, or you can schedule automatic imports to run once or periodically. Also, you can sync your WooCommerce products with Google Sheets in real time.
This service works with all WP Sheet Editor plugin spreadsheets (except the frontend spreadsheet editor), and recognizes custom fields (ACF, PODs, etc.) and multilanguage plugins (WPML, Polylang, etc.).