Google Sheets Integration

Application has a web page with two buttons: Create Sheet and Open Sheet. When user clicks on Create Sheet, client-side JavaScript must be used together with Google API to use the provided instance id (let's call it hello123) to a. Copy [login to view URL] that exists on the specified Google Drive folder to [login to view URL] in the same folder, and b. Present a confirmation message to the user, "Sheet hello123 created". When user clicks on Open Sheet, client-side JavaScript must be used together with Google API to use the provided instance id (hello123) to a. Open [login to view URL] (that exists in the specified Google Drive folder ) in a new browser tab. Google drive folder will be specified as a folder hierarchy, e.g., /myProjects/currentProject/docs. You must deliver code and related tests, scaffolding, etc. that will allow us to sufficiently test the functionality. You must provide links to external libraries that you may have used to complete this project. Such libraries must be open source or provided by Google for integrating with Sheets and Drive. You must use your own API developer keys to develop and test this. We will replace those keys with ours when we test and accept your code.