Excel Add-In for Google Search

Build 21.0.7930

Connecting to Google Search

To establish a connection to Google Search provide a CustomSearchId and APIKey.

Creating a Custom Search Engine

To start searching websites through the add-in, follow the steps below:

  1. Sign into the Google Custom Search Engine site.
  2. Click New Search Engine and add a site to focus the search on.
  3. Click Edit Seach Engine, select your search engine in the menu, and then click Setup.
  4. In the Details section, click Search Engine Id to retrieve the search engine Id used as the CustomSearchId in the connection string.
  5. In the Sites to Search section, you can additionally select the Search the Entire Web but Emphasize Included Sites option in the menu.

Getting the API Key

To authenticate requests to the Custom Search API, follow the steps below:

  1. Log into the Google API console and select a project.
  2. In the side bar under APIs & Services, click Library and then select the Custom Search API. Click Enable.
  3. In the side bar, click APIs & Services -> Credentials.
  4. Click Create Credentials -> API Key.
  5. Select the API Key to restrict the key to your platform.
You can now search the Web using the Google Custom Search engine.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930