Hi @kingsdotter and @cyscaine,
I think you will find the link below helpful for how the basic autofill works and the overall flow of data, refreshes and dependencies.
The new improvements just released, primarily related to autofill for Google Sheets, are described in the following announcement.