TG bot + Google Sheets Points Tracking System

Posted 3 weeks ago

Worldwide

Summary

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
  • Intermediate
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Google Apps Script
Google Docs
Nice-to-have skills
Google Sheets
Data Entry
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
Member since Apr 15, 2023
  • Germany
    Munich9:55 PM
  • $132K total spent
    258 hires, 91 active
  • 1,129 hours

Explore similar jobs on Upwork

Job Aggregation and Dashboard CreationHourly‐ Posted 8 months ago
Automation
Data Scraping
Data Extraction
API
UI/UX Prototyping
Web Scraping
Install and Integrate UTM Grabber PluginFixed-price‐ Posted 3 weeks ago
WordPress

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers 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

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo