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

Dimensions is an award-winning scholarly information database containing linked metadata records for millions of publications, patents, clinical trials, grants, policy documents and datasets. For more information, see http://dimensions.ai/

Dimensions contains a network of more than 100 million records connected by billions of links. This vast information landscape supports a myriad of business and analytical needs. Making data available in ways that are useful to the research community is a key priority for the Dimensions team, so we’ve designed several API services with your needs in mind.

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.

Explore the following resources to find out more: 

* https://www.dimensions.ai/dimensions-apis: Dimensions API products homepage.
* https://docs.dimensions.ai/dsl: API documentation (in-depth).
* https://docs.dimensions.ai/dsl/gsheets.html: Gsheets add-on documentation.
* https://api-lab.dimensions.ai: Sample research data analysis notebooks.