Google sheet api

[sabinevidal]

Github Workflow which runs once a day (cron schedule commented out for now) Authenticates to Google Cloud via Workload Identity Federation using the Google auth action. This approach is best for backend communication between APIs, and is safer than the original Google Cloud service keys and is more long-lived than the OAuth token.

Node script then runs which requests the data from the output sheet and then adds it to the training_data file in json format as discussed in #109

Still need to do:

• test workflow, but need to be on the Unicef/kindly repo.
• add secrets to settings for WORKLOAD_IDENTITY_PROVIDER and GOOGLE_SERVICE_ACCOUNT
• add code to script to delete the phrases which have been added to the training data file, (but need to test rest of workflow first)

[sabinevidal]

@nathanfletcher @lacabra: Have created a draft PR to check my logic. I'm not sure of the best way to test as auth is required.

edit: have left the cron job commented until I'm sure my logic is sound as don't want to trigger any errors at 4am!

[lacabra]

The description of this PR does not include a mention about modeling/dataset/luisport_combined.js.

Why do you have this script? and what is it used for?

[sabinevidal]

The description of this PR does not include a mention about modeling/dataset/luisport_combined.js.

Why do you have this script? and what is it used for?

This script was just in the draft until #109 was merged into main. Have now updated!

[sabinevidal]

@nathanfletcher @lacabra : have added the commit workflow to make sure the updated training_data.json file is saved. Just need to insert the email and username. What would you suggest for those? Added my email and username for now.

[nathanfletcher]

new secrets added for further testing cc @sabinevidal