In some cases, it may be convenient to use a Google Sheets worksheet as a feed into Omnia 2.0. This article explains how to set this up.
Google Sheets has the functionality to publish worksheets to the web as a CSV (Comma-Separated Values) file. A published CSV can be used as import feed in Omnia 2.0.
Step 1: Create a Google spreadsheet in your Google account.
Create the data set that you want to add to Omnia 2.0. Please ensure you have a common denominator so that you can link the data to the right products (read more on linking feeds here).
Step 2: Publish the datasheet to the web
Navigate to File and select "Share > Publish to the web". Please remember that when publishing to the web, an unique URL is generated and the data can be accessed by anyone with that URL.
Select the sheet you want to connect to Omnia 2.0 in the left drop-down menu. Choose "Comma-separated values(.csv)" in the right drop-down menu and click on publish.
You have now received a URL which you can add to Omnia via the regular “add new feed” process (see this article).