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.
View Original Listing
Unlock AI intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/mo

Client

Spent: $11,527.68Rating: 4.2Verified