Importing files from Google Sheets into Magento

From XTENTO Support Wiki
Jump to: navigation, search

Using one of our import extensions for Magento 1 / 2 and want to import a sheet (containing information such as stock levels, pricing or tracking data) from Google Sheets into Magento automatically? It couldn't be easier!

First of all, you will need to open Google Sheets and get the "link" to your sheet. To do so:

Now let's set up the import into Magento. Let's take our Stock Import extension as an example, the same principle applies for all our import extensions.

That's it! You can now associate this import source to one of your import profiles, and whenever the import profile runs, it will fetch the file from Dropbox. Set up the import profile as a "CSV" import profile, as Google Sheets will return your sheet as a CSV file.

Personal tools
Namespaces
Variants
Actions
General Information
Magento 2 Guides
Magento 2 Extensions
Magento 1 Guides
Magento 1 Extensions
Magento Integration Suite
Product Feed Guides
Toolbox