Q: Hi, again.
I know that using the formula =visit(“https://www.hubspot.com/inbound-marketing“) can allow me to browse this page and extract all the content. However, I would like to know if it’s possible to ask SheetGPT to visit four web pages simultaneously and then provide a unified summary as the output. The idea is to give it four to five high-authority blogs on a single topic for research purposes and then receive a summarized content.
Something like: =visit(“https://www.hubspot.com/inbound-marketing, https://appsumo.com/products/sheetgpt-chatgpt-google-sheets-integration, https://yahoo.com/xyz“)
Also, how do you handle errors? For example, if I run the SheetGPT formula for 1000 rows at once, I know that OpenAI will only process approximately 500-600 rows and then give a time-out or other errors for the remaining rows. How can I run the prompt again for the error fields only, so that I don’t get charged twice for the same field that was already generated before?
Thank you.
Curran35278
May 15, 2024A: Oh as for the error fields...
If you see that, you could set a filter at the top of the column for your AI outputs, then sort A-Z and it would sort all of the errored ones to be next to each other and then you could just copy and paste the function to run it again only for the ones that had an error.
Best,
Curran
To solve for this, I would do 4 different cells of the visit function and then use a prompt like this:
=AI("Here is the exact content from 4 different articles. Extract the key points and give a detailed summary of the most important points across all articles without mentioning them directly. Here are the 4 articles: ", A2:A5)
The only thing I would lookout for there is that it may cause timeout errors when giving that much content to OpenAI at once. If it does, you may want to summarize each article first with AI and then use a prompt to combine them as a third step.
I see the value in what you're doing but we're trying to avoid doing really custom niche functions to keep the tool flexible for all use cases and not overly bloat it with tons of different functions.
I am open to this idea though and if enough people want it, we will come out with a =summarize function though and let you input multiple URLs.
Best,
Curran