I have successfully added my Google Drive CSV file as a web layer in a web map using this method. I used this method because I need it to be dynamic.
The points from the CSV gets drawn as layers and symbolized etc on the new web map.
I can create an Operations Dashboard and it sees the CSV referenced web layers, so widgets like Indicator or Charts work without problems.
However, when I try to do the same using Experience Builder, the widgets do not see the gdrive CSV web layers even though I reference the correct web map as data source. The layers simply isn't shown so I cannot configure widgets at all.
It's weird that Operations Dashboard can see the layer while Experience Builder cannot see it as a data source. Any ideas for a work around?