Title: GSheet For Woo Importer
Author: OlegApanovich
Published: <strong>25.11.2019</strong>
Last modified: 23.4.2026

---

Hae lisäosia

![](https://s.w.org/plugins/geopattern-icon/import-products-from-gsheet-for-woo-
importer.svg)

# GSheet For Woo Importer

 [OlegApanovich](https://profiles.wordpress.org/mrdollar4444/)

[Lataa](https://downloads.wordpress.org/plugin/import-products-from-gsheet-for-woo-importer.2.4.1.zip)

 * [Tiedot](https://fi.wordpress.org/plugins/import-products-from-gsheet-for-woo-importer/#description)
 * [Arvostelut](https://fi.wordpress.org/plugins/import-products-from-gsheet-for-woo-importer/#reviews)
 *  [Asennus](https://fi.wordpress.org/plugins/import-products-from-gsheet-for-woo-importer/#installation)
 * [Kehitys](https://fi.wordpress.org/plugins/import-products-from-gsheet-for-woo-importer/#developers)

 [Tuki](https://wordpress.org/support/plugin/import-products-from-gsheet-for-woo-importer/)

## Kuvaus

This is a wordpress plugin that extends standard woocommerce import products functionality
and lets you import, not only from a local file, but also from your google sheet
file, which you store on your google drive and can be edited by any member of your
store team.

Standard woocommerce import, which was introduced by woocommerce team since version
3.1, became a greater plugin feature that lets you not use additional plugins and
extensions for product import processes. However, if it’s a pain every time when
you’re loading csv import files from your local machine, then this plugin is a great
choice that lets you not do it anymore. Just set it once, and in the future you 
will only have to press the button ”Import” as usual. The plugin itself will pull
the new data from the specified google sheet table.

Full instruction about plugin setup options you can find on [our github plugin page](https://github.com/OlegApanovich/import-products-from-gsheet-for-woo-importer).

## Kuvankaappaukset

[[

[[

## Asennus

 1. Upload the plugin folder to the ‘/wp-content/plugins/’ directory
 2. Activate the Woocommerce Import Products Google Sheet plugin through the ‘Plugins’
    menu in WordPress
 3. Go to Woocommerce Import Products Google Sheet Settings menu to connect your Google
    sheet and woocommerce import.
 4. Full instruction about plugin options you can find on [our github plugin page](https://github.com/OlegApanovich/import-products-from-gsheet-for-woo-importer)

## UKK

### Where I can get ”Google drive API client_secret json” for a plugin settings

Instructions about plugin options you can find on [our github plugin page](https://github.com/OlegApanovich/import-products-from-gsheet-for-woo-importer).

## Arvostelut

![](https://secure.gravatar.com/avatar/747eb960587e5483b8a3210e41deb44add9780055c3cc371b7b1b38968a2d41e?
s=60&d=retro&r=g)

### 󠀁[Great plugin](https://wordpress.org/support/topic/great-plugin-39989/)󠁿

 [Nikita Hlopov](https://profiles.wordpress.org/nikitahl/) 14.1.2025

Works awesome.

![](https://secure.gravatar.com/avatar/d0bc63379ffa773a5d0254c3070e41d40a4963c7d7f58e072306403134ef8635?
s=60&d=retro&r=g)

### 󠀁[Works Amazingly](https://wordpress.org/support/topic/works-amazingly-11/)󠁿

 [thisisdamian](https://profiles.wordpress.org/thisisdamian/) 4.7.2024

Was having a issue with the new excel update and needed to upload a ton of products,
this worked as it said it would, very happy from the start.Thank you, please keep
this going!

![](https://secure.gravatar.com/avatar/c9ea5c6ac4e5f1c88059f35cba60573b7b4e7ce5d8acf6a0efd6ab445eaf0109?
s=60&d=retro&r=g)

### 󠀁[Great plugin, works as it should!](https://wordpress.org/support/topic/great-plugin-works-as-it-should-2/)󠁿

 [adryyy](https://profiles.wordpress.org/adryyy/) 30.8.2023 1 reply

This is a great plugin, and it does what it said! Set-up is so easy comparing to
other similar plugins from the market. It works by converting the first sheet of
a Google Sheet into CSV then pass it to the default WooCommerce product importer,
making the import smooth and the use of the official importer is a great idea, as
it will be always the most updated way to import products. What I would like from
the further releases: Option to automatically delete the CSV after the import is
finished, as it will add a few files to the Media Gallery; Automatically product
import cron, daily, hourly, etc. Export products from WooCommerce to Google Sheets
using like it does when importing, only that when you export to put CSV data automatically
into the selected Google Sheet Automatically product export cron, daily, hourly,
etc. Ideally would be to support multiple Google Sheets, as it can differ from use-
case to use-case, for example I would like to have a category of products, let's
say clothes, permanently synced with Google Sheet in an hourly basis, both directions,
and also would like to manually import new products from another Google Sheet.

![](https://secure.gravatar.com/avatar/6dda58aff0a8e4adcdb0786ba8a938aad0c094de295d0a8f07da9b36dd3904c0?
s=60&d=retro&r=g)

### 󠀁[Works like a charm!](https://wordpress.org/support/topic/works-like-a-charm-1964/)󠁿

 [Leafer Design](https://profiles.wordpress.org/leaferdesign/) 12.8.2021

Connecting to the Google Drive API to import a spreadsheet of all product information
is so much faster than updating them one-by-one on WordPress. This allows a quick
connection to your Google account and product spreadsheet. The only error I've encountered
was choosing to import products by both ID and SKU at the same time (just choose
one).

![](https://secure.gravatar.com/avatar/3d1df11cda50062151b825dc756e86485d8a06e27f1fbdbcda461c337d99958d?
s=60&d=retro&r=g)

### 󠀁[Works perfect!](https://wordpress.org/support/topic/works-perfect-757/)󠁿

 [F. Sahin](https://profiles.wordpress.org/catidirnet/) 26.2.2020

Hello, I tried various plugins for bulk edit and import Woocommerce products and
only this one worked perfect. Google Sheets can import properly .csv file exported
from Woocommerce products page. After edit table, you can import and update products
with this plugin. You can match fields while import, so i think this way will work
for other e-commerce softwares's product table files. Oleg Apanovich, thank you 
so much.

![](https://secure.gravatar.com/avatar/09aa2590b3f4abd9c533ff75dfe5ab5d3e7178a32328c85d627a5d28f60aa687?
s=60&d=retro&r=g)

### 󠀁[Simple & nice plugin](https://wordpress.org/support/topic/simple-nice-plugin-3/)󠁿

 [veselect](https://profiles.wordpress.org/veselect/) 11.12.2019

This is a good plugin, simple and usable… will help you keep a Google Sheet to update
your products, you can share that sheet and keep an online inventory and import 
it into WooCommerce anytime.

 [ Lue kaikki 6 arvostelua. ](https://wordpress.org/support/plugin/import-products-from-gsheet-for-woo-importer/reviews/)

## Avustajat & Kehittäjät

“GSheet For Woo Importer” perustuu avoimeen lähdekoodiin. Seuraavat henkilöt ovat
osallistuneet tämän lisäosan kehittämiseen.

Avustajat

 *   [ OlegApanovich ](https://profiles.wordpress.org/mrdollar4444/)

“GSheet For Woo Importer” has been translated into 1 locale. Kiitoksia [kääntäjille](https://translate.wordpress.org/projects/wp-plugins/import-products-from-gsheet-for-woo-importer/contributors)
heidän työstään.

[Käännä “GSheet For Woo Importer” omalle kielellesi.](https://translate.wordpress.org/projects/wp-plugins/import-products-from-gsheet-for-woo-importer)

### Oletko kiinnostunut kehitystyöstä?

[Browse the code](https://plugins.trac.wordpress.org/browser/import-products-from-gsheet-for-woo-importer/),
check out the [SVN repository](https://plugins.svn.wordpress.org/import-products-from-gsheet-for-woo-importer/),
or subscribe to the [development log](https://plugins.trac.wordpress.org/log/import-products-from-gsheet-for-woo-importer/)
by [RSS](https://plugins.trac.wordpress.org/log/import-products-from-gsheet-for-woo-importer/?limit=100&mode=stop_on_copy&format=rss).

## Muutosloki

#### 2.4.0

 * Dev – Add support for Microsoft Excel native formats.
 * Dev – Add redirect to plugin settings after plugin activation.
 * Dev – Bump min PHP version to 8.1 and min WordPress version to 5.9.
 * Fix – Remove ’One Click Auto Connect’ due to Google API new payment requirements
   that do not correspond to nonprofit open source projects.
 * Fix – PHP fatal error when WooCommerce is not active.

#### 2.3.1

 * Fix – Php warnings related to translation.
 * Fix – Php fatal error with deleted woocommerce.

#### 2.3

 * Fix – ’One Click Auto Connect’ Google API connect method and remove deprecated
   oob link functionality.

#### 2.2.0

 * Fix – fix error with csv get functinality.

#### 2.1.1

 * Fix – move plugin functionality to new Google v4 API

#### 2.0.3

 * Fix – Php warnings with not stable google API library.

#### 2.0.2

 * Dev – Add new google API connection ”Auth Code” method.
 * Dev – Add notice on product page if plugin setting do not set completely.
 * Dev – Add new system error notification.

#### 1.1.5

 * Fix – Fix PHP fatal error on a log activity #9
 * Fix – Fix PHP warnings on setting plugin page.
 * Fix – Fix link to setting page.
 * Dev – Add WP v-5.6 and PHP v-8 compatibility.

#### 1.0

 * Initial release.

## Metatiedot

 *  Version **2.4.1**
 *  Last updated **6 kuukautta sitten**
 *  Active installations **50+**
 *  WordPress version ** 5.9 or higher **
 *  Tested up to **6.9.10**
 *  PHP version ** 8.1 or higher **
 *  Languages
 * [Dutch](https://nl.wordpress.org/plugins/import-products-from-gsheet-for-woo-importer/)
   ja [English (US)](https://wordpress.org/plugins/import-products-from-gsheet-for-woo-importer/).
 *  [Translate into your language](https://translate.wordpress.org/projects/wp-plugins/import-products-from-gsheet-for-woo-importer)
 * Tags
 * [google sheet](https://fi.wordpress.org/plugins/tags/google-sheet/)[importer](https://fi.wordpress.org/plugins/tags/importer/)
   [woocommerce](https://fi.wordpress.org/plugins/tags/woocommerce/)
 *  [Edistynyt näkymä](https://fi.wordpress.org/plugins/import-products-from-gsheet-for-woo-importer/advanced/)

## Arvosanat

 5 out of 5 stars.

 *  [  6 5-star reviews     ](https://wordpress.org/support/plugin/import-products-from-gsheet-for-woo-importer/reviews/?filter=5)
 *  [  0 4-star reviews     ](https://wordpress.org/support/plugin/import-products-from-gsheet-for-woo-importer/reviews/?filter=4)
 *  [  0 3-star reviews     ](https://wordpress.org/support/plugin/import-products-from-gsheet-for-woo-importer/reviews/?filter=3)
 *  [  0 2-star reviews     ](https://wordpress.org/support/plugin/import-products-from-gsheet-for-woo-importer/reviews/?filter=2)
 *  [  0 1-star reviews     ](https://wordpress.org/support/plugin/import-products-from-gsheet-for-woo-importer/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/import-products-from-gsheet-for-woo-importer/reviews/#new-post)

[See all reviews](https://wordpress.org/support/plugin/import-products-from-gsheet-for-woo-importer/reviews/)

## Avustajat

 *   [ OlegApanovich ](https://profiles.wordpress.org/mrdollar4444/)

## Tuki

Onko sinulla jotain sanottavaa? Tarvitsetko apua?

 [Tukifoorumi](https://wordpress.org/support/plugin/import-products-from-gsheet-for-woo-importer/)

## Lahjoita

Haluatko tukea tämän lisäosan kehitystä?

 [ Tue tämän lisäosan tekijöitä ](https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=K9NTJ6E2RQN3A&source=url)