trello-dump

This TrelloJobHunt.R script demonstrates using the trelloR package to get useful information out of a Trello board and then collect it together in a table-like format. In this case, it's a board I use for job hunting. The script creates four files:

• An Excel XLSX file that can be used as a convenient activity overview or for further graphic or data processing
• An RDS file (an R-specific format) that can be used for further processing in R. In this project, I use TrelloJobHunt.Rmd for this
• A CSV file that can be imported into an application that uses CSV for importing (like Salesforce or HubSpot)
• A CSV file that preserves the column type info for this CSV file

graph
    Z[Trello] o--o Y(* My Job Hunting Board *)
    Y --> X[Trello API] 
    X <--> W[trelloR package] 
subgraph main
W o--o A[[**TrelloJobHunt.R**]]
end
style main fill:#fff, stroke:#fff, color:#fff

subgraph Use spreadsheet or upload to GoogleSheets
    A --> B[(XLSX file)]
    B --> D[Excel, GoogleSheets, etc.]
    end
    
subgraph For importing back into R for further analysis
    A --> C[(RDS file)]
    C --> E[[**TrelloJobHunt.Rmd**]]
    E --> J[(HTML file)]
    E --> K[(PDF file)]
    C --> F[[Some other R script]]
    end
subgraph For importing into another application
    A --> G[(CSV file)]
    G --> L((*))
    style L fill:#000
    A --> I[(Col types file for CSV)]
    I -.- L
    L --> H[Salesforce, HubSpot, etc.]
    end

Loading

Data collected from Trello entry

Here's how I use some of the Trello features for job hunting and how they are mapped by the script.

• Each Trello card represents a single job opportunity with a unique Trello card ID

• The Trello title is parsed as (company) job into these separate fields

• Each card can be in one of these Trello lists to represent its status in the job-hunt pipeline:

  • Preparing

  • Applied

  • Interview

  • Rejected

  • No Response

  • Offer

  • Acceptance

  • Declined

graph LR
    A(Preparing) -->|Sent| B{Applied}
    B -->|Arranged| C{Interview}
    B -->|Bounced| D[Rejected]
    C -->|Notified| D
    C -->|Notified| E{Offer}
    C -->|Waited long enough| F[No Response]
    B --> |Waited long enough| F
    E --> |Yes| G[Acceptance]
    E --> |No| H[Declined]
    style D fill:#f00
    style F fill:#f00
    style H fill:#f00

Loading

• The Trello label is used to represent the work model for the job:

  • On-site

  • Hybrid

  • Remote

• The Trello date is used to create a completed due date that represents the initial application date

• The Trello description field is used to represent the following information as the first four lines:

  1. Link: the job listing URL (usually on LinkedIn because it keeps expired listings)

  2. Location:

  3. Interview Date: next or last interview

  4. Rejected Date: for explicit rejections not no responses

  Location, interview date, and rejected date all appear as fields

• The remaining lines in the Trello description field are saved as an other notes field

• The Trello card ID is used to reconstruct the created date for the card

Additional generated fields

The script also calculates some additional fields/columns for the spreadsheet:

• An applied week field based on the applied date

• A link to the card in Trello based on a Trello-generated URL for the card

• A link to the job based on the URL derived from the first line of the description field

• A link to a search for the company