Google spread sheet error

i used spreedsheet and followed the instruction in redash document but i’m getting this error
Error running query: Unable to find the server at
how to solve it

Can you share more information about your data source setup and query?

this is my query after setting up
and i followed this link to set up spreadsheet as data source

  1. Did you create a service account for Redash to access your sheets? It appears that Google expects Redash to login via oauth (which it can’t do).
  2. Have you confirmed that your server can ping It might be blocked by your firewall.

yes i created service account and shared file with it