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