This is a basic Google script for Google spreadsheets that checks for urls in column B of your sheet and outputs the Pagespeed score in the corresponding row in column C.