I’m using google sheets as a data source. If I wanted to move a sheet from one workbook to another, will I be able to easily just redirect the table source in appsheet to the sheet in the new workbook? Or will it bug out and make me redo a bunch of things?
As long as the column headers remain the same after moving the sheet (tab) to another spreadsheet, your app should remain intact.
In order to make it seamless, I recommend to first open your app in app editor, then move/copy the sheet to new spreadsheet while app definition is open in app editor; go to Data > Tables; open table definition and change Source Path (spreadsheet name), and Worksheet Name/Qualifier (sheet name) accordingly, and save.