Google Sheets "Internal Server Error"

Queries and Resources
1

Hello,

Trying out an API to Google Sheets integration...
I have a Google Sheet as a datasource that worked last week - this morning, it worked a few times... then after maybe 5 runs when cleaning up some data/troubleshooting other things - I now get the below when previewing:

gsheetRead failed (0.553s):Internal server error
from gsheetRead response(gsheetRead)
in gsheetRead.trigger()(gsheetRead)
environment: "production"
from preview

And when running it standalone, it just says "Running queries... gsheetRead 93.1s" and runs forever without returning anything.

Sheet or columns has not changed.

Any ideas?

2

Hey Baxter! Is this with our native Google Sheets integration or with a REST API?

And if you click into the resource and test the auth, does it give you a success message?

3

Same problem here!
"append data to a spreasdheet" keeps running and never stops.
If I try to "preview" the query, the google sheet updates but the output says "internal server error"

4

Hey @gioriv! That's super strange. Would you be able to share a screenshot of your Google Sheets query that keeps running?

5

I solved this by creating a blank app and copying and pasting all the resources queries from the previous app.
Thanks!

6

Ack, I'm sorry you had to do all that :person_facepalming: I hope it's smooth sailing from here and let us know if anything else comes up!