56
Google Sheets Automation + Telegram Alerts for Gift Card Rate Opportunities
UpworkUSNot specifiedintermediate
Google SheetsAutomationData EntryData Scraping
I’m looking for a developer to build a simple automation system that monitors gift card bonus offers from one platform and resale rates from another platform. The goal is to automatically identify profitable opportunities and notify my team when they appear.
Currently this process is done manually and takes time. I want a small dashboard that automatically compares the rates and highlights good opportunities.
What the system should do
1. Data monitoring
Track gift card bonus offers from a platform where gift cards are received (example: Prizeout) and compare them against resale rates from a platform that buys gift cards (example: CardCash).
2. Google Sheets dashboard
Create a clean dashboard that shows:
Brand
Bonus percentage from the receiving platform
Resale payout percentage from the buying platform
Gift card type (digital vs physical)
Calculated return percentage
Profit opportunity indicator
Last updated timestamp
3. Digital gift card filter
The buying platform has both physical and online gift cards. The system should filter and track digital gift cards only, since those are the ones we focus on.
4. Opportunity detection
The sheet should automatically calculate profitability. If the calculated return exceeds a configurable threshold (example: 90%), the system should flag the opportunity.
5. Alerts
Send automated alerts via Telegram or email when opportunities appear.
Example alert
Brand: Ulta
Bonus: 18%
Resale payout: 92%
Type: Digital gift card
Calculated return: 90%+
Status: Opportunity detected
6. Configurable settings
The system should allow easy configuration for:
Alert threshold (example: 90%)
Brands to monitor
Alert destination (Telegram or email)
Update frequency
7. Reliability
The system should run automatically on a schedule and include basic error handling so the dashboard continues updating consistently.
Technical preferences
Google Sheets dashboard
Google Apps Script, Python, or n8n
Telegram bot integration for alerts
Clean, maintainable setup
Deliverables
Working Google Sheets dashboard
Automated rate updates
Telegram or email alert system
Short documentation explaining how to maintain the system
Budget
Open to proposals.
If you’ve built similar monitoring dashboards or automation systems before, please include examples.
Unlock AI intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/moClient
Spent: $11,527.68Rating: 4.2Verified