Hello.
We migrated all of our information from one Google sheet to a newly created sheet in the same drive, so I had to update all of the information in approximately ten Zaps. It was able to load, and configure the column triggers, the new spreadsheet perfectly fine for the first seven Zaps, then on the eighth, after attempting to turn it on, it produced an error “The App Returned "File not found".
After retracing my steps in the “New or Updated Spreadsheet Row in Google Sheets” trigger, the Spreadsheet could no longer be found! Even though I finalized all previous steps by locating it, it was no longer found. After going back into the previously updated Zaps, the sheet was no longer found either!
I can manually add the “Spreadsheet ID” to the Custom spreadsheet field and it pulls the columns/information just fine, but when attempting to turn it on, it once again displays that same error.
How does it locate the sheet perfectly fine and then just loses it when there have been no changes made to said sheet during the Zap configuration process?