where we could collect the current LM data for a specific legion at intervals to auto-update a spreadsheet

Eww, XML.

JSON is inherently better.

whatever format - as long as it's in some form i can import into google spreadsheets

Your LM tracker isn't working to paste the names?

currently I collect the data using CTRL-C from THe GL mission page and paste the values into our Spreadsheet

Even copying to a Notepad page or a PM until someone can place into spreadsheet sometimes

tedious but doable - until someone forgets to collect data or is unavail

this could be automated for everyone - then no one misses collecting the info

You would have to ask Dan if he is good with it but you could strip it out of the source of the below link.

https://galaxylegionfb.com/galaxylegion ... ission.php

Source:

and stripping it out that way is hard

simple format like


team: previous team name above
....
end team
team: your team name
Legion mission name
task 1
player name 1, 0/20
player name 2, 16/20
player name 3, 20/20
task 2
...
task 3
...
task 4
...
end team


...and so on
one current list


or
team name
Legion mission name
player 1, task on(0-4),and progress
player 2 ...
and so on

end team

I don't really think Dan should be spending time on something that you can do for yourself. I'd much prefer he was working on other stuff that we can't do.

Money where my mouth is time: Have already spent silly amounts of time to create a full copy and paste google sheets LM tracker. It is ridiculously more complicated than what you are asking for, but basic principles are really quite simple.