Used to generate quality score overview of each listing.
https://www.screencast.com/t/Uoq4pYYs6
- Create new blank google spreadsheet (https://docs.google.com/spreadsheets)
- Copy the unique ID from the URL once the sheet has been created, it looks something like this "15D3nPJZLTAHLQhXo4MSTw4WV3rYbwXlSfX8cTONWD6I" https://www.screencast.com/t/g6BJuIb1
- Take the script: https://github.com/sv-jschwarz/qualityScoreOverview/blob/master/qualityScoreOverview.js and find the phrase "INSERT YOUR SHEET ID HERE", replace that text with your sheetid.
- Click the green share button in the top right corner of the Google sheet window.
- Click "Skip" when asked to name the sheet.
- On the new popup, click "Advanced" in the bottom right corner.
- Click "Change...", and select the "On - Anyone with the link", then "Save": https://www.screencast.com/t/jQ4pwT7jvX
- Then invite this email: "743184255003-2tbvikqou0c38ruhrmddno3kc7hnsmfr@developer.gserviceaccount.com": https://www.screencast.com/t/uPBeGgZwG
- When asked "Are you sure?" that you want to share with the email above, click "Yes".
- Once you've opened the doc to anyone with a link and invited the email above, click "Done".
- Run the qualityScoreOverview.js script in your repl (make sure you updated your sheet id).
- Switch back to your Google sheet page and view your results.
- Share that sheet url with whoever needs to view the results.