title: Google spreadsheetID is NOT given when I publish to the web
body: <p>The google sheets API documentation states I need to have a sheetID that would show up in the url here (denoted {SHEETID}):
  <a href="https://docs.google.com/spreadsheets/d/" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/</a>{SHEETID}/edit#gid=0</p>
  
  <p>However, when I publish to the web, the URL returned is something along the lines of:
  <a href="https://docs.google.com/spreadsheets/u/1/d/e/2PACX-1vcasfsaf2123Mt_basdf34grGd_1231sfak_D32141sfasfqwer_phealsjsmfdafcmr2S_-n-wzUp/pubhtml" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/u/1/d/e/2PACX-1vcasfsaf2123Mt_basdf34grGd_1231sfak_D32141sfasfqwer_phealsjsmfdafcmr2S_-n-wzUp/pubhtml</a></p>
  
  <p>I have also already tried just using the sheetID from the unpublished url and that does not work either.</p>
  
  <p>I'm trying to pull data with react from this sheet but am unable to do so. Does anyone know how else I can get the sheetID?</p>