In some cases, it can be convenient to use a Google sheet as a feed instead of a CSV file or an XML file.
If you would like to do so, this can be connected to Omnia easily.
Step 1: Create a Google spreadsheet in your Google drive.
Create the columns you would like to add to Omnia. Make sure that, if you would like to link this feed to one of your current feeds, you have a "key" column in the feed. For example, if you want to add the column "stock" to Omnia, you also need a column like ID or EAN to connect this to another feed that also contains the ID or EAN, so the stock levels will be added to the right products.
Step 2: Create an HTTP location and transform it into a CSV file
Go to file and choose the option: "Publish to the web..." (This doesn't mean that the file is accessible to everyone. The file is only accessible if you have the exact URL. Although the file is not easily accessible by anyone, keep in mind that the file is not secured with a login.)
In the option "Publish to the web..." select the sheet you would like to connect to Omnia in the left drop-down menu and select "Comma-separated values(.csv)" in the right drop-down menu and click on Publish.
Now a CSV file is created on an HTTPS location by Google. The link to this file is shown below the drop-down menus and can now be copied.
Step 3: Connect the CSV file to Omnia
Go to your Omnia console and navigate to Connect -> Configure Shop -> Configure Feeds. When you are there, click on the + button in the lower right corner to add a new feed.
Select CSV as the feed type, choose Comma's as the CSV Separator and choose HTTP(S) as the connection type (see image below). After that, you can enter a feed name and paste the https URL from Google in the Feed URL.
Now you can validate the feed and Save it.