This video walks through how to read and write to Google Sheets using a Node JS server with just one script file. Paired with pm2 and node-cron, this can be used to scrape data from the web and store it on a Google Sheet. The walk through includes how to set up a Google Cloud project (GCP), enabling the correct API, and creating the proper authorization settings. Links: Google Develops Read from Google Sheet using Node tutorial: https://developers.google.com/sheets/api/quickstart/nodejs Daily Dev Tips Writing to Google Sheet using Node blog post: https://daily-dev-tips.com/posts/nodejs-write-data-in-a-google-sheet/ Google Cloud Console: https://console.cloud.google.com/
This video walks through how to read and write to Google Sheets using a Node JS server with just one script file. Paired with pm2 and node-cron, this can be used to scrape data from the web and store it on a Google Sheet. The walk through includes how to set up a Google Cloud project (GCP), enabling the correct API, and creating the proper authorization settings. Links: Google Develops Read from Google Sheet using Node tutorial: https://developers.google.com/sheets/api/quickstart/nodejs Daily Dev Tips Writing to Google Sheet using Node blog post: https://daily-dev-tips.com/posts/nodejs-write-data-in-a-google-sheet/ Google Cloud Console: https://console.cloud.google.com/