Google sheet to dataset

Get Help CMS Features and Functionality
1

Hi everyone,

Know somebody or a step by step availeble is for setup a Google Sheet to Dataset? I tried but it’s don’t working.

I use Xibo 3.0.

2

Hi

So first you need to create your dataset structure and create the required columns to match the data held in the Google sheet.
Export your Google Sheet as a CSV and using the Row Menu for your DataSet click to import the CSV. You will be presented with options to match the Columns from the DataSet to the Columns from the CSV. If your CSV has headers then tick the option to ignore the first row, and click to upload.
You should then have the data from the CSV imported into the Columns of your dataset.

If you still run into issues with this then please do come back to us.

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.