SMS automation with google sheet data backbup

₹1500-12500 INR

Completed

Posted 4 months ago

₹1500-12500 INR

Paid on delivery

I receive sms from few numbers (These numbers have to be stored as “Allowed List”). Messages from only these numbers have to be further processed. The message will have 12 digit numbers along with letters like A/V/J/B ( may be capital or small letters). Like “Allowed List”, few more number should be stored as “Forwarding Number” which will be used for forwarding messages to different number which are “Forwarding Number”. There are 4 different “Forwarding Number”. They are 1st Number, 2nd Number, 3rd Number & 4th Number. Messages have to be forwarded via SIM1/SIM2 (One time setup). If message contains “A” then copy only 12 digits from message & forward it to 1st number & if “V” then forward it to 2nd Number & if “J” then to 3rd number & if “B” then to 4th number. While forwarding to 4th Number , add Getloc before number & forward only 10 digits (leave 1st & 2nd digits) & send. Reply comes for all the sent message. The messages that are sent to 3rd & 4th Number, reply comes from same number except 1st & 2nd Number. For 1st Number, reply comes from LEALOC-S and for 2nd Number reply comes from CELLOC. The reply message has to be sent to sms originator through WhatsApp. This is my project details. I want all the messages that are processed in this case has to be stored in google sheet. I Want to “Allowed List” to be changed easily whenever number and forwarding number and should be easily changeable. I need security & validity related settings. This taak should run if IMEI is allowed & if it has validity.

Project ID: 40191066

About the project

7 proposals

Remote project

Active 4 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@tranquilai

Hi there, this is an interesting SMS automation flow and the logic is very clear. The approach would be to build a background Android service that listens only to messages from the Allowed List, parses the mixed alpha numeric content, and routes the extracted digits based on A, V, J, or B rules exactly as described. SIM selection for forwarding will be configurable once, and forwarding formats will differ correctly for each destination including the special Getloc and digit trimming case. Allowed List, Forwarding Numbers, SIM preference, IMEI whitelist, and validity period will all be managed through a simple settings screen so updates never require code changes. Replies from LEALOC-S, CELLOC, and direct numbers will be captured, mapped back to the original sender, and pushed via WhatsApp automatically. Every processed message, forward, and reply will be logged into Google Sheets securely. Security checks like IMEI validation and expiry enforcement will run before any processing starts. Happy to clarify edge cases or platform preferences.

₹5,000 INR in 4 days

0.0

(0 reviews)

0.0

7 freelancers are bidding on average ₹6,071 INR for this job

@larsenm2020

As a creative problem solver, I am confident in my ability to design an automated SMS system that fulfills every aspect of your project brief. My strong proficiency in automation and data processing work perfectly align with the task you've outlined. Throughout my career, I've been invigorated by challenges like these which demand a blend of smart programming and strategic thinking. Among my notable skills is my expertise in working with Google Sheets, where I can efficiently set up a system for storing all processed messages from your "Allowed List". My familiarity with different handling conditions specified in the task, from forwarding specific messages to different numbers based on unique indicators, to adding 'Getloc' before 4th Number, showcases my thoroughness and attention-to-detail – vital elements when establishing robust workflows. Lastly, your emphasis on security and validity hasn't gone unnoticed. Rest assured, your system will be fortified. Only IMEIs allowed will run the process and I'll ensure there is a built-in check for expiry or validity dates to constantly maintain the integrity of the system. I’m excited about the opportunity this project presents to not only apply my skills but also learn and implement new things - making me the perfect candidate for this challenging project! Let's collaborate on building efficient solutions for your business needs!

₹7,000 INR in 7 days

5.0

(4 reviews)

2.8

@raiha2

Hi, I’m an AI Agent Developer, Automation Specialist, and Full-Stack Developer focused on building agentic systems, LLM integrations and scalable web applications that optimize business processes like yours. Let’s discuss your project, flexible pricing available. Fast delivery | Perfect implementation | 100% satisfaction

₹5,000 INR in 1 day

0.0

(0 reviews)

0.0

@ariyot8

Hi! ? I can help you build a secure and reliable SMS automation system that does exactly what you described, including SMS automation with google sheet data backbup for full tracking and reporting. I have hands-on experience with SMS parsing, conditional forwarding logic, SIM-based routing (SIM1/SIM2), and WhatsApp message automation. I can set up editable Allowed Lists and Forwarding Numbers so you can easily update them anytime without touching the core logic. The system will accurately extract digits, handle A/V/J/B conditions, manage special formatting rules (like Getloc and digit trimming), and correctly map replies (including LEALOC-S and CELLOC) back to the original sender via WhatsApp. All processed messages will be logged securely in Google Sheets, and I’ll implement IMEI-based validation, validity checks, and security controls to ensure the task runs only on authorized devices. Happy to discuss the best tech stack and get this running smoothly for you. Looking forward to working together!

₹1,500 INR in 3 days

0.0

(0 reviews)

0.0

@sanswrangnarzar1

Hi, my name is sanswrang Narzary. I am belongs to India. Iam interested in this work SMS AUTOMATION.I I am a messenger in online work. I send any messages everywhere because I have already experienced inthis sms task.

₹7,000 INR in 7 days

0.0

(0 reviews)

0.0

@RahulG0804

With my extensive experience in building AI-powered web and automated systems, I'm confident that I can create a robust solution for your specific needs. As you require an SMS automation system with complex logic and data management, my skills in API integration and automation will prove invaluable. Utilizing the Google Sheets API, I can seamlessly store all processed messages and maintain an easily customizable "Allowed List" and "Forwarding Number." Additionally, for forwarding purposes, I can configure the system to consider specific characters in each message (A/V/J/B) and adapt messaging accordingly. In terms of security and validity, I understand the importance of keeping your data safe while ensuring the task meets all necessary conditions such as IMEI validation. To enhance this process, I will incorporate regular updates and a demo before final delivery. So why choose me? Because not only do I deliver on time but ensure my solution has a genuine impact on your businesses by automating manual work, boosting sales, and improving customer satisfaction. Let's get started on this intelligent and efficient SMS automation journey!

₹7,000 INR in 7 days