excuse me. for my code,
from google.oauth2 import service_account
from googleapiclient.discovery import build
Replace the placeholders with your API credentials
creds = service_account.Credentials.from_service_account_file('/Users/chakyinli/Downloads/report.json',
scopes=['https://www.googleapis.com/auth/spreadsheets'])
Replace the placeholders with your spreadsheet ID and range
service = build('sheets', 'v4', credentials=creds)
sheet = service.spreadsheets()
result = sheet.values().get(spreadsheetId='13sSi_xXEtZsVZ-EFh1nWzRkr6IbXFyXbPbM29Nzdtwg', range= 'Data!A1:D10').execute()
df = pd.DataFrame(result.get('values', []))
it works well in localhost. However, it is not working when I deployed it. May I know the solution? https://www.youtube.com/watch?v=HwxrXnYVIlU&t=87s
i tried to follow the above tuturial, but it is not working(have error in conn.read) frustrated… thank you and hope I can solve it