Newly Uploaded Excel Files Not Appearing in the List of google sheet trigger

[Team_Uraan]

Image 1: There are three Google Sheets available, but when I click on the dropdown list button in the trigger (Row added or updated), only the first two excel file are visible the third one name ‘customer product’ doesn’t show up(I uploaded this file just today, and first two files were there on drive since 2022).

Image 2: Here you can see the drop down menu not displaying the file named ‘Customer Product’.

Explanation: First, I created an account and then went to Google Cloud Console, where I set up “Project 1.” After that, I created credentials (OAuth Client ID).

Then i enabled three APIs 1. Cloud resource API 2. Google Sheet API 3. Google Drive API.

I believe I am missing a step because I have tried this with multiple accounts and still face the same issue. Specifically, two Excel files, “Right equations that can be used as a formula in…” and “Quiz,” were already in my Google Drive and appear in the list as expected. However, any new Excel file I upload does not show up in the list. This makes me think there is a missing step in the process.
Please help me and guide me step by step because i’m new to n8n

CODE:
{
“nodes”: [
{
“parameters”: {
“pollTimes”: {
“item”: [
{
“mode”: “everyMinute”
}
]
},
“documentId”: {
“__rl”: true,
“value”: “1w8Ya29DCRX2HfmmwkLjPZgtwxR7me81EPQ_8qZmkj48”,
“mode”: “list”,
“cachedResultName”: “Quiz (Responses)”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1w8Ya29DCRX2HfmmwkLjPZgtwxR7me81EPQ_8qZmkj48/edit?usp=drivesdk”
},
“sheetName”: {
“__rl”: true,
“mode”: “list”,
“value”: “”
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheetsTrigger”,
“typeVersion”: 1,
“position”: [
0,
0
],
“id”: “343b2001-ec99-4913-b7fc-ba07b07a5a29”,
“name”: “Google Sheets Trigger”,
“credentials”: {
“googleSheetsTriggerOAuth2Api”: {
“id”: “YaMSWd1XolviL3X3”,
“name”: “Google Sheets Trigger account”
}
}
}
],
“connections”: {},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “39b143e3e9f9072db952fb7fb4a7cf958f44887368a34da6f787a46100e9d721”
}
}

• **n8n version: 1.83.2
• Database (default: SQLite): default
• n8n EXECUTIONS_PROCESS setting (default: own, main): default
• Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
• Operating system: Windows 11 PRO (23H2 version)

[Olek]

Try simpler credentials to work with specific files on Google Drive.

This should be quite sufficient. No need to set up apps on GCP or managing scopes (it is quite easy to overlook something improtant).

Try this and see if it makes the new file accessible.

Also I just noticed that this file is still an XLSX file and it is not converted into Google Sheets doc. Not sure if this makes it “invisible”, but I’d try to convert it first.

You may want to automate conversions for uploads in your Google Drive settings.

If any of the suggestions above help, please mark this post as a Solution.

[Team_Uraan]

It Worked, the issue was with the file type, it recognizes only if it is in google sheet not xlsx. I can’t thank you Enough!!