add metadata for pretest from google sheet closes #7