Run Dimensions API queries from Google Sheets

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