How to Create google sheet and add data?

Ahhh, no, you didn’t. I was only using it to create a new file and populate the column headers for later updating via the Append method.

It looks like the API allows you to create new sheets with “batchupdate” but at that point you are working with code.