gas_sf_update_record.js

/**
 * 更新クエリ
 */
function updateAccount() {
  checkAuthorization();
  var prop = PropertiesService.getUserProperties();
  var sessionInfo = JSON.parse(prop.getProperty("session_info"))
  //選択したセルがSalesforceのAccountIDであることを想定
  var accountId = SpreadsheetApp.getActiveRange().getValue();
  var res = UrlFetchApp.fetch(
    sessionInfo.instance_url + "/services/data/v30.0/sobjects/Account/" + accountId +"?_HttpMethod=PATCH", 
    {
      "method" : "POST",
      "headers" : {
        "Authorization": "Bearer " + sessionInfo.access_token
      },
      "payload": JSON.stringify({
      "Name": "GoogleAppsScriptによって更新！"
      }),
      "contentType": "application/json; charset=utf-8"
    }
  );
  return res.getContentText();  
}