@pbretz
The jobs being left in a state of “processing” in Google Sheets is actually a bug left over from the way the Google API updates when footage is missing. Technically speaking, the render-status should be changed to “done” in the Google Sheets since it completes the Job with the option set in the Templater Preferences dialog.
This was a scenario we likely should have envisioned in the past, but our assumption was that customers would use Spot Checks rather than the render-status to check for outputs with missing footage.
Either way, we’ll see about implementing some sort of flag to indicate Jobs that complete with missing assets.
Thanks,
Jeff