Configure this app to access a Google Sheet
one
Enable the Google Sheets API at Step 1 of the Google Node.js Quickstart tutorial and download theClient Configurationfile.
2
Copy theClient Configurationfrom the file downloaded in the previous step, paste it into the text box, and hitEnter. to save it in thesetupdatabase collection.
3
Create a Google Sheet. Copy the URL from the browser's address bar and paste into the text box. HitEnter to save theSheet Idin thesetupdatabase collection.
4
When the GetCodebutton is enabled, click to open the Google page to authorize the app. After the app is authorized, copy theauthorization codefrom the page.
5
Paste theauthorization codeinto the text box and hitEnter. This will generate a refresh token which will be saved to thesetupdatabase collection.
6
After completing the configuration process, go to thehome page of this app and save some data to your Google Sheet.
Clickreset if you wish to reset the configuration and start the process over again.This will clear the configuration data currently saved in the database.