insper-education / hermes

Feedback email tool
0 stars 0 forks source link

mailsheet - Sends data with your Google Sheet / Excel sheet

mailgsheet is an application that allows you to easily send row data extracted from a Google Sheet / Excel document for every e-mail in a user defined column.

System Requeriments

Quick Start

For Google Docs access

Authenticate your mail provider

Command Line Usage

Parameter Description Example
sheet_url Google Sheet URL or Excel file path (xlsx) http://sheets/d/XXXXXXXXXXXX/edit?usp=sharing
sheet_name Sheet name Page1
sheet_range Range where all data is contained A:N - A column to N (all rows)
--sends-as-file Sends an Excel sheet per row as attachment with only the row kept (and formatting)
--header-lines Specify line number where header is contained 1-3 or 1
--rows-start Specify where the table data starts (default: line after header) 4
--mail-column Name of the column where e-mails are stored (one per row) Mail
--dry-run Output resulting e-mails in screen and don't send
--mail-credentials-path Specify path to mail credentials (for sending mails) Check mail_credentials_example.json
--google-credentials-path Google App Credentials Json file
--debug Enable debug printing
--verbose Enable debug printing
--debug-force-to Forces all mail be sent to specified e-mail myemail@provider.com
--add-cc Adds an e-mail to cc field (copy) manager@mycompany.com
--debug-send-interval-start Sends only mails in specified interval 3 (first three e-mails are ignored)
--debug-send-interval-end Sends only mails in specified interval 7 (sends only up to seventh e-mail).

License

GPL v2.0