It's better to use a no-code solution for ETL. Choose between Fivetran, Renta ETL or Stitch Data.

My quick advice: if security is your top priority and support for service accounts is important, then Renta is the best choice. It gives you more control.

Also, Google Sheets handles only small volumes of data. The free tier should be sufficient. I don't see any reason to write code.