Google Apps Script - need help with setup
11 571 USD For those who find it inconvenient to read, everything written in text is explained in the video: Explaining the problem: https://svajok.tinytake.com/msc/MTA1Mjk5OTFfMjQyMjk1NzE explaining what solution I expect: https://svajok.tinytake.com/msc/MTA1MzAwMDhfMjQyMjk1ODg
- I am an admin in the organization's Google account, and the organization has many different files in Google Drive. Many of them have app scripts embedded. When I write this app script, I usually open the Google Sheet I need, click on Extensions-App Script, and write the code I need
- After writing the app script code, the Google system asks me to grant my app script access to my Google account, and I confidently do this (I trust my own code). One of the permissions I grant to the code is "Delete any files on Google Drive".
- Now, I need to grant access to a Google Sheet to a company employee so that he can enter some data into the cells. When I open access, I can choose one of three options: "Viewer", "Commenter", "Editor". Obviously, the user needs to be an "Editor" to perform his work. And here the problem arises:
- If I make the user an editor, he is then allowed not only to enter data into the cells but also to edit the app script code. In theory, he can edit the code in the app script and make it so that when the document is opened, the code deletes all my data from Google Drive (after all, at an earlier stage, I granted the app script access to delete files). This is a security hole. I need users to be able to edit cells in the sheet but not be able to edit the app script.
I asked neural networks how to solve this problem, and they suggested the following solution:
3. Use a separate Apps Script project
Instead of embedding the script in the document, create a separate Apps Script project that will manage the document.
In this case, users will not be able to edit the script, even if they have access to the document.
You can provide access to the document with editing rights, but the script will be under your full control.
I like this idea, but when I ask how to implement it, the neural networks respond quite unclearly; apparently, it can indeed be implemented, but since I do not understand this well enough, I have not been able to link the external script to the Google Sheet. I searched the internet for training videos but found none; all videos show how to write app scripts directly in Excel, but I need to write separately and then link them.
Therefore, I want to order: a video tutorial on how to link an external script to a Google Sheets file. If I encounter any difficulties, I need you to help me establish this connection at least in one document via TeamViewer.
-
561
90 days13 887 USD90 days13 887 USDHello!
My name is Evgeny, and I have been professionally developing mobile applications, websites, web services, and web applications for 7 years.
*The cost is indicated for 1 hour of work. To provide a more detailed price, I would like to connect/call and discuss the details.
- You can study my portfolio, reviews, and awards in my profile.
Why should you choose me?
… - I have taken 1st and 2nd places in international championships and competitions in the IT field
- I have confirmed video testimonials and letters of appreciation
- I am always available, honest, and reasonable
- I work under a contract
- I lead my own development team
I would be happy to talk to you in more detail about the project.
-
90 days11 571 USD
95 90 days11 571 USDGood day, I am ready to help you. I will do everything in the best way. I have extensive experience in the IT programming field, so please contact me and I will help solve this problem.
-
1 day11 571 USD
310 1 day11 571 USDGood day! I am interested in your project. The solutions proposed by the neural networks look correct, and their implementation should be quite simple. I am ready to discuss the details – feel free to message me!
-
1 day11 571 USD
269 2 0 1 day11 571 USDGood afternoon, I am interested in the project. The solution that the neural networks proposed to you is correct, the implementation should be simple. Write in private messages, we will discuss the project details!
-
1 day11 571 USD
1084 22 1 1 day11 571 USDGood day
I am interested in your task
In fact, the solution is very simple
I am ready to share it for a purely symbolic fee
-
10 days11 571 USD
397 56 3 1 10 days11 571 USDGood afternoon! The approach also depends on what exactly you want the script to do.. you can, as the neural network suggests, create a separate project, then link a specific Google Sheet by its ID using openById().
Alternatively, you can publish your script as a web application with access only through your email.
-
60 days11 571 USD
561 60 days11 571 USDGood afternoon
I fully understand your requirements and have the experience to create a step-by-step video guide on linking external application scripts with Google Sheets. Additionally, I can assist you via TeamViewer to ensure proper implementation and resolve any issues you may encounter.
Portfolio.
Freelancehunt
-
1 day11 571 USD
981 17 0 1 day11 571 USDHello!
Exactly. It's better to create a separate project. Feel free to reach out.
Current freelance projects in the category Javascript and Typescript
Development of the AM Mobility platform (car service, parking, insurance, car rental)
5786 USD
We are looking for a team or an experienced Full Stack developer to create the MVP of the AM Mobility platform. AM Mobility is a unified digital ecosystem for motorists, combining in one application and web platform: parking; car service; tire fitting; car wash; car rental;… Javascript and Typescript, Web Programming ∙ 2 hours 16 minutes back ∙ 54 proposals |
Gsap animations
22 USD
Good day. Corrections need to be made in the current project. A specialist is needed who works well with gsap/lenis. Animation of cards needs to be done. Detailed specifications here:… Javascript and Typescript, Web Programming ∙ 8 hours 1 minute back ∙ 12 proposals |
Commercial on-premise video communication platform "ViM"It is required to develop an on-premise video conferencing system with a basic calculation for 100 simultaneous connections (10 isolated rooms of 10 people each). The platform should have a built-in architecture for future horizontal scaling up to 1000 users by adding new media… Javascript and Typescript, Web Programming ∙ 1 day 3 hours back ∙ 26 proposals |
I am looking for a mentor with Claude Code to launch a web project from scratch.Brief about the task: I am a beginner with no programming experience. I have a ready specification for website development (42 pages, Next.js, PostgreSQL). I want to implement it myself using Claude Code - I need a specialist who will set up the environment and teach me how to… Javascript and Typescript, Tuition ∙ 2 days 7 hours back ∙ 18 proposals |
Website design updateIt is necessary to update the design of the existing website using HTML, CSS, JS: refresh the appearance, make it modern and responsive for mobile devices. Smooth animations and interactive elements need to be added. HTML & CSS, Javascript and Typescript ∙ 3 days back ∙ 89 proposals |
Vilnyus