mirror of
https://github.com/langgenius/dify-official-plugins.git
synced 2026-07-21 17:45:23 -04:00
plugin omluc / google_sheets seems not access gsheet properly #273
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @cottonvalleyholdings on GitHub (May 11, 2025).
Self Checks
Dify version
1.3.1
Plugin version
0.0.1
Cloud or Self Hosted
Self Hosted (Docker)
Steps to reproduce
I am triying to get data from a very simple soreadsheet consits of 2 columns only, and the prameter specifies its file ID and sheet name looks correct, but thie node states it improper as follows...
input
{
"spreadsheet_id": "1A0_2mt-odXYNWs6iYUpoxpW40MIw9fQChhKxEZvAMOI",
"ranges": "Sheet1!A1:B10"
}
output
{
"text": "Invalid JSON format for ranges. Please provide a valid JSON array.",
"files": [],
"json": []
}
Aside to this, for its problem isolation, I replaced the file ID with absurd one such as "hogehoge", but the output text did not change while I expected it would change to "the file does not exist" or something else though....
✔️ Error log
input
{
"spreadsheet_id": "1A0_2mt-odXYNWs6iYUpoxpW40MIw9fQChhKxEZvAMOI",
"ranges": "Sheet1!A1:B10"
}
output
{
"text": "Invalid JSON format for ranges. Please provide a valid JSON array.",
"files": [],
"json": []
}
@Phonlin commented on GitHub (May 12, 2025):
I tried removing "Sheet1!" and used "A1:B10" directly, and it worked.
{
"spreadsheet_id": "1A0_2mt-odXYNWs6iYUpoxpW40MIw9fQChhKxEZvAMOI",
"ranges": "A1:B10"
}
@cottonvalleyholdings commented on GitHub (May 12, 2025):
@Phonlin
Thanks for your update, but I do not find any improvements while I removed "Sheet1!" as you mentioned.
input
{
"spreadsheet_id": "1A0_2mt-odXYNWs6iYUpoxpW40MIw9fQChhKxEZvAMOI",
"ranges": "A1:B10"
}
output
{
"text": "Invalid JSON format for ranges. Please provide a valid JSON array.",
"files": [],
"json": []
}
@kurokobo commented on GitHub (May 12, 2025):
@Phonlin
Since omluc/google_sheets is not an "official" plugin, it's more appropriate to open issues in the dify-plugins repository rather than here.
Anyway I haven't used this plugin myself, but as the error message suggests, the
rangesparameter probably needs to be an array. What happens if you add[]like this:"ranges": ["Sheet1!A1:B10"]@dar0xt
F.Y.I.
@cottonvalleyholdings commented on GitHub (May 13, 2025):
@kurokobo
Thanks for your follow-up.
Help page for this plug-in refers for this repo as follows, but per your guide I will close this thread and move to another repo,
Support
For issues or feature requests, please open an issue in the Dify Official Plugins repository.
@kurokobo commented on GitHub (May 14, 2025):
@cottonvalleyholdings
I didn't know that, thanks for letting me know. I'm not sure if it will be fixed, but I'll let the developers know anyway.