
Closed
Posted
Paid on delivery
I have a raw list of about 10,000 phone numbers that needs to live in a single “Master” tab inside Google Sheets. From there, every time I type a note in the Call Notes column, that row must instantly surface in one of three working tabs: • Reattempt – when the note contains “did not answer” • Alternate Method – when the note contains “did not want our services” • Follow-Up – when the note contains “interested” The logic has to be dynamic because notes will be entered manually, row by row, as the calling team works. I don’t want to copy-paste or run a filter each time; the sheet should recognise the text string and show the record in the correct tab automatically while always preserving the full record in Master. I’m open to the cleanest approach—array formulas, FILTER/QUERY, REGEX, or a light Apps Script, whichever keeps the file fast and easy for non-technical colleagues to maintain. If additional statuses appear later I should be able to edit the logic myself without rewriting the whole thing. Deliverables 1. Google Sheets file (or template) with: – Master tab pre-loaded with the 10k numbers and heading structure – Three child tabs wired to the rules above and auto-updating 2. Clearly commented formulas or script so I can tweak terms or add extra statuses later 3. One-page setup/use guide or short screen-recording showing how it all works and how to extend it Acceptance criteria: typing the exact strings above in the Call Notes field instantly routes the row to the correct tab, with no manual refresh required, and deleting or editing the note updates the routing accordingly. That’s the entire scope—looking forward to your best, simplest solution.
Project ID: 40699380
144 proposals
Remote project
Active 15 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
144 freelancers are bidding on average £123 GBP for this job

⭐⭐⭐⭐⭐ Create Dynamic Google Sheets for Phone Number Management ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project details and see you're looking for an efficient Google Sheets solution for managing phone numbers. You don't need to look any further; Zohaib is here to help you! My team has completed over 50 similar projects for Google Sheets automation. I will create a dynamic system that updates automatically based on your notes, ensuring seamless workflow without manual effort. ➡️ Why Me? I can easily build your Google Sheets setup as I have 5 years of experience in spreadsheet automation, data organization, and formula creation. My expertise includes Google Sheets functions, Apps Script, and data management. Additionally, I have a strong grip on other relevant technologies, which allows me to deliver a comprehensive and user-friendly solution. ➡️ Let's have a quick chat to discuss your project in detail. I can provide samples of my previous work and demonstrate how I can meet your needs effectively. Looking forward to our chat! ➡️ Skills & Experience: ✅ Google Sheets ✅ Data Management ✅ Apps Script ✅ Formula Creation ✅ Data Validation ✅ Automation Techniques ✅ Dynamic Filtering ✅ User-Friendly Design ✅ Troubleshooting ✅ Data Analysis ✅ Reporting ✅ Documentation Waiting for your response! Best Regards, Zohaib
£150 GBP in 2 days
8.0
8.0

Warm Hello! I can build a fast, maintenance-friendly Google Sheets workflow that automatically routes 10,000+ records based on Call Notes while keeping the Master tab fully intact. I have over 9 years of experience in this field, with strong expertise in Google Sheets, ARRAYFORMULA, FILTER, QUERY, REGEX, and lightweight Apps Script automation. I’ll ensure routing updates instantly when notes are added, edited, or deleted, with clearly documented logic that your team can easily modify later. Here's how I can help: • Pre-load and structure the 10k-number Master tab • Create dynamic Reattempt, Alternate Method, and Follow-Up tabs • Route records automatically based on exact note strings • Preserve the complete Master record at all times • Add comments/documentation and a simple setup guide Do you prefer a formula-only solution for easier maintenance, or is lightweight Apps Script acceptable? Will each status always use the exact phrases provided, or should matching allow additional text around them?
£135 GBP in 7 days
7.3
7.3

Hi there, I understand this project requires one Master tab containing the full 10,000 phone-number list, plus three connected working tabs that automatically surface each record based on the Call Notes entered by the team. I’m confident I can build this with the dynamic, reliable, and easy-to-maintain structure you’ve specified. My approach is to keep Master as the single source of truth and use dynamic FILTER/QUERY/REGEX logic to automatically route each row into Reattempt, Alternate Method, or Follow-Up when the specified note text is entered. The child tabs will update instantly when notes are added, edited, or deleted, while the complete record remains preserved in Master. I’ll structure the routing logic so additional statuses or keywords can be added later without rewriting the entire setup, while keeping the sheet fast and simple for non-technical users. You’ll receive the Google Sheets file pre-loaded with the 10k numbers and required headings, three auto-updating child tabs, clearly commented formulas or script, testing against the acceptance criteria, and a concise setup/use guide explaining how to maintain and extend the routing rules. Should I structure the routing rules through a separate configurable keyword/status mapping section, so you can add or edit statuses yourself later? I’m ready to start immediately. Warm Regards, Aneesa.
£100 GBP in 1 day
7.2
7.2

Hi, I can build this Google Sheets system with a fast, clean dynamic setup for your 10,000 records. I’ll configure Master + 3 auto-updating tabs using FILTER/QUERY or Apps Script, with editable logic for future statuses. I’ll also provide clear comments and a simple setup/use guide. The routing will update instantly when notes are added, edited, or deleted. Ready to start.
£100 GBP in 1 day
6.7
6.7

Hi, I reviewed the project and understand that 10,000 phone numbers must remain in one Master tab while Call Notes automatically route each record into Reattempt, Alternate Method, or Follow-Up. I can build a fast Google Sheets solution using Software Architecture with dynamic FILTER, QUERY, and REGEX logic, or a light Apps Script where appropriate. Data Management will keep the complete record preserved in Master, while clearly commented formulas or script will make status terms easy to edit and extend. I’ll also prepare the setup/use guide showing the automatic routing and update behavior. I’ll keep the workbook clean, reliable, responsive, and easy for non-technical colleagues to maintain, including edits and deleted notes. Let’s discuss here now.
£250 GBP in 30 days
6.5
6.5

AVAILABLE TO START IMMEDIATELY..,,. I will deliver a fully automated Google Sheets solution with dynamic call routing via custom Apps Script or advanced array formulas (FILTER/QUERY/REGEX), comprehensive formula comments, and a detailed setup guide/video. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
£51 GBP in 1 day
6.7
6.7

Hi there! Project is very clear to me and I can build a dynamic Google Sheets system for your 10,000 phone numbers with Master, Reattempt, Alternate Method, and Follow-Up tabs that update automatically based on Call Notes. I can use clean formulas or Apps Script with easy-to-edit logic and provide a simple guide. Just message me I am ready to start now. Thank you.
£21 GBP in 1 day
6.9
6.9

Hello, I’ve reviewed your project and can help clear the old transactions from reconciliation across your QuickBooks accounts accurately and efficiently. I have experience with QuickBooks, Excel, data processing, reconciliation, and data management. I’ll carefully review each transaction and make sure the cleanup does not affect valid records or account balances. I’ll also check the accounts after the cleanup to ensure everything is properly reconciled and there are no obvious errors or discrepancies. Accuracy and attention to detail will be my top priority, especially when working across multiple accounts. I’m ready to start immediately and complete the work efficiently. I look forward to working with you.
£30 GBP in 1 day
7.1
7.1

Your requirement for an automated Google Sheets call routing solution is clear. I can create a Google Sheets file with a “Master” tab containing your 10,000 phone numbers and establish dynamic routing to three separate tabs based on specified notes using Google Apps Script or advanced functions like FILTER/QUERY. This setup will ensure that whenever a note is entered, the corresponding row automatically updates without needing refreshes or manual filters. I have strong skills in Google Sheets and automation technologies, with a track record of a 4.9-star rating across 200 reviews and 220 projects completed. What specific features would you like to implement for the guide or screen recording?
£213 GBP in 5 days
6.4
6.4

10,000 numbers in a Master tab, notes typed row by row, and each row surfacing in Reattempt, Alternate Method or Follow-Up the moment the note matches. Formulas alone get slow at that size, so the design has to be deliberate. How I would build it: - Working tabs driven by FILTER and REGEXMATCH over the Master tab, case-insensitive, so a typed note appears in the right tab instantly without scripts - Match rules held in one small config range, so you can change the trigger phrases without touching formulas - Master tab protected so the calling team edits only the notes column - If 10,000 rows makes the formulas sluggish, an Apps Script on-edit trigger as the fallback, moving just the changed row - Short guide for the team I build data tooling and automation used daily by operations teams, in production. I can deliver in two days. One question: should a row disappear from a working tab when the note changes again, or stay with history? Martin
£100 GBP in 2 days
6.5
6.5

With over 5 years of experience in data management and software architecture, my team at Web Crest is well-equipped to tackle your call routing automation project. I understand the criticality of streamlining your data as seamlessly as possible through Google Sheets, and I assure you that I will deliver a solution precisely efficient and user-friendly. Coming from an AI-driven solutions background, I am adept at crafting intelligent automated processes. For this project, we can implement an array formula or a light Apps Script to dynamically recognize the specific text strings in your Call Notes column. This approach not only keeps the files running fast but will also enable you to easily modify or extend the logic yourself, without rewriting the entire system. Moreover, I guarantee comprehensive documentation accompanied by short screen-recordings showing how your new automated workflow operates and can be further customized. Our aim is to empower you and your colleagues to independently maintain and scale the system. From streamlining workflows to delivering insightful output reports, with me on your project, you can expect an optimally-functioning solution catered perfectly to the nuances of your business.
£100 GBP in 3 days
6.5
6.5

Hi, I can build this Google Sheets system so your calling team only needs to update the Call Notes column, and the records automatically appear in the correct working tabs. The Master tab will always keep the complete list of 10,000 numbers. I’ve worked with Prospect Direct, a US-based company, since 2018, supporting lead generation, data management, and calling operations. I’ve also managed teams of 50+ people, so I understand how important it is to keep a shared sheet simple, reliable, and easy for non-technical team members to use. For your project, I would use a clean Master sheet with dynamic FILTER/REGEX formulas or a lightweight Apps Script if needed. I’ll make sure the three statuses work exactly as requested, including when notes are edited or deleted. I can also add a simple Rules tab so you can change keywords or add new statuses later without having to rewrite the logic. I’ll deliver the working Google Sheets template, clearly documented formulas or script, and a short setup guide. I’ll also test the routing with sample records before handing it over. I’m available to start right away and can keep the solution straightforward without unnecessary complexity. Would you like me to build a small working sample first so you can see how the routing will work? Best, Gonesh
£95 GBP in 1 day
6.2
6.2

Hello, GOOGLE SHEETS CALL ROUTING AUTOMATION DEVELOPER I HAVE CREATED SIMILAR AUTOMATION BEFORE AND CAN SHOW YOU. I have carefully reviewed your requirements and understand the need for a dynamic Google Sheets workflow that automatically routes call records based on the text entered in the Call Notes column. I have 11+ years of experience in software and automation development and can implement this using optimized Google Sheets formulas or a lightweight Apps Script, keeping the 10,000+ rows fast and easy for your team to maintain. I will set up the Master, Reattempt, Alternate Method, and Follow-Up tabs with automatic routing, while keeping the complete record safely stored in Master. Editing or deleting a note will automatically update the corresponding tab without manual refresh. I will also provide clearly commented logic, an easy setup/use guide, and instructions for adding new statuses or keywords later. I will follow an Agile approach, provide the complete source/script, and offer 2 years of free ongoing support after completion. I eagerly await your positive response. Thanks, Christina
£200 GBP in 12 days
6.7
6.7

Hello, I am an experienced Google Sheets and Apps Script specialist who can build a fast, fully dynamic routing system for your 10,000+ phone-number Master tab. I’ll set up the three child tabs to automatically display rows based on the exact Call Notes text, while keeping all records safely stored in Master and ensuring edits or deletions update instantly. I’ll use clean, maintainable formulas or lightweight Apps Script with clear comments so you can easily add or modify statuses later, and I’ll provide a simple setup/use guide explaining the system. I’m detail-oriented, focused on performance, and ready to deliver a reliable solution that requires zero manual filtering or copy-pasting. Regards, Zafar
£100 GBP in 1 day
6.3
6.3

Hi, I am a Google Sheets automation developer with 8 years of rich experience in software development, with a strong background in spreadsheet automation, data routing, and maintainable workflow logic. I am familiar with Google Sheets, Apps Script, FILTER, QUERY, REGEX, array formulas, Excel, VBA, data processing, data management, automation, and spreadsheet performance optimization. For your call-routing sheet, I can build a Master tab with dynamic child tabs that instantly route records based on the Call Notes text, update automatically when notes change, and keep the logic simple enough for you to add new statuses later. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Thanks. Emile.
£250 GBP in 7 days
5.9
5.9

Hi there, I went through your project description and understand you need a dynamic Google Sheets system that will keep all 10,000 phone records in a Master tab while automatically routing rows into Reattempt, Alternate Method, or Follow-Up based on manually entered Call Notes. I will build the solution using efficient ARRAYFORMULA, FILTER, QUERY, or REGEX logic, selecting the approach that keeps the workbook fast and easy to maintain. Each child tab will update automatically whenever notes are added, edited, or deleted, while the complete record will always remain preserved in Master. I will structure the formulas or lightweight Apps Script with clear comments so your team can easily change keywords or add future statuses without rebuilding the system. I will also preload the 10,000 records, test all routing conditions and edge cases, and provide a concise setup guide or walkthrough. Could you confirm whether the child tabs should display the entire Master row or only selected fields such as phone number and Call Notes? I will share a project blueprint within 24–48 hours of award and begin with the Master-to-status architecture. Kind Regards, Imran Ali
£100 GBP in 1 day
6.0
6.0

I got you! I can build your Google Sheets Master tab with 10,000 phone numbers and dynamic child tabs that instantly route rows based on Call Notes, without manual filtering or copy-pasting. I’m ready to handle the exact routing logic, keep it clean for non-technical users, and document everything clearly. I’m young, a fast learner, available 24/7, and I’ll make sure the solution stays simple to edit later. Get the demo first before you pay. A couple of quick questions: should matching be case-insensitive, e.g., “Interested” and “interested” both route to Follow-Up? Also, if one note contains multiple trigger phrases, which tab should take priority? Let’s chat and discuss these answers so I can set up the cleanest version for you. Kind regards, Haroon Z
£250 GBP in 1 day
5.8
5.8

Greetings, I see that you need a Google Sheets setup that can automatically organize your 10,000 phone numbers based on notes entered by your calling team. The goal is to have a “Master” tab where all data lives, and three additional tabs that dynamically update based on specific keywords in the Call Notes column. To tackle this, I would create a solution using a mix of formulas and possibly a light Apps Script to ensure it runs smoothly without needing manual intervention. I’ll make sure the setup is easy to maintain, so your team can add or modify note keywords as needed without hassle. You’ll receive a fully functional Google Sheets file with everything wired up, well-documented formulas, and a simple guide to help your colleagues get started. Best regards, Saba Ehsan
£200 GBP in 3 days
5.5
5.5

Hi There! We can turn your 10,000-number Google Sheet into a fast, fully dynamic call-routing system, backed by a team of 62 professionals with over 9 years of experience. We’ll keep every record in Master while automatically routing notes to Reattempt, Alternate Method or Follow-Up using maintainable formulas or Apps Script. Editing or deleting a note will update routing instantly without manual refresh. Would you prefer formulas for simpler maintenance, or a lightweight Apps Script for easier future status expansion?
£135 GBP in 7 days
5.4
5.4

Hi, I'm Denis, a full-stack developer specializing in Google Sheets automation systems. I've built several live routing solutions involving dynamic data filtering for teams managing large datasets. What you're describing is a call routing system where notes automatically populate the right working tab based on keyword matching. The key challenge is keeping 10,000 records performant while maintaining instant visibility. I'd recommend combining FILTER formulas with SEARCH or REGEX functions on your working tabs, paired with lightweight Apps Script for keyword matching. This keeps the file fast, avoids helper columns, and maintains full records in Master without duplication. Here's my approach: Set up the Master tab with your 10k records, then use FILTER formulas on each working tab—Reattempt, Alternate Method, Follow-Up—to dynamically pull rows based on Call Notes. The formulas will be simple enough for you to add new keywords yourself. If needed, a small Apps Script can handle more complex matching and give you flexibility to scale. Performance is key with 10k rows. The FILTER approach is efficient, but I'll monitor responsiveness and adjust if needed. I'll deliver a pre-configured sheet ready to use, with clearly commented formulas and a setup guide explaining how the routing works and where to make changes. I can start right away. Let's discuss the details. Thanks, Denis.
£66 GBP in 3 days
5.4
5.4

Leeds, United Kingdom
Member since May 17, 2026
£250-750 GBP
£1500-3000 GBP
£2-5 GBP / hour
£250-750 GBP
£250-750 GBP
₹12500-37500 INR
₹12500-37500 INR
₹12500-37500 INR
₹600-1500 INR
₹750-1250 INR / hour
₹1500-12500 INR
₹1250-2500 INR / hour
$10-30 USD
₹400-750 INR / hour
₹750-1250 INR / hour
£20-250 GBP
₹750-1250 INR / hour
₹600-1500 INR
$250-750 USD
₹750-1250 INR / hour
$1500-3000 USD
$15-25 USD / hour
₹12500-37500 INR
$30-250 USD
₹100-400 INR / hour