Zapier and Google Sheets are both amazing but you cannot pull data into a Google Sheet and then use a Google Sheets formula on the same data 😒. A very simple hack / workaround: Sheet1, pull all of your raw data from Zapier into this sheet; Sheet2, in cell A1 simply enter ={‘sheet1’!1:1009} to copy all data and all future data from Sheet1; then Sheet3, can be used to action any formulas or combine more data.