SheetMagic: ChatGPT + Google Sheets Integration

Product details

Q: How would you visit and scrape data from multiple URL's recursively using this tool?

For example if I want to scrape 20 URL's from a given column to use as context to write a blog post about?

Can this tool search for SERP data on Google or just DuckDuckGo?

Cory29903PLUSSep 8, 2023
Founder Team
Curran35278

Curran35278

May 14, 2024

A: If you had all the URLs in Column A starting at A1, you could do this:

=visit(A1)

And then copy that cell and paste it down for all 20 and it will automatically update the row for each one when you paste it.

Currently, the tool searches DDG as Google has a ton of safeguards in place to prevent scraping, so DDG was much more reliable to work with.

Share
Helpful?
Log in to join the conversation
Verified Purchaser badge

Verified purchaser

Posted: Sep 8, 2023

Thanks, also can your tool scrape YouTube video transcripts from the URL?