XCP Price embedded automatically updating Google Spreadsheet

How can you take… say… the API for blockscan.com (JSON data)

  "status": "success", "message": "BTC/XCP Price", "result": "0.00990099"[font=verdana]
Bonus question: How can you make a Google Spreadsheet that has a password ?[/font]