Please Hire Me - LeetCode Ques. Tracker

This repository manages a google spreadsheet in which LeetCode 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.

Quick Start

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

1. Fork the repository.
2. Import this csv template into your spreadsheet.
3. Replace sample usernames with actual LeetCode 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.
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
   

Go to top File an issue