Google Sheets Importer

Overview

Zoey’s internally-created Google Sheets Importer makes it easy to pull documents from Google Sheets on a schedule to add or update products and product data, including the management of inventory, pricing and more.

Features

  • Log-in with Google to connect to your Google Drive account and connect one or more sheets
  • Schedule the import of Products/Product Data – ideal for synchronizing prices, inventory or even adding new products
  • Map column headers to Zoey product attributes
  • Ignore columns that may not be needed in Zoey
  • Set default columns and values for required data that might not be included in your Google sheet.
    Configure scheduling to have syncing occur once or more each day/week or month
  • Error Reporting will email any failed imports to an email address of your choosing
  • Audit Log will show the last 30 imports, any errors/warnings, and let you download the CSV file imported from Google Sheets at that time
  • Test and Manually Run the import anytime from within the Import Manager

Install the Google Sheets Importer

Start by installing the Google Sheets Integration App into Zoey.

Log-in to your Zoey Web Admin, then click: INSTALL ZOEY <> GOOGLE SHEETS IMPORTER