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