Selective Gmail Forwarding & OTP Storage
Budget: $250 – $750 USD
I need a secure mini-service that connects to a user-granted Gmail account, scans incoming messages, and forwards only the ones that match three filters I specify—sender address, keywords in the subject, and keywords in the body. While forwarding, the service must also detect any One-Time Password contained in those messages, capture the code, and write it to a small database table for later retrieval.
Core requirements
• OAuth-based Gmail access so the user explicitly consents and can revoke access at any time.
• Rule engine that lets me add or edit sender and keyword filters without touching the code (a simple JSON or UI is fine).
• Reliable forwarding that preserves the original headers and attachments when they exist.
• Robust OTP parser that recognises common 4-8 digit codes and stores the code, timestamp, original sender, and subject line in a relational table (MSSQL).
• Error handling, logging, and a brief README so I can deploy the service to my on premise server or cloud server or you many need to connect with me to help to deploy the service
Preferred stack
C# with official Google APIs and regex parsing.
Deliverables
1. Source code with clear setup instructions.
2. SQL script to create the OTP storage table.
3. A short walkthrough video or screenshots demonstrating OAuth consent, rule creation, successful forwarding, and captured OTP entries.
If you have prior work on Gmail API integrations or OTP processing, please include a quick note or repo link in your bid.
Core requirements
• OAuth-based Gmail access so the user explicitly consents and can revoke access at any time.
• Rule engine that lets me add or edit sender and keyword filters without touching the code (a simple JSON or UI is fine).
• Reliable forwarding that preserves the original headers and attachments when they exist.
• Robust OTP parser that recognises common 4-8 digit codes and stores the code, timestamp, original sender, and subject line in a relational table (MSSQL).
• Error handling, logging, and a brief README so I can deploy the service to my on premise server or cloud server or you many need to connect with me to help to deploy the service
Preferred stack
C# with official Google APIs and regex parsing.
Deliverables
1. Source code with clear setup instructions.
2. SQL script to create the OTP storage table.
3. A short walkthrough video or screenshots demonstrating OAuth consent, rule creation, successful forwarding, and captured OTP entries.
If you have prior work on Gmail API integrations or OTP processing, please include a quick note or repo link in your bid.