KY Prefiled Bill Requests Scraper

Deploying

1. Follow the Google Drive API and Service Accounts instructions here
2. Create a new Google Sheet with the name Prefiled Bills
3. Share the sheet with the email address in the client_email field of the JSON from step 1, making sure to give it edit access
4. Click the Deploy to Heroku button above to deploy this app
5. Put the contents of the JSON from step 1 into the CLIENT_SECRET field on the Heroku app creation screen

Running manually

1. Go to the Heroku Dashboard and find your app
2. Choose Run console from the More menu
3. Enter python app.py in the input field, and click Run
4. Check your Prefiled Bills spreadsheet to see if it was populated

Scheduling runs

1. Go to the Heroku Dashboard and find your app
2. Click the Heroku Scheduler link from the Overview tab
3. Click Create Job
4. Choose an interval (every hour or every day)
5. Enter python app.py in the $ input field
6. Click Save Job