log into the the fritz box and copy any URL (session ID)
the request http://fritz.box/query.lua?sid=e3de55b7b03ce377&landevices=landevice:settings/landevice/list(name,ip,mac,ipv6_ifid,interface,ethernetport) will give you a JSON file
eine Liste der möglichen Attribute für die Auflistung in den Klammern bei list(...) findet man in den Support-Daten (Abschnitt landevices).
use https://jsonformatter.org/json-parser to make it look pretty
or use https://www.convertcsv.com/json-to-csv.htm to pipe to CSV and eventually to google sheets
http://fritz.box/query.lua?sid=e3de55b7b03ce377&landevices=landevice:settings/landevice/list(name,ip,mac,ipv6_ifid,interface,ethernetport)
will give you a JSON filehttps://jsonformatter.org/json-parser
to make it look prettyhttps://www.convertcsv.com/json-to-csv.htm
to pipe to CSV and eventually to google sheets