What is this?

This repository manages a google spreadsheet in which leet code users (volunteers) have to mandatorily solve a specified number of questions each week. Furthermore, if they fail to do so, the repository will mark them Dead on the sheet and will not track their progress any further.

How does this work?

There are two workflows (update and reset). The update workflow scrappes the latest 15 questions done by each alive user every 15 minutes. If any questions match the questions allocated this week, the workflow will mark it as Done. The reset workflow triggers once a week (Tuesday 00:00 AM (GMT) or 05:30 AM (IST)), and for any user if not found Done for questions allocated this week, the workflow will mark them as Dead and not track their progress any further.

How to set this up for yourself?

Note: Volunteers do not have to set up.
Just solve questions mentioned in the spreadsheet.

1. Fork this repository.
2. Import this csv template into your spreadsheet.
3. Replace sample usernames with actual leet code user names.
4. Get spreadsheet id from the sheets url. For example, spreadsheet id for this url would be 1NcB1bmKRg-j56KUsd7WNHYpkVBx0S7Jkr26LyeJW8HQ.
5. Replace the SPREADSHEET_ID with yours.

   please-hire-me/src/spreadsheet_editor.py

   Line 10 in 579b9b6

   SPREADSHEET_ID = "1NcB1bmKRg-j56KUsd7WNHYpkVBx0S7Jkr26LyeJW8HQ"

6. Follow this blog or watch this video on how to setup google speadsheet api in your google cloud project.
7. Then set up a repository secret using this, having following credentials.

   Name: "TOKEN_JSON"
   Secret: <token.json-file> // made during the previous step