to google' servers and make api requests ezsheets handles the interaction with these modulesso you don' need to concern yourself with how they work obtaining credentials and token files before you can use ezsheetsyou need to enable the google sheets and google drive apis for your google account visit the following web pages and click the enable api buttons at the top of eachyou'll also need to obtain three fileswhich you should save in the same folder as your py python script that uses ezsheetsa credentials file named credentials-sheets json token for google sheets named token-sheets pickle token for google drive named token-drive pickle the credentials file will generate the token files the easiest way to obtain credentials file is to go to the google sheets python quickstart page at blue enable the google sheets api buttonas shown in figure - you'll need to log in to your google account to view this page figure - obtaining credentials json file clicking this button will bring up window with download client configuration link that lets you download credentials json file rename this file to credentials-sheets json and place it in the same folder as your python scripts