Extract data from a published google spreadsheet

Extract data from a published google spreadsheet and use the values in the first column in a dropdown menu to look up the other values in the row.

{note}
This is the original spreadsheet:
public testing - Google Sheets

{urlload: https://docs.google.com/spreadsheets/d/e/2PACX-1vRg1Cge8IQ6FgknYMrU6ZRRL42JLsHWwNsX5BYWM-r2PnfaN7utkbf_O-VYO9lUpJa0UvNmS8gYaLfi/pub?output=csv; done=(res) -> ["csv"=res]}
{endnote: trim=right}
{if: iserror(csv)}Loading{else}{rows=slice(map(split(csv, "\n"), row -> split(row, ",")), 2); trim=right}

Col 1 value: {formmenu: values={=rows}; itemformatter=(row) -> row[1]; name=col}
Col 2 value: {=col[2]}
Col 3 value: {=col[3]}
Col 4 value: {=col[4]}{endif}