title: Performing Google Search In Spreadsheet And Scraping The SERP Data
body: <p>I hope that you guys are fine. I want to build a simple spreadsheet and I thought I could be able to make one but blank sheet looks horrible to me. I am sure that you guys are kind enough to help me out.</p>
  
  <p>I want to perform multiple Google search queries in Google spreadsheet and want to parse results of each search (top 10 results of each search)</p>
  
  <p>Something like this: <a href="https://www.youtube.com/watch?v=tBwEbuMRFlI" rel="nofollow noreferrer">https://www.youtube.com/watch?v=tBwEbuMRFlI</a></p>
  
  <p>But when I tried his given formula in description to play test, Google returned #Error to me, I don't know why.</p>
  
  <p>Can you guys please help me out in making a simple spreadsheet compatible for multiple queries at once? Like one column for keywords (where I could paste my list of keywords) and then 10 columns of search results. All results for one keyword should come in one row</p>
  
  <p>Something like this:</p>
  
  <p>My 1st Example Query = 1st search result, 2nd search result, 3rd result and so on.
  My 2nd Example Query = 1st search result, 2nd search result, 3rd result and so on.</p>
  
  <p>It must be easy to code but yeah, it might be time-consuming and I would be very grateful if anyone of you could help me about it.</p>
  
  <p>Looking forward to your help guys.</p>