Web search within Sheets

GPT for Sheets, powered by Perplexity AI, helps you retrieve information from the web or from specific websites in bulk directly within Google Sheets. This guide walks you through generating descriptions for a list of companies using a web search from Google Sheets and optimizing these results.

Step 1: Get started

Prerequisites

• You have installed GPT for Sheets.
• You have opened a spreadsheet containing text for the web search in a column.

Open the GPT for Sheets add-on and run the Search the web bulk tool with question Write one sentence to describe this company: on a few rows to see how it works.

If you find the answers satisfactory, go ahead and launch your bulk web search! Otherwise, check how to improve your results in Step 2.

Step 2: Improve your results

If your results are not satisfactory (e.g., information is inaccurate, incomplete, or not relevant to your needs), you can improve them with the following approaches:

Goal	Recommended approach
Improve result accuracy	Analyze the sources Use the Show sources option to understand where the information comes from and assess its reliability.
Refine search results	Narrow down the search Edit your question to provide more context. For example, provide the company website URL instead of providing a company name.
Ensure all URLs are processed	Check the URLs provided Check that all URLs start with http:// or https:// Check that all URLs are publicly accessible and not behind a login page Note: Some websites like LinkedIn block automated web scraping, so you may need to use a different source.
Handle complex tasks	Break down complex tasks For multi-steps analysis, search the web to retrieve the information, then process the results with the most adapted bulk tool or GPT function. For example, you can use the Search the web bulk tool to generate a description for a company based on their website, then use the Classify bulk tool to define the company's industry based on the information retrieved.
Handle missing information	Provide a fallback plan Edit your question to specify what to do when the answer cannot be found. For example: If the company's website does not provide the information, say "Information not found". This prevents the bulk tool from returning irrelevant information.

Once you have refined your search method and are satisfied with the results from the initial rows, you are ready to launch your bulk web search. Select more cells or even all cells, click Run rows, and watch GPT for Sheets handle the rest of the web searches.