Organise jobs from the AAS website with the help of Google Sheets.
- Email notifications for new jobs every day
- See when your deadlines are approaching
- Keep track of discarded or complete applications
- Integrate with travis-ci to automatically keep your database up to date
- No pesky to-do lists or heavy websites to host
- Add your own jobs manually to the list to see everything in one place
- Fork this repository
- Make a copy of the spreadsheet here (not updated)
- Save the
SPREADSHEET_ID
as an environment variable - Save the required
MAILGUN
environment variables for notifications (or modify that bit) - run
python sheets.py
to get authorised with google (it will tell you what to do). This produces atoken.pickle
file which is secret and must not be commited to git! - run
python run.py
to update the google sheet!
- Sign up to travis-ci and integrate your github account
- Set the
SPREADSHEET_ID
,MAILGUN_DOMAIN
,MAILGUN_API_KEY
,EMAIL_ADDRESS
environment variables you used above as secret keys in travis settings - run
gem install travis
- run
travis encrypt-file token.pickle [--pro]
- Update the .travis.yml file like it tells you. Something like
openssl aes-256-cbc -K $encrypted_040c7bfba308_key -iv $encrypted_040c7bfba308_iv -in token.pickle.enc -out token.pickle -d
- Commit the changes in
.travis.yml
and the newtoken.pickle.enc
file, not the originaltoken.pickle
orcredential.json
files!. - Set cron job in travis settings to run every day
Done!