Streamlit google excel sheet problem

Community Cloud
1

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

2

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.