Run Dimensions API queries from Google Sheets

previous arrow
_API-connector-slider_00
_API-connector-slider_01
_API-connector-slider_02
_API-connector-slider_03
_API-connector-slider_04
next arrow

The Dimensions API add-on allows you to run Dimensions API queries using the DSL language directly from a Google Sheets window. The results are transformed from JSON to a tabular format, thus allowing further manipulations using the usual Google Sheets tools.

The Analytics API supports extraction of Dimensions data for use in complex analyses and visualizations or the building of analytical tools and reporting templates. The API uses an intuitive query language specifically developed for Dimensions data. You can retrieve, aggregate, and sort data from highly specific requests in a single API call. Additional services like text categorization are also available.

The data accessible

  • Publications
  • Datasets
  • Grants
  • Patents
  • Clinical trials
  • Policy documents
  • Technical reports
  • Researchers
  • Organizations

Technical details

Related Articles

Download form Google marketplace

Get the Google Sheets API Connector from the G Suite Marketplace.
API documentation

Learn how to perform analytics on the Dimensions database using the API.
Dimensions API

Programatically access the comprehensive Dimensions dataset for research and innovation.