서버에서 google sheet api 사용하기 (with python)

index.py

from __future__ import print_function

from google.oauth2 import service_account

from googleapiclient.discovery import build
from googleapiclient.errors import HttpError

# If modifying these scopes, delete the file token.json.
SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']

# The ID and range of a sample spreadsheet.
SPREADSHEET_ID = 'YOUR_SPREADSHEET_ID'
RANGE_NAME = 'YOUR_RANGE_NAME'

def main():
    try:
        credentials = service_account.Credentials.from_service_account_file('credentials.json', scopes = SCOPES)
        service = build('sheets', 'v4', credentials=credentials)

        # Call the Sheets API

    except HttpError as err:
        print(err)


if __name__ == '__main__':
    main()