TG bot + Google Sheets Points Tracking System
Worldwide
We are looking for a developer to build a simple points tracking system using messaging bots and Google Sheets. Project Overview We need a system that allows authorized users to award and deduct points through a messaging bot, while automatically updating balances in Google Sheets. The system will use: * One shared Google Sheet * Two messaging bots connected to the same sheet * Automated balance calculations * Transaction history tracking * Access control for different user groups Bot #1 Can only deduct points. Bot #2 Can both award and deduct points. Main Requirements * Create and configure two bots. * Connect both bots to a single Google Sheet. * Automatically record all transactions. * Automatically calculate current balances. * Maintain a complete transaction history. * Prevent accidental duplicate transactions. * Allow users to view current balances. * Allow users to view recent transactions. * Set up access permissions for authorized users. The input format can be either: * Free-text messages processed with AI, or * A structured command format if it simplifies development and improves reliability. We are open to the developer’s recommendation. Preferred Skills * Bot development * Google Sheets API * Make.com, n8n, Zapier, or similar automation platforms * Python, Node.js, or similar technologies * Experience building workflow automation systems Deliverables * Fully working bot system * Connected Google Sheets system * Automated balance calculations * Transaction logging * Access control configuration * Documentation and instructions for administrators When Applying Please include: 1. A brief description of how you would implement this system. 2. Whether you would use Make.com/n8n or custom code. 3. Estimated timeline. 4. Estimated cost. 5. Examples of similar automation projects you have built. We are looking for someone who can recommend the simplest, most reliable solution rather than over-engineering the project.
$500.00
Fixed-price- IntermediateExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:50+
- Last viewed by client:3 weeks ago
- Hires:1
- Interviewing:11
- Invites sent:18
- Unanswered invites:4
About the client
- GermanyMunich9:55 PM
- $132K total spent258 hires, 91 active
- 1,129 hours
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by