test_sheet.py

import gspread

gc = gspread.service_account(filename="credentials.json")

sheet = gc.open("Keyword Tracker")

print(sheet.sheet1.get_all_records())