13 lines
507 B
Python
13 lines
507 B
Python
import gspread
|
|
from google.oauth2.service_account import Credentials
|
|
|
|
SCOPES = ["https://www.googleapis.com/auth/spreadsheets"]
|
|
CREDS_FILE = "D:/lecturertask/credentials.json" # Sesuaikan path JSON kamu
|
|
|
|
def get_sheet(spreadsheet_id, worksheet_name):
|
|
credentials = Credentials.from_service_account_file(CREDS_FILE, scopes=SCOPES)
|
|
client = gspread.authorize(credentials)
|
|
spreadsheet = client.open_by_key(spreadsheet_id)
|
|
worksheet = spreadsheet.worksheet(worksheet_name)
|
|
return worksheet
|