search

cmip6dr / cmip7_forward_look

Collection of documents and issues for CMIP7 data request
0 stars 0 forks source link

Use of Google API to maintain sheets #30

Open martinjuckes opened 5 years ago

martinjuckes commented 5 years ago

There is a google API which supports programmable access to google sheets, e.g. through the python library gspread. Use of the API requires credentials from Google. These are available subject to having an appropriate google account with charging enabled. It is likely that no charges would be incurred by, but an appropriate account is needed.

A 12 month "free trial" is available, which essential gives $300 credit to offset any charges incurred in the first 12 months.

https://console.developers.google.com/iam-admin is the interface.

Ideally, this should be an institutional account.

martinjuckes commented 5 years ago

Discussion with James Grove indicates that this cannot be done through the existing arrangement between NCAS and google (which covers the NCAS web site).

martinjuckes commented 5 years ago

See also https://breezy.badc.rl.ac.uk/spepler/sla_code/blob/master/sla_main.py for code used to write docx files [CEDA internal repository ... login required]