Find Jobs
Hire Freelancers

Create Google Script That Can Edit Protected Cells in Google Sheets

$10-30 USD

Completed
Posted over 6 years ago

$10-30 USD

Paid on delivery
I want to be able to create a google script that can edit protected cells in google sheets. The use case is that i want users to only be able to edit a spreadsheet through a google script and not mess with the actual spreadsheet. The problem is that the script runs through the permissions of the user. I therefore need to be able to create a script in some other way that would run as the owner of the spreadsheet. Many forums online talk about publishing a script though a webapp and then calling that web app. In addition others talked about using an API key or Oauth to do this. The final output of the project should be a google sheets document that has protected cells that then can be edited though a google script that is called on a button click. Its that simple and could take someone just a few minutes if they are familiar with this problem. I will then take the spreadsheet and adapt the methodology into my larger project.
Project ID: 14950301

About the project

9 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

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:
User Avatar
Hi there! You actually did a good research about that issue. The shortest and easiest road is a web app that act in your behalf. Relevant Skills and Experience Then we can control which action that users can take to edit protected ranges. We can also set up conditions or allowed results only. Proposed Milestones $55 USD - Complete the project
$55 USD in 1 day
5.0 (15 reviews)
4.3
4.3
9 freelancers are bidding on average $154 USD for this job
User Avatar
Hi, can help. Will develop that web app. You Will have web page where you define cell range, value and after click submit it will update that range. Regards, Viktor Relevant Skills and Experience Done over 100 projects on google services automation. Proposed Milestones $61 USD - Create Google Script That Can Edit Protected Cells in Google Sheets
$61 USD in 1 day
4.8 (40 reviews)
5.6
5.6
User Avatar
Hi I am very,very interested in your project I have 6 years of web development experience such this projects. Proposed Milestones $111 USD - milestone
$111 USD in 1 day
4.9 (7 reviews)
4.3
4.3
User Avatar
Dear Sir or Ms. I am John, pleased to meet you. All your requirements are achievable. Relevant Skills and Experience I'm well experienced in Google Apps Script and G Suite. Please, take a look at my portfolio in my profile. Thank you for your time ! John Proposed Milestones $98 USD - Final deliverable
$98 USD in 7 days
4.9 (13 reviews)
3.6
3.6
User Avatar
Hi Motyar from India here. I have good experience of working with "Google app scripts" I can deliver this project successfully. Hire me. Relevant Skills and Experience Google app scripts Proposed Milestones $277.78 USD - All Are you available to discuss?
$277 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Boston, United States
4.9
20
Payment method verified
Member since Feb 14, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.