Skip to content
This repository has been archived by the owner on Apr 5, 2024. It is now read-only.

Releases: hyouteki/please-hire-me

1.0.0

01 Dec 07:35
5ba8f01
Compare
Choose a tag to compare

Update   Reset   License: MIT

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, 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.
    https://github.com/Hyouteki/please-hire-me/blob/579b9b677db0fcb30f5642de9720016099540c8f/src/spreadsheet_editor.py#L10
  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

What's Changed

New Contributors

Full Changelog: https://github.com/Hyouteki/please-hire-me/commits/1.0.0