require "google.auth"
require "google.spreadsheet"

local user , pwd

io.write("Login : ")
user = io.read()
io.write("Password : ")
pwd = io.read()

local token = google.auth.newToken(user,pwd,google.auth.service.spreadsheet)

for i,spreadsheet in google.spreadsheet.iGetList(token) do
        print(i,spreadsheet.name)
end


local QAP = google.spreadsheet.load(token,google.spreadsheet.getList(token)[1])
QAP:addWorksheet("TESTING 1")

local Sheet1 = QAP:getWorksheet("TESTING 1")
Sheet1:setTitle("Test Sheet")
Sheet1:setSize(5,5)

sheet:set(1,1,"Bacon Strips !")