Access Google Indexing in Excel

Data results output in Excel

The Indexing API allows any site owner to directly notify Google when pages are added or removed. This allows Google to schedule pages for a fresh crawl, which can lead to higher quality user traffic.

Mode

Update - Notify Google of a new URL to crawl or that content at a previously-submitted URL has been updated.

=Connector("GoogleIndexing.GoogleIndexing";{url};"URL_UPDATED")

Remove - After you delete a page from your servers, notify Google so that we can remove the page from our index and so that we don't attempt to crawl the URL again.

=Connector("GoogleIndexing.GoogleIndexing";{url};"URL_DELETED")

Access

To use the Connector you need an account connected to Google.

  1. The Connector is located under the SeoTools main under the SEO category. Click on 'Sign in with Google':
    Login to your account

Creating your own app

These steps are recommended because you will have your own rate limit which means more daily requests.

  1. In the Google API Console, click "Create Credentials"
  2. Chose "Oauth Client ID"
  3. Chose "Desktop App"
  4. Chose a name and create the app
  5. Copy the Client ID and Client Secret
  6. Open GoogleIndexing.xml, located in the folder "Connectors" in the SeoTools install directory
  7. Paste the Client ID and Client Secret to the empty attributes in the tag GoogleOAuth2Authenticator at the top
  8. In SeoTools, chose "Reload Settings" under Settings
  9. Open up the Google Indexing connector, sign out then sign in again and authenticate your own app.

Contribute

This connector suite is open-sourced on GitHub.

See

Official Documentation

Related Functions

Get help with this function in the community →