Hola @raquelchaicoj : yes, giving the authorization is safe : you can actually see the script itself in the google sheet code.
If you want, here is an updated Google Sheet template , which allows :
-
to enter and remove your token via a menu
-
to dowload data using synchronous exports (previously created using this procdedure : https://support.kobotoolbox.org/synchronous_exports.html )
-
set-up and remove triggers via a menu to automatically refresh the downloaded data
-
upload “simple” submissions to a survey … This feature uses a quick and dirty implementation of “csv_import” V1 Api, which has some constraints (it doesn’t work with repeated groups nor with media type data, and it can easily lead to duplicates if the process is not well controlled) … It can however be useful, especially when you want to transfer the ownership of a survey to another user (by uploading selected data in an empty clone of the initial survey) … use at your own risk …only if you know what you are doing ! (preferably on a blank survey)
