How to Export/Import Products, Customers, Orders or Any Other Data from Adobe (Magento) into the File on Google Drive

You might use Google Drive for multiple business tasks, including exporting and importing Adobe/Magento products, customers, orders data. Whether it is a one-time task or scheduled synchronization is required, you can use Store Manager for Adobe/Magento to perform this task.

Depending on your needs, you can either:

• export and import Magento data (products, categories, orders) from/to Google Sheets;
• export product feed data to Google Drive to sync with Google Shopping to update it on a schedule automatically;
• or export products, customers, and orders as a CSV, XML, Excel, or any other file into Google Drive. We’ll review this method in this article.

All of the above options allow you to export data one time or on a schedule, share the file or folder with required services or people or achieve any other goals. If you need assistance with choosing which option works the best for you, contact us for assistance.

In this article, we’ll review how to export/import products, customers, orders or any other data from Adobe/Magento into the file on Google Drive (CSV, XML, Excel, etc) with Store Manager software. Follow a few steps to proceed.

First things first, install Google Drive app on your desktop. You can download it here https://www.google.com/drive/download/.

Follow the on-screen prompts to install the app. Go to the “Downloads” folder and open GoogleDriveSetup.exe on your PC. Based on your preference, choose whether to add shortcuts and proceed with the “Install” option.

After the app is installed, press “Launch” and then “Get started”.

At the next step, you’ll be offered to sign in with the Google Account you would like to work with further.

After selecting the account, complete the login.

Following a few “next” steps, choose which folders to sync from your computer to Google Drive or skip it if you’d like to get back to it later.

Once installation is complete, press “Open Drive” option, the “Google Drive” folder will be streamed on your computer, creating a virtual disc.

You can update your preferences and choose to mirror or stream My Drive after installation.

Store Manager’s export and import functionality further works with the local virtual disc, which is synchronized to Google Drive based on your settings.

Now, let’s get down to the Adobe/Magento to Google Drive import and export itself.

1. Open or install the Store Manager software, and connect it to your Adobe/Magento store. You can download a free trial to test the functionality free for 2 weeks. Free assistance is available for installation and connection configuration.
2. Run the Export/Import Wizard from the toolbar or context menu, and hit “Export” or “Import”.



3. At the step of “Select export target”, choose the “Local file” radio button.

In case of import, choose the file located in Google Drive offline folder.

4. Specify the file name on the Google Drive where products will be exported to, or imported from and hit “Next” to proceed.



5. Proceed with the export or import configuration as usual.

You can check detailed instructions on export configurations here: Adobe/Magento Product Export.

You can check detailed instructions on import configurations here: Adobe/Magento Product Import.

6. Hit “Import” or “Export” to complete the task.

A .csv file will be saved to your Google Drive if you perform an export procedure, you can check Google Drive once it has synchronized. Or the import procedure is complete if you have performed the import procedure from the file on Google Drive.

To convert the file into Google Sheets format, use this guide https://developers.google.com/apps-script/samples/automations/import-csv-sheets/.

Disclaimer

Since Google updated its API verification process in 2024, all software developers must undergo an annual security assessment, validated by a CASA authorized lab, which involves a significant cost. This includes local client applications and Google Workspace addons.

Since the Store Manager to Google Sheets Integration requires Level 3 access, we must complete this costly security assessment annually. Unfortunately, this requirement conflicts with our pricing model, which is a one-time payment for lifetime usage.

Related Articles:

Why Products Are Not Showing Up After Magento 2 Import?

Reasons of missing products after Magento import and their solutions. Read More...

How to Import Categories to Magento 2

Detailed guide on Magento 2 category import withh CSV sample. Read More...

How Import Configurable Products to Magento 2

Learn how to create configurable products / update them and assign existing simple products to configurable. Read More...

How to Import Product Images to Magento 2

Images import CSV sample and instructions on import of images from externatl URLs or local server. Read More...