Import inputs from Google Sheet

In this article, you will learn how to import inputs from Google Sheet for a graphic.

Before you begin

To learn how to preview a graphic in EvoFX broadcast graphics platform studio, refer to this article.

Import inputs from Google Sheet

You can prepare a Google Sheet with inputs and import them into a graphic by following these steps. The graphic will update in real time as the inputs in the Google Sheet are changed.

Click the "Inputs" button for the graphic, located on the right side of the page as shown below.

Upon clicking, a dialog box titled "Inputs for Current Graphic" will open. The dialog offers two options: "Manual" and "Google Sheet". By default, "Manual" is selected. All inputs, whether text or image URLs entered manually will be displayed in the graphic.

Prepare a Google Sheet with the required inputs (text or image URLs) placed in different cells as shown below.

Ensure the Google Sheet is set to public (accessible by anyone with the link).

In the "Inputs "dialog box, select the "Google Sheet" option.

Once selected, paste the Google Sheet's URL in the "Google Sheet URL" input field. After pasting, fill the input fields with the corresponding cell numbers from the Google Sheet as shown below. The data from those cells will be used as inputs in the graphic. Click “Close” to exit the “Inputs” dialog box.

Once clicked, the "Inputs" dialog box is closed. The updated graphic with inputs from the Google Sheet can be seen below.

• Related Articles

• Manual inputs

  In this article, you will learn how to add manual text inputs for a graphic. Before you begin To learn how to preview a graphic in EvoFX broadcast graphics platform studio, refer to this article. Manual inputs Click on the edit button for a graphic ...

• Import third party APIs and databases

  In this article, you will learn how to import third party APIs and databases into EvoFX broadcast graphics platform. Import third party APIs and databases You can write your own adapters to import data into Google Sheets and map it into EvoFX, or you ...

• Ticker with broad ends

  In this article, you will learn about the ticker graphic with broad ends and a narrower width in between. It can be used to display information that scrolls at the bottom of the page. On 1920x1080 screens, the ticker with broad ends, once launched ...

• 3D lower third

  In this article, you will learn about the 3D lower third graphic, which can be used in multiple sectors like corporate events, sports, and news channels to highlight an issue, important information, or statistics. On 1920x1080 screens, the 3D lower ...

• Basic lower third with smooth edges

  In this article, you will learn about the basic lower third with smooth edges graphic, which can be used in multiple sectors like corporate events, sports, and news channels to display information live while the video stream is ongoing. On 1920x1080 ...