title: Is there a way to get Google Sheets to default to a different tab each day?
body: <p>I have an MVC application that links to a Google Sheet doc via siteloader. It's loading great but defaulting to load the first tab in the sheets - working as designed obviously.</p>
  <p>Here's what I need to do:</p>
  <p>The tabs in this sheet are separated by date. So, for example, today's 8/22/20. The tab displays &quot;SAT 082220.&quot; Tomorrow's tab will be &quot;SUN 082320&quot; and so on.</p>
  <p>I need siteloader to default to today's tab when the project loads. So basically it just needs to load the next tab in the list each day.</p>
  <p>Does anyone have any thoughts on how to accomplish this?</p>
  <p>I know Google Sheets assigns its own unique URL to each tab in the sheet via the edit#gid= in the URL.</p>
  <p>Is there a pattern to the tab URL so I could have siteloader constantly just load the next tab in the list each day? i.e. edit#gid=1068387962 for today's tab and edit#gid=somethingsomething for tomorrow's?</p>
  <p>I'm thinking that may be the easiest way. From what I can see, though, it all looks random.</p>
  <p>Alternatively, is there a way to get razor to read the tabs and match the tab name with <code>DateTime.now</code>?</p>