Handling Messy Data
AI Help Chat
The PromptLoop web browsing function lets you find answers from the internet with a fast and accurate spreadsheet function.
=PROMPTLOOP.BROWSER( target, header)
Use the function as you would a normal web search with two inputs, allowing you to search for a list of search queries across rows and columns.
=PROMPTLOOP.BROWSER( target, header, [showSource? 1/0], [verbose? 1/0])
There are also two optional parameters. The first, showSource, tells the function to return the web link from which the information originated from. The AI model browses dozens of pages and will return a link to the page where the relevant answer was found. You must have a blank cell to the right of the target cell to have room to display the link, otherwise, the function will report an error. The second, verbose, tells the function to return the response in sentence or paragraph form.
You can research dimensions of various topics starting with a list of items, companies, people, markets etc. and returning descriptions, figures, and sources.
In addition to getting single search results, you can now use Promptloop to generate lists. The list will be generated vertically, filling new rows below the target cell in the spreadsheet, so there must be blank cells below the target cell. You can also specify the maximum number of results you want contained in your list, through the numResults parameter. Leaving this blank will allow the function to generate as many results as possible.
=PROMPTLOOP.LIST( query, numResults ) Ex: =PROMPTLOOP.LIST( Hedge funds in the US, 5 )
You can also directly browse certain weblinks by adding those links to the target cell.
=PROMPTLOOP.BROWSER( target (as url link), header )
Ex: =PROMPTLOOP.BROWSER( https://en.wikipedia.org/wiki/Empire_State_Building, Height )
The browsing function uses AI models to search the internet, open and browse websites, and process thousands of words to quickly find the answer you are looking for. If the model can't find an answer, it will return "Not Found" and unlike many language models, will not make up answers that it can't find.
Feedback is helpful as we improve the application. New features like this are the product of collaboration with customers like you. If you have any feedback, please reach out!
While PromptLoop Inference can infer answers based on context, if you need facts or current statistics, then the internet is your best source. PromptLoop automatically locates and gathers information from the web.
Some websites that require user log in, like LinkedIn, may not be available for browsing due to limits on what non-users can access.
Because PromptLoop is browsing and processing web results, the formula will be slower than for other functions.
If no results are found or the model is unable to reach a site, it will return "Not Found".
PromptLoop browsing uses an AI driven agent to find and gather information from the web. This uses credits slightly differently than other functions do.
Browsing calls account for a minimum of 50 credits per cell/row which increases depending on the number of pages or results needed to look for the answer.
Provide a topic or query to search for