I'm trying to create a Google My Map based on addresses in a Google Sheet "file". This seems to work OK following the standard instructions, except that I can't seem to extract data on anything except the first sheet within that file; it doesn't allow me to select columns from another sheet. The steps I am following are:
Within my Google Map, select Add layer.
Select my Google Sheet file from My Drive.
I now only see column titles from my first sheet.
Am I doing something wrong? Is this not supported?