Is it possible to have a SheetGo source file be a Google Sheet identified by filename (and not URL)?
We setup SheetGo to pull a file named ORDERS__Inventory_Valuation_Summary. Each day this particular file is deleted and replaced with a new file with the same name. However, once the old file is deleted, and the new file created, the SheetGo connection “breaks” and gives a Red Warning the file is now in the Trash.
This behavior indicates SheetGo is tracking the Source Google Sheet by URL rather than simply looking for a file by a particular name in a particular folder.
Is there a way for a SheetGo Source file be a Google Sheet identified by Folder/Filename?