To move data from Google Sheets to Home Assistant automatically, use a ready-made scenario — no manual exports.
You can launch this Google Sheets + Home Assistant integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.