Data Source Feature

To use Google Sheets as a data source, you must generate a public CSV URL from your sheet.

Steps to Get a Public CSV URL:

1. Go to Google Drive

2. Sign in to your Google account

3. Use a non-organization (personal) Google account

4. Open an existing Google Sheets file or create a new one

5. In the top menu, click: File → Share → Publish to the web

6. In the popup:

   • Select Link

   • Choose Entire document or a specific sheet

   • Select format: Comma-separated values (.csv)

7. Click Publish

8. Copy the generated public URL

9. Paste this URL into the Document URL input field in NoviSign Studio

• • The “ID column” field in the API Integration pop-up must exactly match the name of the first column in your Google Sheet (case-sensitive)

• For example:

  • If your first column in Google Sheets is named ID, then the ID column field in the integration should also be ID

  • If your column is named test, then you must enter test in the integration field

• This column is used as a unique identifier for each row

• Each value in this column should be unique

• If the names do not match exactly, the integration may not work as expected

To connect an external data source to NoviSign, you first need to create an integration from the Settings page.

1. In the Studio, click Settings in the top navigation.

2. Select the API Integration tab.

1. Click Add new integration.

2. From the dropdown menu, select Google Sheets.

Once your data source integration is configured in Studio Settings, you can load and test the data directly inside your Creative.

How to Load Data

1. Go to the Creatives tab and open your Creative

2. In the right-side panel, scroll down to Load Parameters

3. Under API Integration, click Add

Configure the Integration

4. In the Integration types dropdown, select:
   import-csv

• In the Select item dropdown, choose the name of the integration you created in the Settings tab 

• In the Name field, enter a name for this integration
  (This name will be used later when binding dynamic data in the widget)

• Scroll down and click Test

Result:

• The data from your CSV (Google Sheets) will appear in the preview section

• This confirms that the integration is working correctly and the data is being pulled successfully

After loading and testing your data, you can bind it to widgets and display it on screen.

How to Display Data

1. Add a Text or Label widget to your canvas

2. Click inside the text field

3. Type:  ${

   This will open the Compose JSON dialog

4. Click Insert a dynamic value

5. Select @customapi

6. Click Insert a dynamic value again

7. Choose the API Integration you created in the previous step

8. Select the desired dynamic property (e.g., Name, Last name, etc.)

Result:

• The widget will now display data dynamically from your connected data source

• The content will update automatically based on the integration

To send the API configuration to the player without configuring each device manually, you can use the

Studio → Configurations tab.

Go to:

Screen Content → Settings → Configurations → New Configuration → External Interfaces → Custom API Integration

• Enter the same API details (Name / API URL / Headers / Property Key)
• Test to confirm JSON data is returned
• Save the configuration

Assigning API Configuration to a Screen

In Screen Content:

1. Locate the target screen
2. Click the three dots (⋮) beside it
3. Select Set configuration
4. Choose your Custom API Integration

Once assigned, the player will import the configuration automatically when that screen is selected.

Player Configuration
Accessing the API Settings
On the player device, navigate to:
Settings → Advanced → External Interfaces → Custom API Integration

Create a New API Integration
Fill in the following fields:

Name: Give the integration a recognizable name
API URL: Endpoint from which the JSON data will be retrieved
Refresh: How often the API should request data (in seconds)
Request Type: GET or POST (default: GET)
Request Body & Headers Only needed if the API requires tokens, authorization keys, or specific parameters
Property Key: A unique keyword that will later be used in Studio to inject data into creatives
NOTE: The Property Key is important — you will reference it when building expressions inside Studio.

• Testing & Saving
  Click Test to validate the API.
• If successful, the JSON dataset will appear in a preview window.
• Click Save to store the configuration.