Can Gemini direct query Google sheet?

[Chan_Bella]

I have already defined which document and sheet, but the gemini model keep ask me to give document name, sheet name and value.

I simply ask how many rows, or what’s the first row, it cannot handle.

What is the error message (if any)?

Please share your workflow

{
“nodes”: [
{
“parameters”: {
“options”: {}
},
“type”: “@n8n/n8n-nodes-langchain.chatTrigger”,
“typeVersion”: 1.1,
“position”: [
0,
0
],
“id”: “b72dba77-3459-4158-b3c4-3b0ad8b4995e”,
“name”: “When chat message received”,
“webhookId”: “b6453d94-5273-46a6-a1ae-76672dd9e3ab”
}
],
“connections”: {
“When chat message received”: {
“main”: [

]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “e1769c08106a0a483983e562e19a09614f9bc72e191a457f038d6a60bb2c81a5”
}
}

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[Alex_Huang]

@Chan_Bella you should get the data by google sheets and then pass it to the gemini to understand.

[Chan_Bella]

Hi Alex,

Thank you for your kind reply, but how to pass data from google sheet to Gemini?

Sorry I am new to this, really appreciate your help.