We get a lot of legacy sheets that stick around after data pushes, it's as if they don't delete themselves and they will just build up in our sheets.
Is there a way to make sure they delete themselves?
Thanks
Which EasyMorph version are you using?
In case your version is older than 5.6, replace it with a newer one.
And check if the Export Google Sheets action gives you any warnings or errors. It it does - please post a screenshot of the message here.
Running version: 5.6.1.9
Error Log:
2024-05-03 8:00:39 AM Warning in action "Export Google Sheets", table "New Budgets": Replacement of a sheet failed. Temporary sheet 'NewBudgetsByCOA-dd592f0e-6664-4a53-a88c-f0276d7accba', created by EasyMorph, wasn't deleted because of the following error: The operation has timed out.
2024-05-03 8:01:21 AM Warning in action "Export Google Sheets", table "Deals": Replacement of a sheet failed. Temporary sheet 'RawData-7caa1bb6-df33-492f-83c5-8e6e37b624ca', created by EasyMorph, wasn't deleted because of the following error: The operation has timed out.
2024-05-03 8:03:05 AM Task failed with 1 error(s).
It seems that the deletion of temporary sheets is timing out. This is very strange because the timeout is 5 seconds, and sheet deletion is a very fast operation. Do your sheets possibly have triggers or something similar that might slow down a deletion operation?
We have multiple data sources being loaded and exported in this project. None of the processes have steps after each export but there's multiple processes running at once.
And what about Google Sheets itself? Is it possible that your sheets have Apps Script triggers or something similar?