
Closed
Posted
Paid on delivery
Google Sheets and Apps Script System Setup We are looking for an experienced Google Apps Script freelancer to install, configure and activate an existing production KPI and label-request system for our business. The system has already been created. It includes: An Excel workbook designed for Google Sheets Google Apps Script automation A Google Form builder A manager approval webpage A production dashboard Setup instructions This is primarily a setup, configuration, testing and handover job—not a complete system build. What we will provide The complete system package Product names and categories Product sizes, such as 300ML, 1KG and 10KG Product costs Staff names Staff hourly wages Manager names and email addresses Access to the Google account that will own the system Required setup work Import the supplied workbook into Google Sheets. Set the spreadsheet time zone to Australia/Sydney. Enter our product information using: Category Size Product Cost Active Enter staff names, hourly wages and active status. Enter the approved manager names: Ethan Murray Harman Verma Add the manager email address used for notifications. Install the supplied [login to view URL] file in Google Apps Script. Install the supplied [login to view URL] file. Run the supplied setupSystem function. Authorise the required Google permissions. Create and configure the Google Form. Confirm the Form displays products according to their selected category. Install and verify the submission and spreadsheet triggers. Deploy the manager approval page as a Google Apps Script web app. Configure appropriate access permissions. Confirm the manager dropdown displays Ethan Murray and Harman Verma. Add links or desktop shortcuts on our production computer for: Staff label-request Form Manager approval page Production Sheet and dashboard Test the entire workflow from beginning to end. Remove the demonstration data after testing. Provide a short handover explaining how to add products, change costs, update staff wages and redeploy the system. Required testing The freelancer must demonstrate that: Staff can submit a label request. Categories display the correct products and sizes. New requests appear as Pending. Managers receive the notification. Managers can approve or reject requests. The correct manager name is recorded. Approved requests receive a unique batch number. Approved requests appear in the Production Log. Production staff can enter actual quantity, completion details and labour hours. Product cost is calculated correctly. Wage cost is calculated from labour hours and hourly wage. Total direct production cost is calculated correctly. Staff statistics update for the current and previous week, month and year. The dashboard updates correctly. The system works from our production computer. Ownership and security requirements All Google Sheets, Forms, scripts, triggers and web-app deployments must be owned by our Google account. The freelancer must not host any part of the system permanently in their own account. Access must be limited to the people who need it. The freelancer must not retain access after the project is completed. Any temporary passwords or access permissions must be removed or changed at handover. The supplied system should not be rebuilt or materially changed without approval. Experience required Please apply only if you have experience with: Google Sheets Google Forms Google Apps Script Apps Script triggers Apps Script web-app deployment Email notifications Google account permissions Testing and documenting business workflows When applying, please provide: Examples of similar Google Apps Script systems you have configured Your fixed-price quote Estimated completion time Confirmation that you can complete the setup remotely Confirmation that the finished system will remain entirely owned by our Google account Any ongoing support options you offer Expected deliverables Fully operational production label-request system Configured product, staff and manager lists Working Google Form Working manager approval page Working email notifications and triggers Working batch-number automation Working Production Log and cost calculations Working KPI dashboard Production-computer shortcuts Completed end-to-end testing Short written or recorded handover
Project ID: 40631992
77 proposals
Remote project
Active 4 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
77 freelancers are bidding on average $151 AUD for this job

Hi There, I have strong experience with Google Sheets, Google Forms, Apps Script, triggers, web-app deployment, email notifications, dashboards, and workflow testing. I can install and configure your existing system without unnecessary rebuilding, enter the supplied product/staff/manager data, deploy the approval page, configure triggers and permissions, test the complete label-request workflow, remove demo data, and provide a clear handover. I can complete the setup remotely, and all Sheets, Forms, scripts, triggers, and web-app deployments will remain fully owned by your Google account. I’m ready to start immediately.
$50 AUD in 1 day
8.7
8.7

I'd love to work on your project. I can deliver a clean, high-quality solution with fast communication and on-time delivery. Let's discuss the details!
$220 AUD in 4 days
8.6
8.6

AVAILABLE TO START IMMEDIATELY..,,. I will expertly set up, configure, and test your existing Google Sheets, Apps Script, Google Form, and web app system for seamless operation. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$51 AUD in 1 day
6.6
6.6

I understand you're seeking an expert to set up and configure your existing Google Sheets KPI system, ensuring that it functions smoothly and meets your business needs. I can effectively import your Excel workbook into Google Sheets, configure the necessary Google Apps Script components, and thoroughly test the workflow to confirm that all elements operate as intended. With my proficiency in Google Sheets, Apps Script, and workflow automation, I can ensure seamless integration and functionality throughout the system. I have a 4.9-star rating across 200 client reviews and have completed 220 projects, demonstrating my reliability and commitment to quality outcomes. What specific challenges do you foresee in the testing phase of the workflow?
$200 AUD in 5 days
5.9
5.9

⭐⭐⭐⭐⭐ Set Up Your Google Sheets and Apps Script System Efficiently ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project requirements and see you're looking for an experienced Google Apps Script freelancer to configure your existing KPI and label-request system. Look no further; Zohaib is here to help you! My team has successfully completed over 50 similar projects for Google Apps Script setups. I will ensure a smooth setup, testing, and handover process, all within your budget. ➡️ Why Me? I can easily handle your Google Sheets and Apps Script system setup as I have 5 years of experience in Google Sheets, Apps Script automation, and workflow testing. My expertise includes data entry, Google Forms, and permission configurations. Additionally, I have a strong grip on web app deployment and email notifications, ensuring a complete solution for your project. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. I'm looking forward to discussing this with you! ➡️ Skills & Experience: ✅ Google Sheets ✅ Google Forms ✅ Google Apps Script ✅ Apps Script Triggers ✅ Web App Deployment ✅ Email Notifications ✅ Workflow Testing ✅ Data Management ✅ Permission Settings ✅ Dashboard Creation ✅ System Configuration ✅ User Support Waiting for your response! Best Regards, Zohaib
$150 AUD in 2 days
6.1
6.1

With over 8 years of experience and having completed 900+ data management projects, I am unequivocally qualified to assemble and configure the pre-existing KPI system using Google Apps Script. My comprehensive skill-set, honed from working on numerous similar Google Sheet projects, namely data importation, managing access levels with Google Permissions, and form customization, perfectly aligns with your requirements. Not only will I effectively incorporate your product information and staff details into the system, set up notifcation emails for managers, ensue corresponding dropdown accessibilities stay up-to-date, but my extensive experience with automated Excel or Python solutions will further ensure the correct calculation of product cost, wages cost and total production cost—making your entire workflow efficient and unambiguous. My dedication to thoroughness and keen eye for detail will also ensure that the dashboard accurately displays staff statistics for the current and previous week, month, and year. Perhaps my most valuable attribute is my understanding of the sensitivity of data security. I recognize that ownership and security is a major concern for you since the system will ultimately belong solely to your account. You can rest assured that I will neither take any part of this project permanenty nor retain access to the system after completion. My commitment to maintaining complete confidentiality is iron clad
$50 AUD in 1 day
5.6
5.6

Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data GOOGLE SHEET Development. I can write clean Google Sheet,Google Excel Sheet, Power BI, Outlook and Google VBA macros. Google sheet: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Let's discuss this further via chat, and I'll start your project right now. Thanks Gdev
$100 AUD in 2 days
5.0
5.0

Hi, I'm an experienced Google Apps Script developer having experience in providing workflow automation solutions for Google Workspace apps, including Google Sheets. Let me install, set up, and activate your current label-request and production KPI system. I'll review the Apps Script logic and how it applies to the data in the Google Sheets tabs to ensure all the tasks you've mentioned work according to your requirements. I'll make any modifications to the Apps Script logic if it becomes necessary. Furthermore, I have delivered several successful Google Apps Script projects here on Freelancer, from simple API integrations to complex projects where Apps Script is being used as a web app. Check the screenshots in my portfolio on my profile page of a web app form I created using Apps Script. I can show you some of my work if you want to ensure that I can do this project. I'm looking forward to working on this project. Let's discuss your project with me.
$150 AUD in 3 days
4.9
4.9

Hello, I got that you are looking for an experienced Google Apps Script specialist to configure your existing KPI and label-request system, deploy it entirely under your Google account, and complete end-to-end testing without rebuilding the solution. This is what I can help you with, let's chat. My approach is to configure the supplied Google Sheets, Apps Script, Google Form, approval web app, triggers, and email notifications exactly as documented. The most critical part is ensuring every workflow functions correctly under your ownership, so I will install the provided scripts, configure Australia/Sydney settings, deploy the web app, verify approvals, batch numbering, cost calculations, KPI updates, and thoroughly test the complete process before removing all demo data. Everything will remain hosted and owned within your Google account. As final deliverables you will receive a fully configured production system, working Google Form, approval page, email notifications, triggers, Production Log, KPI dashboard, desktop shortcuts, complete testing, and a concise handover guide explaining maintenance and future updates. One thing I'd like to confirm before we start: will I have administrator access to your Google Workspace account during the setup and testing phase? Let's discuss your timeline and get your system operational. Best Regards, Imran
$90 AUD in 1 day
4.4
4.4

As an experienced developer with a comprehensive knowledge of Google Apps Scripts, I can bring your KPI system to life swiftly and effectively. I'm well-versed in working with Google Sheets, Google Forms, Apps Script automation, and navigating through complex workflows. My familiarity with apps script triggers and web-app deployment will ensure that everything runs smoothly while my experience in testing and documenting business workflows guarantees that I can tick all the required boxes during the testing phase. In terms of ownership and security requirements, you can count on me to create an environment where your data's security is paramount. As a professional who respects client confidentiality and privacy rights, I won't host any part of your system permanently. In addition, my project will consist of delivering a fully operational production label-request system that is entirely owned by your Google account. Post-handover, I will promptly remove or change all temporary passwords and access permissions to ensure complete control for you.
$140 AUD in 3 days
4.0
4.0

Hi there, I am A.R.M. MASUD with a strong background in data science. As a Google Sheets Specialist with proven expertise in data organization, automation, and advanced formula creation, I offer efficient, customized spreadsheet solutions tailored to your project needs. Whether it's streamlining workflows using Google Apps Script, building dynamic dashboards, or creating error-proof data validation systems, I ensure accuracy, clarity, and functionality. My experience spans budgeting tools, CRM trackers, inventory systems, and analytical reports, all optimized for collaboration and performance. I’m committed to delivering user-friendly, scalable Google Sheets tools that save time and enhance decision-making. https://www.freelancer.com.bd/projects/google-sheets/create-google-sheet-google-studio https://www.freelancer.com.bd/projects/data-entry/Dynamic-Google-Sheets-COGS-Calculator/reviews Thank you for considering your Google Sheets development project. I am confident that my expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M MASUD
$50 AUD in 7 days
4.3
4.3

Hello I understand you need to automate your Google Sheets workflows to stop manual data entry from bottlenecking your operations. I specialize in building custom Apps Script solutions that turn static spreadsheets into functional, automated systems. I have recently deployed similar triggers and custom functions for clients to streamline their reporting and save hours of weekly labor. Are you free for a brief chat to discuss the specific manual processes you want to automate today? Giáp Văn Hưng
$118 AUD in 7 days
3.8
3.8

Hi, I can help transfer and structure the CSV data into your spreadsheet exactly in the format you need. I’ve reviewed the supplied CSV and can see it contains mixed player data such as division, position, age, minutes, wage, rating, performance metrics, and transfer value, so I can map these fields cleanly into the Excel template. I can do this manually or build a small Python/Excel automation if you want the process to be reusable for future CSV exports. I’ll also clean formatting issues, preserve special characters in player names, and verify the final rows before delivery. I can follow the layout shown in your reference video once we begin and make sure the finished spreadsheet matches that structure. Let’s connect over the chat so that I can show you my previous work.
$140 AUD in 1 day
3.4
3.4

Hi, I have reviewed your project details for configuring and activating your production KPI and label-request system within Google Sheets and Apps Script. Managing a pre-existing infrastructure package requires a highly methodical configuration pass—specifically aligning Google Form data arrays, linking the manager approval interfaces, and hardcoding strict time-zone parameters synchronized directly to Australia/Sydney to prevent system tracking anomalies. I am fully prepared to import your sheets, configure your product metadata dimensions, and run comprehensive operational tests to ensure a seamless system handover. Let's connect in the chat for further process.
$115 AUD in 4 days
2.9
2.9

Hi, I read your project carefully and I can deliver exactly what you need. I can start immediately and show you the first preview in a few hours. Let’s discuss the details.
$68 AUD in 4 days
2.4
2.4

As a seasoned full-stack developer with a strong affinity for bringing structured order to businesses' data solutions, I am confident that my skills align seamlessly with your project's needs. While my expertise may not be explicitly Google-oriented, my vast experience in working across multiple database platforms and proficiency in data management will make me more than capable to execute your project. Having held significant responsibilities in developing mobile app systems with backend services and databases over the last 8+ years, I understand the dynamics of managing, optimizing, and securing sensitive information—attributes that could be invaluable in complying with your ownership and security requirements. My conversion of clients' ideas into reliable and scalable applications also speaks to my adaptability when it comes to taking charge of existing systems like yours and enhancing them to meet specific demands seamlessly. Additionally, I am well-versed with the incorporation and configuration of diverse tools, including but not limited to Figma, React, Node.js, Flutter amongst others which demonstrate my determination and adaptability. Let's kick-start this partnership as soon as possible to ensure that you have a fully operational production label-request system configured efficiently before any deliveries are due. Get in touch with me now so we can brainstorm on how best I can fulfill your project requirements.
$250 AUD in 7 days
2.5
2.5

Understanding the need for a smoothly functioning KPI system, our team is prepared to efficiently set up and configure the existing Google Sheets and Apps Script setup. Our goal is to ensure seamless operation that aligns with your business requirements. We will import the provided Excel workbook into Google Sheets, set the correct time zone, and accurately input all product and staff information. Our approach ensures that the manager approval page and Google Form are fully operational, confirming that submissions are processed correctly. With extensive experience in Google Sheets, Google Forms, and Apps Script, we prioritize communication, quality, and on-time delivery. If you'd like, I can also share similar work we've completed and discuss the best approach for your project. Regards, JP
$150 AUD in 7 days
1.2
1.2

As a Certified Google Apps Script Developer, I bring the right blend of technical expertise and precision to transform your existing KPI system into a seamlessly functioning Google Sheets solution. My comprehensive understanding of Google Sheets, Google Forms, and Google Apps Script makes me well-poised to successfully import your existing workbook to Google Sheets while ensuring the integrity and smooth operation of your KPI system.
$140 AUD in 7 days
0.8
0.8

Hello, I’ll set up your Google Sheets KPI system in the Australia/Sydney time zone, import your product and staff data, deploy the approval page, and fully test the workflow from label requests to cost calculations and manager notifications. I built a similar production tracking system last year for a Sydney manufacturing client, which handled 200+ weekly requests with zero downtime after initial setup. I’ll use the provided Google Apps Script files, configure triggers correctly, and lock permissions to your account only. The dashboard will update KPIs in real time and managers will receive approvals instantly. All links and shortcuts will be added to your production computer. The system will stay entirely owned by your Google account, with no external hosting or retained access. A clear handover document will explain future updates. Let me know if you’re ready to proceed. Thanks, Lazar.
$30 AUD in 1 day
0.7
0.7

Hello, ✔️ Setting up a comprehensive Google Sheets KPI system can be a complex task, especially with the need for seamless automation and accurate data flow. My approach focuses on meticulous configuration and thorough testing to ensure every component—from Google Forms to email notifications—works flawlessly. I emphasize clarity in the handover process, equipping your team with the knowledge to maintain and update the system independently. Having successfully set up similar Google Apps Script systems, I pride myself on strong communication and fast response times, ensuring a smooth collaboration. Are you open to discussing any specific challenges you foresee with the setup? Best, Kurt
$100 AUD in 7 days
0.0
0.0

Sydney, Australia
Payment method verified
Member since Aug 29, 2012
$2-150 USD / hour
$2-8 AUD / hour
$2-8 AUD / hour
$30-250 AUD
$2-15 AUD / hour
$1500-3000 USD
$15-25 USD / hour
$30-250 USD
$18.5 USD / hour
₹12500-37500 INR
₹1500-12500 INR
₹12500-37500 INR
$2-8 AUD / hour
₹12500-37500 INR
$250-750 USD
₹3000-6000 INR
$250-750 USD
₹12500-37500 INR
₹37500-75000 INR
₹600-1500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
$250-750 USD
₹12500-37500 INR
₹12500-37500 INR