for your basic setup you could easily use a timline and a scalar parameter in your material. the scalar param would control opacity and the timline would set the parameter value. its a pretty basic script show below.
