7

I am trying to access google spreadsheets through gspread api in python. I have imported gspread. I am getting socket. error: [Errno 10061] No connection could be made because the target machine actively refused it at gc = gspread.login('pan*******@gmail.com', '********')

Here is my code:

import urllib2
import urllib
import gspread
from PIL import Image
from PIL import ImageDraw
from PIL import ImageFont

w = 420

gc = gspread.login('pan******@gmail.com', '*******')
wks = gc.open("Spreadsheet").sheet1

I have checked that the username and password is correct. I have added two environment variables as 'http_proxy':'host:port' and 'https_proxy':'host:port' What am I doing wrong? Thank you.

Jemshit
  • 9,501
  • 5
  • 69
  • 106
Harshil Pansare
  • 1,117
  • 1
  • 13
  • 37
  • I ran into the same problem, since I am also working behind corporate proxy the `gspread` module didn't work for me and I got the same error as mentioned in the problem statement. I found one workaround i.e. use `script editor` in spreadsheet to write functions do things and you can call these function by send just http post request to the sheet. – RejeeshChandran Apr 04 '19 at 13:27

1 Answers1

2

For anyone who might have this problem, I found out that gspread library doesn't support proxy connections. I ran it through normal connection and it worked.

Harshil Pansare
  • 1,117
  • 1
  • 13
  • 37