I'm trying to create a large scrolling page of text - specifically thanks to Patreon supporters.
I have a couple hundred and want it to display from a live Google sheet so that its current.
How would I go about this, a single row(name) at a time is gonna take a while, but a large page with say 50 or more names x4 would be more possible.
Not sure how to grab all those names and display though?


UPDATE I figured it out:
Using google sheets - create a new sheet in the same document as your list of names - lets say the names you have inported into the 1st sheet are in column A

In the second sheet (sheet2)
A1 cell type Names (for the title)
Cell A2=textjoin(", ", 1, Sheet1!A2:A50) (first 50rows of names from sheet1)
This will create a text in that cell of Name 1, Name 2, Name 3 etc.

Now you can setup the datasource to pull from the tablename Sheet2 and pipe that into your text area and it will be populated with the comma delimited names from Sheet1.
I am using multiple rows with 50 names in each.

Hope this helps someone.

I found that even with a 1 second crawl, 100 names is gonna take a while. But maybe I wasnt doing it right? If a ticker would work with several rows at a time it might be OK.