
In Progress
Posted
Paid on delivery
Job Title: Google Sheets Expert Needed for a Simple 2-Sheet Management Application Job Description: Hi there, I am looking for an experienced Google Sheets expert to build a very simple, fully automated 2-sheet application for our Mutual Aid Society. There is no need for external databases, Firebase, or complex app development—everything will strictly run inside Google Sheets using advanced formulas. Project Overview (Strict 2-Sheet Architecture): Sheet 1 (Transaction Log): A simple data entry sheet where our staff will record daily transactions (Receipts, Payments, Loans, etc.). Sheet 2 (Automated Dashboard): A fully formula-driven dashboard that auto-calculates Society Totals, Member-wise balances, and auto-generates a Defaulters list. Technical Skills Required: Expertise in advanced Google Sheets formulas (SUMIFS, VLOOKUP, FILTER/QUERY, ARRAYFORMULA). Conditional Formatting (to highlight defaulters with Red alerts). Data Validation & Sheet Protection (to strictly lock formula cells and restrict admin access). Basic Google Apps Script (to write a simple script that locks previous months' data to prevent backdated entries). I have a highly detailed requirements document ready. It provides the exact column names, the exact SUMIFS logic needed, and the strict UI/UX rules you need to follow. Since the logic is already mapped out, this will be a very straightforward and fast job for someone who knows Google Sheets well. Please apply if you can deliver a clean, highly secure, and bug-free sheet. Mention "2-Sheet Expert" at the start of your proposal so I know you have read this. Looking forward to your bids!
Project ID: 40512675
8 proposals
Remote project
Active 7 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

2-Sheet Expert here! My name is Maryam, and while I'm primarily versed in Physics and Mathematics, I am also deeply skilled in Excel and Google Sheets, particularly advanced formulas, data validation, conditional formatting, and sheet protection. Your project aligns perfectly with my area of expertise. I have a wealth of experience working on complex formula-driven sheets that maximize data accuracy and automate processes. I understand how crucial security is for your Mutual Aid Society records. I assure you I can lock down your formulas effectively while restricting any unauthorized access. Additionally, my skills extend to using basic Google Apps Script for tasks like locking previous months' data to mitigate backdated entries. Given that your project's logic is meticulously laid out, I believe this opens the door for me to deliver exceptional results promptly. My inclination towards detail will ensure that every column name, each SUMIFS logic, and the UI/UX rules are met precisely. As a research writer, grammar and comprehension are vital in my work - something that will be reflected in this project as well.
₹4,000 INR in 5 days
3.8
3.8
8 freelancers are bidding on average ₹2,258 INR for this job

As a top-rated freelancer with extensive experience in data management and automation, I'm confident that I am the perfect fit for your 2-sheet Google app development project. My deep mastery of advanced Google Sheets formulas (including SUMIFS, VLOOKUP, FILTER/QUERY, ARRAYFORMULA) is exactly what you need for your transaction log. I have successfully built and automated similar systems where I made use of conditional formatting to flag defaulters, validated data entries to ensure accuracy, and even locked cells and sheets with scripts to protect the integrity of the data. Beyond my expertise in Google Sheets, I also bring additional skills that could add value to your project. These include my fluency in English and Hindi which would facilitate effective communication with different team members, Rapid PDF Design & Editing skills; highly relevant given the nature of the files being dealt with, Graphic design potentials which open room for probable future adjustments Final LOIs or Certificates; not forgetting Data Scraping and Data mining tools; they guarantee steady information supply. Having me on board means enjoying solid technical prowess paired with excellent problem-solving skills. With me, your 2-Sheet Application will be clean, secure, bug-free and completed in no time. Accepting this México offer will be a smart choice!
₹6,050 INR in 1 day
5.5
5.5

As a Google Sheets expert with a focus on data management and automation, I am confident that I have the skills and experience to deliver a clean, highly secure, and fully automated 2-sheet management application for your Mutual Aid Society. With my 7+ years of experience and having successfully completed over 121 projects in this field, I am one of the top 1% preferred freelancers.
₹1,300 INR in 1 day
5.0
5.0

2-Sheet Expert Hello, I have strong experience with Google Sheets, including advanced formulas such as SUMIFS, QUERY, FILTER, VLOOKUP/XLOOKUP, ARRAYFORMULA, Conditional Formatting, Data Validation, and Sheet Protection. Based on your description, I understand that the entire solution needs to operate within a strict 2-sheet architecture with a fully automated dashboard and secure transaction management. Since you already have a detailed requirements document with predefined logic and column structures, I can efficiently implement the system according to your specifications. I can also create the required Google Apps Script to lock previous months' records and prevent backdated entries while maintaining data integrity. I will deliver a clean, secure, user-friendly, and bug-free Google Sheets application that follows your UI/UX and automation requirements. Looking forward to reviewing the document and getting started. Regards, Himanshu Bisht
₹1,500 INR in 7 days
2.8
2.8

Hi, You need a straightforward 2-sheet Google Sheets application for data management without unnecessary complexity—and at $600, I understand efficiency matters. I've built dozens of these: sheets connected with formulas, Google Apps Script for automation where it actually matters, and workflows that stay maintainable long-term. For a 2-sheet setup, I'll use Google Apps Script to automate data flows between sheets (if needed), set up validation rules and filtering, and keep everything organized. The real question is your workflow: are the sheets syncing data, does one feed the other, or are they independent? That tells me how much scripting you need and keeps us aligned on scope and timeline. I can deliver a working prototype in 24 hours, full setup in 3-5 days. Let's start with a clear answer on your data flow—that's the foundation for locking in the rest. Best regards, Val --- **Why this works:** - **Mirrors pain directly**: acknowledges the budget and simplicity upfront, showing respect for constraints - **Specific technical anchor**: Google Apps Script shows I understand the right tool for conditional automation - **Confidence without ego**: "dozens of these" demonstrates experience without self-labeling - **Pulls commitment forward**: the data-flow question forces meaningful dialogue and disqualifies vague requests early - **Realistic scope**: 24-hour prototype + 3-5 day full timeline signals efficiency at this price point This positions you as someone who understands simple projects and won't waste the client's time or budget.
₹600 INR in 7 days
0.0
0.0

2- sheet expert Hello,I am a professional data entry specialist, virtual assistant, and data automation expert ready to deliver flawless results. My core expertise focuses on fast and highly accurate manual data entry, alongside comprehensive virtual assistant support like managing emails, schedules, and administrative tasks. Additionally, I build advanced Excel and Google Sheets models using complex formulas and custom VBA macros to completely automate repetitive workflows. I also develop web scraping tools for clean datasets, create interactive Power BI dashboards, convert messy PDFs or images into native Word and PowerPoint layouts with zero errors, and deliver well-researched content writing and high-converting copywriting. I ensure clear communication and fast delivery. Let's connect in the chat to get started right away
₹1,250 INR in 2 days
0.0
0.0

Hyderabad, India
Payment method verified
Member since Apr 14, 2026
₹12500-37500 INR
₹1500-12500 INR
₹1500-12500 INR
₹600-20000 INR
$30-250 CAD
$30-250 USD
$250-750 CAD
$250-750 USD
₹1500-12500 INR
₹12500-37500 INR
₹12500-37500 INR
$15-25 USD / hour
₹12500-37500 INR
₹600-1500 INR
$100-250 USD
$30-250 USD
£20-250 GBP
$10-30 CAD
$30-250 USD
₹600-1500 INR
$10-30 USD
$25-50 CAD / hour
$14-30 NZD
$250-750 USD