title: Do a Google search from an Excel formula and put the result in a cell
body: <p><strong>Before</strong></p>
  
  <p><a href="https://i.stack.imgur.com/Tzcl5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Tzcl5.png" alt="Screenshot of Google Sheet before addresses are added"></a></p>
  
  <p><strong>After (Addresses Added)</strong></p>
  
  <p><a href="https://i.stack.imgur.com/bmZuH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bmZuH.png" alt="Screenshot of Google Sheet After addresses are added"></a></p>
  
  <p>I have a spreadsheet with names of venues and I would like to add the addresses of those venues in the next cell using a formula in Google Sheets.  I would like to do this using a formula to do a Google Search for the results because I want to scrape many other values as well and quickly change the sheet on my phone as my needs change.  Thus I would like to do this without using any outside coding language and not even google apps scripts if I can avoid it.</p>
  
  <p><strong>Google Search for data</strong>
  <a href="https://i.stack.imgur.com/DxdJn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DxdJn.png" alt="Google Search for data"></a></p>
  
  <p>I found some information on how to do something similar with an excel formula here: </p>
  
  <p><a href="https://www.benlcollins.com/spreadsheets/google-sheet-web-scraper/" rel="nofollow noreferrer">Using Google Sheets as a basic web scraper</a></p>
  
  <p>That site shows how to do a google search for an author name of an article with an excel formula with a format like this:</p>
  
  <pre><code>=INDEX(IMPORTXML(A1,"//span[@itemprop='name']"),1)
  </code></pre>
  
  <p>Can you help me modify this to return the result of a google search into an excel cell?</p>