336 sync nominations

[floresjmjr]

Zenhub Link:

https://app.zenhub.com/workspaces/ksf-5f23520d91f7ee00134cbaf6/issues/the-difference-engine/ksf/336

Describe the problem being solved:

Sync data between the google sheet and command center 3x a day (7AM, 12PM, and 5PM) The command center should display incremental (new) files to view for the automatic syncing of files. The new applications should reflect the correct Application Name, HP Name, Family Member Name, Submission Date, and Stage

Impacted areas in the application:

Based on the changes we made it will be adding a file (daily-sync) and using existing functionality (gsheetToDB function). The other two problems were already solved but we verified that it worked.

Describe the steps you took to test your changes:

I ran the script 'daily-sync' after dropping the database and refreshed screen and nominations were updated. If you don't drop database, you're probably going to get an error where the reminderSent column is missing or something to that effect. This may require altering the database and querying records that have this column and removing it. This still needs to be setup in the heroku scheduler. Need to create 3 jobs, 12pm UTC, 5pm UTC, 10pm UTC

If this ticket involves any UI or email changes, please provide a screenshot that shows the updated UI

N/A

List general components of the application that this PR will affect: api/helper/dailySync.js api/package.json

PR checklist

• [x] I have linked the PR to a Zenhub ticket
• [x] I have checked for merge conflicts

[vhoof]

Talked this out synchronously, it was fixed when they dropped the column in the last pr.