[NCRC] Google spreadsheets publish
As Administrator, I would like to publish evaluations to Google sheets, In order to share evaluations.
Workflow #1 (closed)
- Access Manuscripts view
- hit Publish action
-
Publish should be done to Google sheets - using API V4 https://developers.google.com/sheets/api/reference/rest -
Published evaluation should append new row to the table in google sheets -
Only successful published evaluations should change status to published -
Check if the article exist in the spreadsheet table, if exist update