Here are the 3 formulas I used:
1) =index(split(importxml(A2,”//meta[@property=’og:description’]/@content”),” – See”,TRUE),0,1)
2) =ArrayFormula(value(IFERROR(LEFT(C2,LEN(C2)-1)*LOOKUP(RIGHT(C2),{“K”,”M”},{1000,1000000}),C2)))
3) =D2 [copy and paste this column but with values only so if the formulas load again it won’t mess up the result it already found before]
Subscribe to learn more up-to-date tactics for getting clients! https://www.youtube.com/@shortformscriptwriter
p.s. the outreach video is not uploaded yet
source
