title: Update Salesforce records from Google Apps Script
body: <p>I have installed the Cloud Connector script from:
  <a href="http://www.sanjaygidwani.net/2011/09/10/how-to-setup-and-run-cloudconnector/" rel="nofollow noreferrer">http://www.sanjaygidwani.net/2011/09/10/how-to-setup-and-run-cloudconnector/</a></p>
  
  <p>I can successfully query salesforce data.</p>
  
  <p>My question is how to update records. I come from Microsoft Access, VBA, and SQL.</p>
  
  <p>In SQL, I would just use this:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>UPDATE Prospect__c SET Prospect__c.Field1__c = "ABC123"
  WHERE Prospect__c.Id = “AAA";</code></pre>
  </div>
  </div>
  </p>
  
  <p>How would I accomplish this with SOQL or any other way from Google Apps Script?</p>