A command line tool that take as input a list of commission reports in csv format exported from the [Commission report](https://app.hotspotty.net/workspace/helium/commission-reports) section of Hotspotty platform and send a gmail e-mail to each user inside the input reports to inform them about the rewards they'll receive.
Project description
Hotspotty Payment Email
The goal of this project is about developing a command line tool that take as input a list of commission reports in csv format exported from the Commission report section of Hotspotty platform and send a gmail e-mail to each user inside the input reports to inform them about the rewards they'll receive.
Setup your Google account and get the file credentials.json
- Set up a Google Cloud Platform project, click on the hamburger menu, and select view all products. Under the management section, select APIs and services
- Next, select Library and type “Gmail API” in the search bar, and click on the Gmail API card.
- Finally, select the enable the Gmail API button.
- Now, you’ll need to download the client secrets file for your project. Start by selecting create credentials. In this section, select the Gmail API as your preferred API and user data as the type of data you will be accessing.
- To get the OAuth client ID, select your application type as a Desktop App, set the application name, and select create. Next, download and store the credentials in your local file system.
After downloading the secret file, you should have a file in this format:
{
"installed": {
"client_id": "463225603869-un1ijjk75iguesbh4nhclm74edprhj5p.apps.googleusercontent.com",
"project_id": "geocaching-366015",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://oauth2.googleapis.com/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_secret": "TOCSXX-wXkVvnUSGrqC_OcH722jmnFPZHIE",
"redirect_uris": [
"http://localhost"
]
}
}
How to use the script
-
Export a one or more contact commissions as show below in the Commission report section of Hotspotty:
-
See script help to get more details about how to use the script.
hotspotty-payment-email --help
-
Here below a concrete example which assumes that:
- You have followed stesps described in Setup you googl account section and you have a credentials.json file in the local folder.
- You have 2 contact commissions files exported from hotspotty in the local folder called commission-report-1.csv and commission-report-2.csv and these files have ',' as delimiter.
- You have a jinja emial template called mail_template.html in the local folder.
hotspotty-payment-email \ --draft True \ --subject "Hotspot report from 2023/04/01 to 2023/05/01" \ --start 2023-04-01 \ --end 2023-05-01 \ --template "mail_template.html" \ --credentials "credentials.json" \ --delimiter "," \ --reports "commission-report-1.csv" "commission-report-2.csv"
Sample template e-mail
Here below a sample template e-mail that you can use as a starting point to create your own template e-mail:
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<p>
Hi {{name}},<br>
Below the tokens accrued by your hotspot in the following
period: {{start_date}} - {{end_date}}. Payments will be made to your wallet:
<a href="https://explorer.solana.com/address/{{wallet_address}}">{{wallet_address}}</a> and in total you will receive:
<ul>
{% if amount_hnt > 0 %}
<li>{{amount_hnt}} HNT.</li>
{% endif %}
{% if amount_iot > 0 %}
<li>{{amount_iot}} IOT.</li>
{% endif %}
</ul>
</p>
<p>
Thanks,<br>
Bye bye
</p>
</body>
</html>
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file hotspotty_payment_email-0.2.1.tar.gz.
File metadata
- Download URL: hotspotty_payment_email-0.2.1.tar.gz
- Upload date:
- Size: 5.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.3.2 CPython/3.8.7 Darwin/22.4.0
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | ae56cef239adf1ddc492964ef4ffa0d4a7de564b4eb7e6ce5ab9feb57eea72fc |
|
| MD5 | 18ea49978bb0bbe624b9e1e4826114b7 |
|
| BLAKE2b-256 | d8e3ac1f0129a2043e2de8dd7ed48875240102d89873bb180f6ff124c8fe6511 |
File details
Details for the file hotspotty_payment_email-0.2.1-py3-none-any.whl.
File metadata
- Download URL: hotspotty_payment_email-0.2.1-py3-none-any.whl
- Upload date:
- Size: 5.3 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.3.2 CPython/3.8.7 Darwin/22.4.0
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 0dd2f03e80b2d97eb6ec05748d2eb86861b24a078353b262fb4c0c9ab89b3a60 |
|
| MD5 | 0d0b8fd6cfc549e1c107745c142f1fb0 |
|
| BLAKE2b-256 | 04a53bf24ae34c44df2db934249b4808ea6cc6bd7445364c145cad1f8c492219 |
