See how Dataclay's Templater Bot plugin for Adobe After Effects monitors a data source (Google Sheets in this case) and both versions and renders new jobs when the status is changed to "ready." Jobs are processed on demand without the need to manually operate After Effects. Templater can be run from a physical computer system or on a virtual machine with AE installed in the cloud.
Download a free 30-day trial of Templater at: https://dataclay.com/templater