Google Spreadsheets Automation

Hi Team ,

Currenly i am working on Google Spread Sheet automation.Need help on the below

  1. Is it possible to work on Live google spreadsheet which is share to many people ?
  2. API console section - What is location we should provide ?Please refer screen shot .
    Which ever folder i am choosing ,will get the error "You do not have permissions to create projects in this organization "