Q: Does the scraper function require us to copy and paste the actual web address into the function?
If so, why? That means manual labour for every single cell. Why can't it just refer to another cell, say, B2, where the URL is written?
Because most of us will have long lists of URLs, and we just want to copy down the formula to the whole column, thereby eliminating a massive amount of labour.
Or am I getting something wrong here?
Curran35278
May 14, 2024A: The scraper function can work either manually or automatically.
Manual: =visit("https://hubspot.com")
Auto: =visit(A2)
It's like that with every function too where if you're referencing a cell, you don't put it in quotes, but if you're putting the data in manually, you put it in quotes.
Hope that clarifies that :)
Best,
Curran
applad1PLUSJust another point on this one. I've managed to hack my way through with CONCAT formula, but despite being able to copy and paste the right scraping formula all down the column now, it doesn't set it off in every cell. It appears that it is necessary to go in and set off every one individually still.
applad1PLUSWow, that's working now, and it's AWESOME! Thanks!