#Google sheet MCP not working

1 messages · Page 1 of 1 (latest)

mortal dagger
#

I created a google sheet MCP server few mins ago and provided access to it through the link it shareded.
Now after less than 1 hour I again tried to access it and I am getting "I'm encountering the same permission issue with this Google Sheet"

Is there any timeout on the tools?
if yes can you guys please mention that in docs also.
I want a permanent access kind of thing. How can I achieve that?

modest plaza
mortal dagger
#

I think I have not used connectedAccountId

below is my code which creates MCP servers.

actions_of_tool = []
response = requests.get(
"https://backend.composio.dev/api/v2/actions/list/all?apps=" + name,
headers={
"x-api-key": api_key
},
)

    for item in response.json()["items"]:
        actions_of_tool.append(item["enum"])

    response = requests.post(
        "https://backend.composio.dev/api/v3/mcp/create",
        headers={
            "x-api-key": api_key
        },
        json={
            "name": request.user_id + "_" + name,
            "apps": [
                name
            ],
            "actions": actions_of_tool
        },
    )
#

@modest plaza can you please also answer this

Is there any timeout on the tools?
I want a permanent access kind of thing. How can I achieve that?

modest plaza
#

Ah I see. I'm checking w the team regarding the default TTL.
And yes, you can create a permanent one:
You can pass the ttl field with value no expiration

curl -X POST https://backend.composio.dev/api/v3/mcp/create \
     -H "x-api-key: pk...." \
     -H "Content-Type: application/json" \
     -d '{
  "name": "",
  "ttl": "no expiration"
}'
mortal dagger
#

@modest plaza is it for the server or for the auth?
because in docs it is mentioned it is for server and server is still there but auth was not working correctly

mortal dagger
#

@modest plaza man nothing is working, This time even my claude is not able to generate the conenction URL and I have the INITIATE_CONNECTION there 🙂
Can we schedule a meet to fix this.

#

check this man, Its not able to connect

#

I am happy to pay if there is some stable env where this type of issues are not there?

modest plaza
#

Could you share the response/error logs? that helps in debugging.

mortal dagger
#

Man even in logs I am not able to find anything

#

It is not even showing logs after 13th and I clearly tried it today

#

@modest plaza Can we connect for sometime tomorrow and fix this ?