How to use gspread-pandas in streamlit cloud

☁️ Community Cloud
1

Hi, I’m trying to use gspread-pandas package on my streamlit cloud APP, my current environment.yml looks like this:

channels:
- conda-forge
dependencies:
- xlsxwriter
- openpyxl
- gspread
- gspread-pandas

It will keep saying that ResolvePackageNotFound or installer returned a non-zero exit code. Please help, thanks!

1 Like
2

Can you share a code snippet or link to the app code?

3

Hi Caroline, I had the same issue with gspread. It tells me import error but I am importing gspread in the script

These are my dependencies:-

gspread>=5.10.0
oauth2client>=4.1.3
googleapiclient>=2.95.0
streamlit>=1.25.0
pandasql>=0.7.3

and below is my yml code:

jobs:
  build:
    runs-on: ubuntu-latest
    strategy:
      fail-fast: false
      matrix:
        python-version: ["3.6", "3.7", "3.8", "3.9", "3.10"]
    steps:
      - uses: actions/checkout@v2
      - name: Set up Python ${{ matrix.python-version }}
        uses: actions/setup-python@v2
        with:
          python-version: ${{ matrix.python-version }}
      - name: Install dependencies
        run: |
          python -m pip install --upgrade pip
          if [ -f requirements.txt ]; then pip install -r requirements.txt; fi
          if [ -f requirements_dev.txt ]; then pip install -r requirements_dev.txt; fi
      - name: Lint with flake8
        run: |
          # stop the build if there are Python syntax errors or undefined names
          flake8 . --count --select=E9,F63,F7,F82 --show-source --statistics
          # exit-zero treats all errors as warnings. The GitHub editor is 127 chars wide
          flake8 . --count --exit-zero --max-complexity=10 --max-line-length=127 --statistics

Here is the repo GitHub - dakshbhatnagar/apps. Also pls tell me how to keep my keys private. I am a beginner at deployment