Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Users might want to add a dynamic element of time or date into any of the HootVid template text fields. The easiest way to accomplish this is by simply adding it to your Google Sheet Data.

...

  1. In an empty column header type the function =IMPORTDATA("YOUR FEED LINK HERE")

    1. For Example =IMPORTDATA("https://api.hootinteractive.net/v1.0/feed/37554?token=aGBGnTcjtR&advertiser=4337&format=Programmatic%20Display&fname=test")

  2. This will pull that data into your sheet accompanied now by your dynamic time and date.

Info

For instructions on using this Google Sheet as a data source within HootVid, review the help documentation found here: How to use a Google Sheet as a Data Source

Additional functions exist to pull in the data from other data source formats.

IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

IMPORTRANGE: Imports a range of cells from a specified spreadsheet.

IMPORTHTML: Imports data from a table or list within an HTML page.

IMPORTFEED: Imports a RSS or ATOM feed.