Using google sheets API

[Arshkamran1]

Why doesn't deta install the google api's. I created a program in python that converts a google sheet to a data frame, and then emails the last added row. However although it works locally, on the server I get these issues. Traceback (most recent call last):
File "/opt/python/detalib/debugger.py", line 142, in wrap
result = func(event, context)
File "/var/task/_entry.py", line 12, in handler
import main # noqa
File "/var/task/main.py", line 1, in
from googleapiclient.discovery import build
ModuleNotFoundError: No module named 'googleapiclient', Someone plz help me

[sudo-subg]

As per the docs here:

For unknown reasons, Google and Firebase packages for Python do not install successfully on Micros.

But when tried to install Google API Client it installed successfully.

[Arshkamran1]

How did u install it, may I ask did you just put it in the requirements txt?

[Arshkamran1]

If so what did you put, and how do you check the dependencies

[sudo-subg]

How did u install it, may I ask did you just put it in the requirements txt?

You add the required dependencies in requirements.txt as you should and in this case google-api-python-client.

If so what did you put, and how do you check the dependencies

To check the dependencies of the micro you can run deta details in the micro's folder's root directory or check in your micros details using Deta Dashboard.

[Arshkamran1]

pandas
python-dotenv
google-api-python-client

this is what is inside my requirments.txt and I did deta deploy but still can't check what dependencies I have
when I run deta details I get this

{
"name": "send_emailauto",
"id": "7ec065aa-da78-48c5-86ee-eb1c939174ff",
"project": "default",
"runtime": "python3.9",
"endpoint": "https://1ed4gb.deta.dev",
"region": "us-east-1",
"environment_variables": [
"EMAIL",
"PASSWORD",
"APP_PASSWORD"
],
"visor": "enabled",
"http_auth": "disabled",
"cron": "0/5 * * * ? *"

[Arshkamran1]

nvm I had spelled requirements wrong lol thnx for your help