title: Retrieving location address based on place name and city in Google Spreadsheet
body: <p>I'd like to retrieve a place's location based on the name and address in Google Sheets, something like:</p>
  <pre><code>=PlaceAddress(&quot;White House, Washington, DC&quot;)
  =PlaceAddress(&quot;Moma, New York, NY&quot;)
  =PlaceAddress(&quot;Google, Mountain View, CA&quot;)
  </code></pre>
  <p>which would return results as they (respectively) appear in Google search, i.e.:</p>
  <blockquote>
  <p>1600 Pennsylvania Ave NW, Washington, DC 20500</p>
  <p>11 W 53rd St, New York, NY 10019</p>
  <p>1600 Amphitheatre Pkwy, Mountain View, CA 94043</p>
  </blockquote>
  <p>The Maps Apps Script service has a geocoder, but this seems to require address, not place name. I'm guessing the solution involves either some functionality I missed from Apps Script, or something like the <code>ImportData</code> function to get structured data from Google search or another service.</p>