MailSpreader

📧 Automate LinkedIn-based mailings

MailSpreader is a Python command-line tool to automate LinkedIn-based mailings. It collects company profiles, extracts metadata, finds emails, generates summaries, and exports data into a spreadsheet-ready format.

Installation

Clone and install directly from GitHub:

pip install git+https://github.com/mpek29/MailSpreader

Usage

mail-spreader [OPTIONS] COMMAND [ARGS]...

Global Options

  • --install-completion → Install shell completion for the current shell
  • --show-completion → Show shell completion script
  • --help → Show this message and exit

Available Commands

Command Description
list-industries-to-linkedin-url Convert a list of industries into LinkedIn URLs
linkedin-url-to-profil-json Convert LinkedIn URLs into a JSON list of company profile URLs
profil-url-to-metadata-json Convert company profile URLs into JSON metadata
metadata-json-to-email-json-auto Generate a JSON of emails from metadata JSON (automatic mode)
metadata-json-to-email-json-manual Generate a JSON of emails from metadata JSON (manual/operator-assisted)
metadata-json-to-summaries-json Generate a JSON of business summaries from metadata and config
summaries-json-en-to-fr Translate summaries JSON from English to French
metadata-email-json-to-spreadsheet Merge metadata, email, and summaries JSON into a CSV spreadsheet

Example Workflows

Convert industries YAML into LinkedIn URLs

mail-spreader list-industries-to-linkedin-url industries.yaml -o urls.yaml

Convert LinkedIn URLs into JSON

mail-spreader linkedin-url-to-profil-json config.yaml -o profiles.json

Convert profiles JSON into metadata JSON

mail-spreader profil-url-to-metadata-json config.yaml profiles.json -o metadata.json

Extract emails automatically from metadata

mail-spreader metadata-json-to-email-json-auto metadata.json -o emails.json

Extract emails manually with operator assistance

mail-spreader metadata-json-to-email-json-manual metadata.json -o emails.json

Generate business summaries

mail-spreader metadata-json-to-summaries-json config.yaml metadata.json -o summaries.json

Translate summaries from English to French

mail-spreader summaries-json-en-to-fr summaries.json -o summaries_fr.json

Export all data into a spreadsheet

mail-spreader metadata-email-json-to-spreadsheet metadata.json emails.json summaries.json -o prospects.csv