How to import a product feed into Connecteed starting from a Google Sheet

How to import a product feed into Connecteed starting from a Google Sheet

How to import a product feed into Connecteed starting from a Google Sheet

Importing from Google Docs is simple and requires the indication, in the import process, of the public link of a file present on your drive, or on a drive shared with you by other Google users.

Important: the link to provide to Connecteed in the import configuration panel is not the link with which you access the modification and reading of the file on the Google drive.

To allow Connecteed, as well as any external user (not logged in and without access to Google), to read your Google Sheet, it is therefore necessary to first configure the Google Sheet so that it is readable from outside.

Publishing the sheet is simple and is carried out in the following way.

  • Accessing the worksheet

  • Access the "File" menu => "Share" => "Publish on the web"


In the dialog box that opens once this option has been selected, it will be necessary to configure the "link" and "embed" parameters as shown in the following screenshot, and verify that the status is "Published" as can be seen from the status at the bottom of the image. You can stop publication at any time with the same procedure with which you made the document public.

The link you will need to provide to Connecteed is the one that starts with docs.google.com/sptreadsheets/ and which is clearly seen in the center of the panel shown by Google Docs.


DOCS

DOCS

DOCS