Citation Metadata in Sheets

	A	B	C	D	E
1	Citation Metadata Access in Google Sheets
2
3	This Google Sheet shows how data from the Crossref API (3) can be imported and displayed in a sheet based on the DOI entered in row 1 of the 'Worksheet'. Development of this Google Sheet was initiated through work on the IUPAC FAIR Chemistry Cookbook (supported by CODATA under the WorldFAIR project). The intent of this Sheet is to show how an API can be called and how to process the data that is returned to the sheet to add it to other cells. Additionally, Google Sheet functions are used to compile data into specific fields. CrossRef is an important resource as they hold metadata relative to DOI's they mint. A detailed description of how to search the Crossref metadata can be found at (3). There are two sheets in this document. One 'Worksheet' is where a user can enter up to three DOI's and retrieve their metadata, and 'How it works', where an example of how the functions work is shown with notes on the steps. If you wish to add this functionality to your own Google Sheet follow the process in (6).
4
5
6
7
8
9
10
11
12
13
14	Acknowledgement	This Google Sheet was developed as a contribution to the IUPAC FAIR Chemistry Cookbook, funded by the European Union under the WorldFAIR project
15		IUPAC FAIR Chemistry Cookbook		https://iupac.github.io/WFChemCookbook
16		CODATA WorldFAIR Project		https://worldfair-project.eu/
17
18	References	1) Gist by Paul Gambill			https://gist.github.com/paulgambill/cacd19da95a1421d3164
19		2) Google Apps Script			https://www.google.com/script/start/
20		3) Crossref API			https://api.crossref.org
21		4) What is an API?			https://en.wikipedia.org/wiki/API
22		5) What is JSON?			https://en.wikipedia.org/wiki/JSON
23		6) How to add ImportJSON to a Google Sheet			https://apipheny.io/import-json-google-sheets/
24
25	Developed by	Stuart Chalk	https://webapps.unf.edu/faculty/bio/N00002621
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100