
Closed
Posted
Paid on delivery
I need a single web-based dashboard, linked to our Google Drive, that lets every employee open the right Google Sheets without ever seeing data they are not cleared for. Directors must keep full spreadsheet access, but managers and staff should only view or edit the fields I authorise. Core workflow • Each morning I will upload or update multiple Google Sheets. From the dashboard, tasks are automatically assigned to the relevant employee. • Staff mark items done directly in the interface; if a due date slips, the system pings both the assignee and their manager. • I can change columns, field names or validation rules at any time and have those changes cascade to every connected sheet without manual relinking. Security and compliance • Role-based access control decides who can read, write or approve each sheet or field. • Sensitive columns (salary, cost prices, etc.) remain encrypted when stored and decrypted only for directors. • Every view, edit or export action is logged so I can audit what happened, when and by whom. Management insight A built-in MIS view should roll up individual task statistics into team and company performance charts so I can spot delays or bottlenecks at a glance. Key deliverables – Responsive dashboard UI connected to Google Sheets & Drive API – Admin panel to create roles, map fields, and edit validation rules – Automated email / in-app notifications for task completion or delay – Encryption layer plus immutable audit trail – Deployment guide and brief hand-over session so my team can extend the tool later If you have solid experience with Apps Script, Google API, or a preferred web stack that plays well with G-Suite, let’s discuss the quickest path to a secure, flexible launch.
Project ID: 40392156
24 proposals
Remote project
Active 6 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
24 freelancers are bidding on average ₹8,748 INR for this job

As an experienced Full Stack Developer with over a decade of successful projects under my belt, I'm confident in my ability to deliver your complex Custom Web Dashboard for Google Sheets Management accurately and on time. With a solid understanding of using both Apps Script and the Google API, I assure you that I can create a bespoke, secure dashboard, tailored only for those with correct access rights. My skills do not stop here; keeping in mind sensitive employee data like salary and cost prices, I'll implement an encryption layer that will ensure this remains confidential unless accessed by directors. Furthermore, an immutable audit trail will help you keep track of who accesses what information and when. Needless to say, your management insight requirement will be met analysis tools such as roll-up-task stats into team and company performance charts integrated therein. Partner with me because at Prajapati Technologies we deliver scalable and secure solutions ensuring long-term support long after the initial delivery date.
₹9,999 INR in 7 days
6.4
6.4

With a broad range of skills as a Front-End Designer, WordPress specialist, and experienced Full-stack Web Developer, I believe I'm the perfect fit for your custom web dashboard project. My expertise includes API integration, which aligns perfectly with your need for Google Sheets & Drive API connectivity. Having proficiently managed WordPress from design to deployment, I am comfortable with the Google Apps Script environment and would expertly develop the responsive dashboard and admin panel you require. Lastly, my solutions are known for scalability and optimize performance. Building an efficient, highly-automated system that can easily adapt to your changing needs and assignments is a natural talent that I bring to this project. Plus, in line with my commitment to your long-term success, I'll provide a detailed deployment guide empowering your team to extend the tool's functionality later. Let's make efficiency and security the hallmark of your spreadsheet management process!
₹7,000 INR in 7 days
6.3
6.3

With over a decade of experience in web development and API integration, I am confident that I can deliver the precise solution you need for your Google Sheets management. At Google and Apple, I acquired a robust understanding of Apps Script and Google API, skills that are essential for your project's successful completion. Additionally, my proficiency in HTML, JavaScript, and PHP makes me well-prepared to deliver your ideal dashboard underlined by a "preferred web stack that plays well with G-Suite." Moreover, I not only prioritize the technical aspects of your project but also understand its broader impact on your business. My client-centered approach ensures that we identify pain points, define clear deliverables and outcomes, and establish efficient timelines to tackle scope creep, revisions and delays effectively. Ultimately, what sets me apart is my ability to deliver measurable results while assuring reliable communication and fast prototypes. Let's transform your vision into a secure dashboard solution that streamlines task assignments, role-based access control, provides deep insights with an MIS view, all while keeping data secure. Together we will develop exactly what you need on-time and headache-free.
₹7,000 INR in 7 days
5.7
5.7

Hi, I can start right away. ⟡I can build a secure web dashboard connected to Google Drive and Google Sheets that gives you full control over employee access and task tracking. I understand your main pain is data security and visibility each user should only see what they are allowed to, without manual sheet sharing or risk of leaks.⟡ ***********What I will deliver:- *********** ⟡• Role-based dashboard (Director, Manager, Staff) • Controlled access to sheets, rows, and fields • Task assignment with daily updates and status tracking • Auto alerts for delays or missed deadlines • Audit logs for every action (view, edit, export) • MIS dashboard for performance and productivity insights ⟡ Let’s connect and plan the system properly. Thankyou, Gurpinder Singh Kahlon
₹8,000 INR in 5 days
5.1
5.1

With over a decade of experience in creating robust, user-friendly web solutions and APIs, my team at Dlite Info Tech is perfectly positioned to deliver your custom web dashboard. I have extensive familiarity with Google's APIs such as Drive and Sheets, and my expertise with Apps Script ensures that I'm intimately familiar with the tools you need. Our proficiency extends to both front-end and back-end development, using stacks such as PHP, Laravel, CodeIgniter, React.js, Vue.js – all of which are easily compatible with G-Suite. Additionally, my fluency in HTML, JavaScript & API Integration paired with our emphasis on building intuitive user interfaces will help create a seamlessly integrated dashboard for you. I understand the importance of a clean and friendly interface that assists even the most non-technical users in managing tasks efficiently – thus we will ensure your employees only see what they're authorized to see. With a hand-over session at the end, I'll make sure your team has full control to extend the tool beautifully into the future. Let's get this transformative project started!
₹7,000 INR in 7 days
4.6
4.6

The quick win here is letting Google's own OAuth and Drive permissions handle access. Users sign in with their company Google account, and the dashboard surfaces exactly the sheets they already have access to in Drive - no separate permission system to configure or keep in sync as the team changes. For the build: a lightweight Node backend with the Sheets and Drive API, Google OAuth where each user's own credentials drive the API calls (not a service account), a card grid grouped by department or folder, search across sheet names and sharing metadata, inline preview, and an open-in-Sheets button. Admins get a pin-to-top feature for frequently used sheets. M1: OAuth + Drive API integration, INR 2625, 4d. M2: Sheet card grid + search, INR 2625, 4d. M3: Department grouping, preview, admin pin, INR 2750, 3d. M4: Final polish + deployment, INR 2500, 3d. One question before I start: are your employees on a shared Google Workspace domain, or a mix of personal Gmail accounts? That affects how the OAuth app gets configured.
₹10,500 INR in 14 days
4.3
4.3

Hello, I’ve gone through your project details carefully, and I must say it sounds really interesting. I’d love to bring my experience to make it a success. With over 10 years of hands-on experience in web, mobile, and software development, I’ve had the privilege of working with clients from around the world — delivering 1000+ successful projects so far. My team and I are comfortable working with technologies like MEAN, MERN, Flutter, React Native, PHP, Laravel, Python, WordPress, Shopify, AI, Blockchain, CRM, CMS, and more. What truly drives me is solving complex challenges and transforming ideas into reliable, user-friendly products. I always aim for clear communication, transparency, and results that make clients feel confident they chose the right partner. You can review my portfolio here: https://www.freelancer.in/u/NareshJoshiTech I’d really appreciate the chance to discuss your project in detail and explore how we can create something great together. Looking forward to hearing from you. Warm regards, Naresh Joshi
₹9,000 INR in 7 days
3.0
3.0

Hi! This project is well within my expertise. I'll approach 'Custom Web Dashboard for Google Sheets Management' with a clear plan, deliver iteratively so you can provide feedback early, and ensure the result is exactly what you envisioned. My rate is competitive and I'm available to start today. Drop me a message!
₹2,700 INR in 7 days
2.5
2.5

As a long-time industry professional with a robust skill set, I am well equipped to address the complex challenges your project demands. With 5+ years of experience creating and deploying custom web and mobile applications, your unique need for a secure, flexible Google Sheets management solution naturally compels me. Having worked on similar projects using Google's powerful API and G-Suite environment, I have extensive experience in working with Apps Script, Google API, and relevant web stacks. This promises a streamlined development process tailored to your specific requirements. My approach as a freelancer extends beyond writing code; I aim to understand your business goals and ensure my final product aligns with them. Thus, partnering with me means receiving not just a web dashboard but also improved workflow efficiencies, enhanced security measures, data insights with analytics, and meticulous audits to trace information access and manipulation.
₹5,000 INR in 10 days
2.0
2.0

Subject: Secure Web Dashboard for Google Sheets & Role-Based Automation Hi there, I am the Founder of Ardax, specializing in 'Single-Button' Automation. I have 7+ years of experience building secure ERP/MIS layers over Google Sheets for large-scale operations (including projects like MP Markfed). My Solution for You: Granular Security: A custom web interface where staff sees only authorized fields. Sensitive data (salaries/costs) remains encrypted and accessible only to Directors. Dynamic Sync: Changes to columns or validation rules in the Admin Panel will automatically cascade across all sheets via Google Sheets API. Automated Workflow: Morning task assignments, real-time "Done" marking, and automated Email/Ping notifications for overdue items. Audit & Analytics: A built-in MIS view for performance charts and a 100% Immutable Audit Trail of every user action. I will deliver a responsive dashboard (Python/Django or PHP) with a complete deployment guide. I specialize in turning messy manual sheets into high-speed, secure business tools. Ready to start immediately and show you a demo of my architecture. Best regards, Amit Founder, ARDAX IT SOLUTION
₹7,500 INR in 10 days
2.2
2.2

Hi, a single dashboard to unify Sheet access beats scattered Drive folders and shared links—that's where most teams lose visibility, collaboration, and months of productivity. I'll build this with React on the frontend and Node.js on the backend, integrating Google Sheets API v4 and Google Drive API directly. For authentication, I'll implement OAuth 2.0 so users authenticate via their Google accounts without password management overhead. On the backend, I'll use Google Drive's change notification webhooks instead of polling—you get real-time Sheet updates without burning API quota, and the dashboard stays consistently in sync. The interface will support both viewing and inline editing of your Sheets. In the first 24 hours, I'll have OAuth login functional and at least one core Sheet rendering on the dashboard—so you can test the actual workflow immediately. Are you looking for row-level permissions (certain employees see specific Sheets), or is view-all access the starting point? Best regards, Val
₹6,000 INR in 7 days
0.4
0.4

Tāna, India
Member since Apr 23, 2026
£20-250 GBP
$2-8 USD / hour
$15-25 USD / hour
$8-15 USD / hour
$15-25 USD / hour
$250-750 USD
₹12500-37500 INR
$30-250 USD
£20-250 GBP
₹750-1250 INR / hour
$10-20 NZD / hour
$250-750 AUD
₹1500-12500 INR
₹1500-12500 INR
₹100-400 INR / hour
₹100-400 INR / hour
₹750-1250 INR / hour
$750-1500 USD
$250-750 USD
$20000-50000 USD