title: Web Scraping Co-Sponsors on NYS Bills using Google Sheets using IMPORTXML
body: <p>I am currently trying to write a formula in Google Sheets so that it will take the co-sponsors for a NYS and put them into my google sheet. The formula that I wrote is:</p>
  <p><em>=IMPORTXML(<a href="https://nyassembly.gov/leg/?term=2021&amp;bn=S01184" rel="nofollow noreferrer">https://nyassembly.gov/leg/?term=2021&amp;bn=S01184</a>, &quot;//</em>[@id='legcontent']/table/tbody/tr[7]/td[2]&quot;).</p>
  <p>//*[@id='legcontent']/table/tbody/tr[7]/td[2] is the xPath for the data that I am trying to extract which I copied from the HTML on the website.</p>
  <p>I am getting the error &quot;Formula Parsing Error&quot;, however, I do not see where the error is. It would be much appreciated if anyone could help out!</p>