API to connect to Sheets

Ask Community How do i?
#1

Hello,

I wish to transpose row data into column.
What API to be used to access sheets, create new sheets and pivot function to transpose.

regards