Downloading PDF Using Python

Python Script to Download PDF files Using gspread library retrieving data from spreadsheet and requests for downloading it as a zip file. First you need to install python packages “gspread” and “requests”.

1
2
3
4
5
6
7
8
9
10
11
12
13

import requests
import gspread
gc = gspread.login('Username@gmail.com','Password')
spreadsheet = gc.open_by_url("Url of Spreadsheet")
worksheet = spreadsheet.sheet1

cell = worksheet.cell(2, 2)
value = cell.value
print(value)
print "downloading with requests"
r = requests.get(value)
with open("code.zip", "wb") as code:
    code.write(r.content)