This is a quick start guide on setting up Google App Script and using it in G Suite applications. Mainly, I will go through Google Sheets and Google Drive since they are the most widely used services.
This is meant to remove the layer of repetitive mundane house keeping tasks via automation. In my side hustle, we have shifted our files from dropbox to Google Drive recently, bestowing us the ability to automate our tasks with Google App Scripts.
Head to your Google App Scripts console. There are many functions you can explore here. I will touch on just 3. Mainly the projects, executions and triggers.
Every project holds the script to execute based on a trigger. It is up to your jurisdiction to decide if a project should uphold a Single Responsibility Principle or do multiple task as part of a bigger singular operation.
Clicking on the ‘New Project’ button near the top left of the screen will bring you to the code editor where you can code your script.
In a script, you can define any number of functions. The exact function to run can be chosen during the trigger selection process. The usual setup is to have a main function, and the other functions are helpers.
The most important thing in coding is debugging. After all, it makes up most of our time as software developers.
– 1% actually coding
– 40% debugging
– 15% coffee breaks
– 30% googling errors
– 9% staring with your colleagues at the screen
– 5% trying copy/pasted solutions from Stack Overflow
— Catalin Pit 💡🚀 (@catalinmpit) March 16, 2020
In App Script, there is no luxury to debug the code interactively. You will need to rely on the usual logger. To print a log, write the code as such:
There are 2 ways to view the logs.
First, within the script editor, go to View -> Logs. A dialog box will popup to show you the logs. A shortcut on mac is cmd + enter .
Second, is from the “My Executions” page back in the App Script console. I personally prefer looking at the logs through there because it does not only show its output but also other details like whether it is even running in the first place.
Click on the play arrow button to execute the function for debugging purposes.
In the App Script editor, click on the clock icon to bring yourself to the function’s triggers page.
Add a trigger by clicking the bottom right button. A dialog box will popup and you can select the conditions of the trigger.
You can select the function in the script to run, as mentioned earlier, and the type of trigger. For Google Sheets, there are more options for triggering the script. More on that later.
Before you begin, it is good to know that every entity in G Suite have an id . This id is the gibberish string that you see in the URL of an opened Google Sheets, Google Docs or even a folder in Google Drive. It is highlighted in yellow in the image below.
Google Docs ID
Knowing the id of the particular file or folder allow you to carry out your operations without having to write the code to search for it. Then again, you can search them by name.
The entities that can be called and utilized in the App Script are documented here. Let’s take a look at DriveApp for example.
Example With Google Drive On Time Driven Trigger
Let’s say you want to remove editors you previously gave access to in your files. You want them to be removed when the files are moved into a particular folder.
Given the ID_OF_FOLDER , this script will iterate through all the files in that folder, and for each file it will check if its editors’ emails are under the list of approved emails. If their email is not in the list, they are stripped of the editor role in the file.
The last step is to setup the time driven trigger to your liking.
The code, unfortunately, cannot be optimized by checking the lastUpdatedDate() of the file and sparing the need to loop through editors for files that were moved into this folder eons ago. This is because moving files into different folders does not update the file’s lastUpdatedDate() .
Albeit a small inconvenience, I do expect more features and attributes in the future in App Script to be developed for us to utilize and optimize our codes. Until then, I sincerely hope that it stays free, as it already it right now, without any usage limitation or tiering. In fact, I hope it stays free forever!
Example With Google Sheet OnEdit Trigger
Let’s look at another example with Google Sheet. In a spreadsheet, we want to compile the values entered in a sheet into another sheet in the same spreadsheet in real time. Simple and straightforward. Let’s see how we can work on it.
Before that, take note of an extremely crucial step. Make sure the spreadsheet is a Google Sheet. If you uploaded a Microsoft Excel sheet and opened it using Google Spreadsheet, you will not be able to run any App Script until you convert it to a Google Sheet. If this applies to you, go to File -> Save as Google Sheet as shown below to make this necessary change.
Save as Google Sheets
The function is as shown below.
We get the row and column that the user was editing on, whichever sheet that was, and multiply its value by 2 before saving it in the same row and column in the desired sheet with the name Target Sheet .
Now to add the trigger. In the script editor, click on the clock icon. It will bring you to the triggers of this project. Click on the button to add trigger on the bottom right of the page. Under Select event source , you will now see a new option From spreadsheet , and when you select it, you can select the event type to kickstart the function. We are looking for the onEdit event type for this case.
As you can see, this project is associated to only 1 spreadsheet – the spreadsheet it was created from. Additionally, each spreadsheet can have only 1 project as well.
Hence, you cannot have the same script running on different spreadsheet. At least if you did it this way. There may be another way to do so and overcome this restriction but I have yet to explore it.
The potential of App Scripts does not end here. Other than scripts, you can even code out html views to present visual dashboard based on real time changes.
On top of that, you can publish you own app scripts, as well as use the scripts other developers have made. This forms a community can supercharge automation to increase productivity.
Make use of App Script and automate away!
One thought on “ How To Setup And Debug Google App Script ”
Hey Friend thanks for your script but not work for me because in my files has only “readers” not “editors” and Could you help to modify your script ?
Complete the steps described in the rest of this page, and in about five minutes you’ll have automatically created a Google Form based on data in a spreadsheet, then set it up to email Google Calendar invites and a personalized Google Doc to everyone who responds.
Set it up
- Make a copy of the sample spreadsheet Apps Script Quickstart: Managing responses for Google Forms.
- From within your new spreadsheet, select the menu item Tools > Script editor. If you are presented with a welcome screen, click Blank Project.
- Rename the Code.gs file to forms.gs .
Replace any code in the forms.gs file with the code below:
- Select the menu item File > Save. Name your new script and click OK.
Format dates and set locale
- Select File > Spreadsheet settings.
- Set the correct locale and time zone. Click Save settings.
- Reformat the dates in the spreadsheet to your local format. For example, in the UK you should use dd/mm/yyyy.
Try it out
- Switch back to your spreadsheet and reload the page.
- After a few seconds, a new custom menu, Conference, will appear. Click it and select Set up conference.
- A dialog box will appear and tell you that the script requires authorization. Click Continue. A second dialog box will then request authorization for specific Google services. Read the notice carefully, then click Allow.
- The script will take a few seconds to run. You’ll know it’s complete when the yellow bar at the top of the screen disappears.
- The Conference menu will now be gone, but you will see a new Form menu instead. Click it and select Go to live form.
- Fill out the form to indicate which sessions you’d like to attend at this fictional conference. If you have more than one Google account, use a different email address for this form than the account you used to create the script. (You don’t need to log in to the second account; just type in the email address at the top.) When you’re done, click Submit.
See the results
- Open your Google Calendar and navigate to the conference dates: May 15 and 16, 2013. You’ll see an event for each session. If you used a different email address when you responded to the form, that address will have been invited as a guest for the sessions you selected.
- Open your Google Drive. You’ll see a new Google Doc that lists the sessions you selected. If you used a different email address when you responded to the form, that address will be listed as an editor. Users other than the script owner will find a copy of the document in their Shared with me view.
- Try sharing the link to the form with other people. As they respond, you’ll see the Google Calendar invites and Google Doc itineraries start to add up. If you were organizing a real conference, think about how much time this would save!
That’s it! With only a small amount of code, you’ve added a custom menu item, programmatically built a Google Form, created Google Calendar events, and told a script to send Calendar invites and personalized Google Docs on your behalf.
To continue learning about how to extend Google Forms, Calendar, and Docs with Apps Script, take a look at the following resources:
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Google Sheets lets you automate repetitive tasks with macros, and you can then bind them to keyboard shortcuts to execute them quickly. They work using Google Apps Script to capture your actions for later use.
What are Macros?
A macro—or macroinstruction—is a specific sequence of actions that let you automate a series of steps to increase productivity. They work by recording your actions and saving them into a file that’s bound to the spreadsheet in which they were recorded.
When you record a macro in Google Sheets, it automatically creates an Apps Script with all the code to replicate your actions for you. This means you can create complex macros without knowing how to write code. The next time you run it, Sheets will do everything you did when you recorded the macro. Essentially, you’re teaching Google Sheets how to manipulate a document to your liking with a single command.
Macros are a powerful feature that can do basically anything Sheets is capable of doing. Here are just a few examples of its functionality:
- Apply formatting and styles.
- Create completely new spreadsheets.
- Use any Google Sheets function, toolbar, menu, or feature.
The sky is the limit.
How to Record a Macro in Google Sheets
Fire up a Google Sheet and click Tools > Macros > Record Macro.
This opens the recording menu at the bottom of the window, with two options for capturing your actions:
- Absolute References: The macro will do tasks only on the exact cells you record. If you italicize cell B1, the macro will only ever italicize B1 regardless of what cell you clicked on.
- Relative References: The macro will do tasks on the selected cells, regardless of where they are in the sheet. If you italicize B1 and C1, you can re-use the same macro to italicize cells D1 and E1 later.
Select whether you want an absolute or relative reference, then you can start to click, format, and teach Sheets what order you want these actions to replicate.
After you’ve captured all the actions for this macro, click “Save.”
Enter a name for your macro. Google also lets you create shortcuts for up to ten macros. If you want to bind a macro to a keyboard shortcut, enter a number from 0-9 in the space provided. When you finish, click “Save.”
If you need to tweak your macro’s name or shortcut, you can edit a macro by clicking Tools > Macros > Manage Macros.
From the window that opens, tweak as desired and then click “Update.”
The next time you press the shortcut associated with the macro, it will run without having to open the macro menu from the toolbar.
How to Run a Macro in Google Sheets
If your macro is an absolute reference, you can run the macro by pressing the keyboard shortcut or go to Tools > Macros > Your Macro and then click the appropriate option.
Otherwise, if your macro is a relative reference, highlight the cells in your spreadsheet on which you want the macro to run and then press the corresponding shortcut, or click on it from Tools > Macros > Your Macro.
How to Import Macros
As mentioned earlier, when you record a macro, it gets bound to the spreadsheet on which you recorded it. But what if you want to import a macro from another spreadsheet? While it’s not a straightforward and simple task, you can do it using this little workaround.
Because recorded macros are stored as functions in Google Apps Script, to import a macro, you need to copy the function and then paste it in the new sheet’s macro file.
Open the Google Sheet with the macro you want to copy and then click on Tools > Macros > Manage Macros.
Next, click the “More” icon next to the macro you’d like to copy and then click “Edit Script.”
All macros save to the same file, so if you have a couple of macros saved, you may have to sift through them. The function’s name is the same one you gave it when you created it.
Highlight the macro(s) you want to copy, then press Ctrl + C. Be sure to copy everything up to and including the closing semi-colon.
Now, open the other spreadsheet you’ll be importing the macro to and click Tools > Macros > Record Macro.
Immediately click “Save” without recording any actions to create a placeholder function in the sheet’s macro file for us. You’ll be deleting this a little later.
Click “Save” again.
Open Google Apps Script by clicking Tools > Script Editor, and then open the macros.gs file from the left pane. Delete the existing function and then press Ctrl + V to paste in the macro from your other Sheet.
Press Ctrl + S to save the script, close the tab, and return to your spreadsheet.
Your spreadsheet reads the macros.gs file and looks for changes made to it. If a new function is detected, you can use the Import feature to add a macro from another sheet.
Next, click Tools > Macros > Import.
Finally, click “Add Function” under the macro you want to add.
Unfortunately, you will have to bind the macro manually to a keyboard shortcut again. Just follow the instruction previously mentioned, and you’ll be all set to use this macro across multiple sheets.
That’s all there is to creating and using macros in Google Sheets. There’s no limit to the routines you can create for your spreadsheets to limit the amount of time you spend doing these repetitive tasks.
I have written some code for my Google spreadsheet with the script editor.
I want to share this spreadsheet with my clients but I don’t want to share the code I have written.
This code adds a menu to my spreadsheet which contains useful functions that should work/run when my clients open this spreadsheet with condition applied that: they shouldn’t be able to see its code.
This is easy with Excel, but with Google spreadsheet I don’t know. . I have searched a lot on Google but they all gives the idea about how to share a spreadsheet. For example in “View” mode, but in that case there is a problem: my menu function, which adds a menu, is “onOpen” and doesn’t start when my clients open it.
How to implement this in Google Spreadsheet?
6 Answers 6
Publish your script as an editor add-on or as a Google Workspace add-on. Bear in mind that you could make it private, by selecting unlisted or making it available only for your G Suite / Google Workspace organization.
Add-ons were added on 2014. This is better than using a library because there will be nothing shared from your add-on.
Please note that
- it’s not possible to access Google Apps Script server-side code by using Chrome Developer Tools or another similar software.
- there are some restrictions for add-ons, study them carefully as maybe this alternative will not work for you.
- nowadays add-ons require a Google Cloud Project and an oAuth consent screen. If the add-on will be shared with external users it will requires an oAuth verification and an app review.
If publishing as add-on is not an option for you, you should rethink your solution considering the use of a web application, using the Apps Script API or the Google Sheets API.
make use of Library the documentation explains how to use it and there are a few interesting post on the subject as well
Make a special library file containing only the script for your client. Your client must have at least a read-level access. So he is able to see your script. Remove your script and make a new innocent script in that file and save this as a new version. Now your client sees only this new script. Because his application is still working on the old version of your library, the original script will do his job as usual.
- Create 2 libraries; one is dummy (I call it Lib1) and another core library that has all the secret codes (I call it Lib2).
- Add Lib2 as a library to Lib1 and use in it the necessary methods that are fully implemented in Lib2.
- Share both libraries publicly and set their permission to Viewer.
- From the sharing setting page of Lib1, there is a gear symbol. make sure the following option is unchecked “Viewers and commenters can see the option to download, print, and copy”
- Add Lib1 to your clients’ script (maybe a Spreadsheet script).
- Share the script of your client as editor or viewer.
If the client could get Lib1 ID by accessing it from Resources/Libraries menu of his script, he won’t be able to access the Resources/Libraries menu of Lib1. He also cannot make another copy of Lib1 because of the unchecked option done in step 4, preventing him from possibly seeing the ID of Lib2.
Apart from the options listed under ‘Publish’ menu in the script editor window, the below 3 options may also keep code private to the developer.
3 files are to be created:
1.1 A spreadsheet to receive the user input, this serves as a user interface, and is to be shared with the user.
1.2 A standalone library script file to receive the input from the UI spreadsheet.
1.3 A standalone private script file to process the data which the library file receives.
As a reference for this option is a spreadsheet at the above link.
When ‘Submit’ is clicked, the spreadsheet ID is sent to the library script file and the developer is given editor permission. The private script file then opens the file and processes the input.
5 files are to be created
2.1 A spreadsheet which serves as a login screen. This is shared with the user.
2.2 A spreadsheet which serves as the actual application that contains the data. A user interface. This spreadsheet is made available to the user after successful login. The user logs-out of the application from this sheet.
2.3 A spreadsheet which maintains the login status of the user. This is private to the developer.
2.4 A library script file which updates the login status of the user in the spreadsheet created in the step above and changes the access permission to the private script file. This script file is included as a library resource in both the login spreadsheet and user interface spreadsheet.
2.5 A library script file which processes the data entered in the user interface sheet. This script file contains code that the developer wants to keep private. This file is included as a library resource in the user interface spreadsheet only.
As a reference for this option is a spreadsheet at the above link.
When the user clicks the ‘Get Started’ button the user is logged into the application after updating the cell value in spreadsheet 2.3.The library script file which contains private code is set to shareable after successful Login by using addViewer method. A link to the application is presented to the user and the user interacts with the application while ‘Logged in’. When the user logs-out from the application removeViewer method is called to make the script file private again.
In this option, the private code file is accessible to the users while they use the application. The file may be kept private by using timers, script triggers, prompts, alerts, etc.
In both of my spreadsheets I use time based triggers set to run every minute to process the applications. This may cause the output to be delayed. The triggers are created on the server side and not at the client side.
Option 3: Private shared folder
2 files are to be created:
3.1 A spreadsheet to receive the user input, this serves as a user interface, and is to be shared with the user.
3.2 A standalone private script file to process the spreadsheet.
Please refer this link on how to create a private shared folder. In this option, no script is visible to the user. Even the shared spreadsheet may not contain code.
3 hours ago How to find answers on Google Forms. Open your Google Form. Click on “Responses.”. After you’ve opened the Responses tab, you will be able to view answers in three different ways: “Summary,” “Question,” and “Individual.”. Click on the “Summary” tab to view a summary of all answers submitted to your Google Form.
2 hours ago Google forms quiz page source shows correct answers . 5 hours ago google forms quiz page source shows correct answers. It is very easy and known even among not very tech-savvy students that it is terribly easy to cheat on a google form quiz. When displaying the source code at the bottom it shows the questions and the correct answer for both multiple choice and …
Google forms quiz page source shows correct answers
5 hours ago google forms quiz page source shows correct answers1. google forms quiz page source shows correct answers. It is very easy and known even among not very tech-savvy students that it is terribly easy to cheat on a google form quiz. When displaying the source code at the bottom it shows the questions and the correct answer for both multiple choice
Is there a way to see all the answers (cheat) on Google Forms?
1 hours ago Answer (1 of 3): Hi, To find the responses to your Google Forms, You need to open your form again. You can find your form in Google Drive if you don’t have the link of it. Then you need to head towards “ Responses “ section. (Can check the image below) From here you would be …
8 hours ago Google forms cheats help you see any quiz and survey answers in a few minutes (latest) type your email id(any emails to contact you) associated with this process. Yes, google forms responses are stored in a worksheet that can only be accessed through a google account login. After you copy down the password, type it into your gmail login.
How to Hack Google Form Answers ️ Work 100% Randd Soft
9 hours ago How to Hack Google Form Answers – Google Forms is a service provided by Google for filling out forms. The fraudulent way to see the answer key, how to hack google form answers? Really use a cellphone, Students can find out the answers to the google form questions? Then how to hack google form answers by looking at the google form answer key.
4 hours ago Google forms answer cheat. For people who didn’t know, you can view page source for a non locked mode google form and scroll down towards the bottom to find the answers. Edit 2: u/TechnoGhoul5 discovered that multiple choice works as well, this comment for more.
8 hours ago One of the easiest ways to view the answers received on your Google Forms is from the Google Forms itself. Step 1: Open your Google Form from Google Drive. Step 2: Click/tap on the Responses tab
3 hours ago Are you worried about students cheating during your quizzes and test during virtual learning at home. This video is for you. Link to chrome extension:https:
3 hours ago IN THIS VIDEO I WILL SHOW YOU HOW TO CHEAT ON A GOOGLE FORM AGAIN. If you liked this video please subscribe!Subscribe HERE: https://www.youtube.com/channel
3 hours ago How to Get the Answers on Google Forms! (Updated 2020)14 year old YouTuber from Oregon. Subscribe to follow me through my life on camera!Recent video: Twitch
Is it possible to cheat from a Google Form quiz? Quora
9 hours ago Answer: I’m going to assume that someone is using Google Forms to administer some sort of online quiz or exam. So aside from being immoral and probably against any possible code of conduct you’re being expected to follow… The way Google forms works is that it collects submissions or responses fr
3 hours ago Please SUBSCRIBE So You don’t miss the Updated Method of this!! I am working on it and it will be Out Soon!I will be showing you how to Get The Answers For G
8 hours ago However, on their own, Google forms are pretty limited in their functionality, just dumping data into a Google spreadsheet document (which can be exported, but you still have to regularly log into your Google account to view the data.) Forms do have the option of sending an email alert whenever someone fills out the form, but the alerting email
Google Forms cheat sheet Computerworld
5 hours ago Google Forms cheat sheet How to use Google Forms to create online surveys, quizzes and feedback pages.
Explore some of the amazing things you can do with Google Apps Script within Google Spreadsheets
Course included multiple useful code snippets to help you supercharge your Google Apps Script applications.
The SpreadsheetApp Class has a lot of really great functionality in the course lessons we will be exploring how to make use of some of these functions, adding them to mini projects that students are encouraged to build upon and extend upon.
- Appending new rows of content to Google sheets
- Setting styling like font size to cells
- Setting of formulas within cells
- Updating values dynamically
- Use of UI object within the spreadsheet Class Ui
- Creating custom functions find and replace for sheet menu
- Getting Cell data and updating cell data, getting formulas.
- Create content from spreadsheet as HTML tables- then email it or use in a web app
- Email service sending emails to active user
- Copying spreadsheet as a PDF – creating a blob and emailing the PDF
- Selecting and getting active selected content
- Search option added to user menu – searching gDrive folders and returning results into Spreadsheet
- Adding folder search results to a spreadsheet
- Checking for values in sheet and updating column values depending on result
- Copy and duplicate of sheet contents
UI – An instance of the user-interface environment for a Google App that allows the script to add features like menus, dialogs, and sidebars. A script can only interact with the UI for the current instance of an open editor, and only if the script is container-bound to the editor.
Source code is included so you can copy and paste the code to try for yourself.
Step by step learning
Fast friendly support is always available within the Q&A section
Experienced instructor with over 20 years of experience ready to help you learn
You have nothing to lose – Join now and start learning to create your own version of this helpful application today.
- Web developers
- Application Developers
- Coders who want to explore how to use Google Apps Script
- Anyone who wants to learn more about Google Script
- Anyone who wants to create amazing applications
- Anyone who wants to power up their Google Suite of Products with really amazing features
I’m here to help you learn, achieve your dreams, come join me on this amazing adventure today
Google Developers Expert – GSuite
Providing Web development courses and digital marketing strategy courses since 2002.
Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.
“I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998. I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides.”
“Learning, understanding with a strong passion for education. The internet has provided us with new opportunities to expand and share knowledge.”
Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online. Technology connects us all in many ways. It opens up doors to those who embrace it and learn how to make those connections real.
“My courses are designed to help you achieve your goals, learn and update skills”
“Understanding technology provides a means to better connect with users. It also opens so many doors. Knowledge is the key to success and I want to help you experience what technology has to offer. I’m passionate about web technologies, and look forward to sharing my knowledge and experience with you!”
A form that contains overall properties and items. FormApp: Allows a script to open an existing Form or create a new one. FormResponse: A response to the form as a whole. GridItem: A question item, presented as a grid of columns and rows, that allows the respondent to select one choice per row from a sequence of radio buttons. GridValidatio Note that the doGet() function for templated HTML differs from the examples for creating and serving basic HTML.The function shown here generates an HtmlTemplate object from the HTML file, then calls its evaluate() method to execute the scriptlets and convert the template into an HtmlOutput object that the script can serve to the user.. The HTML <form> element is used to create an HTML form for user input: <form>. . form elements. . form>. The <form> element is a container for different types of input elements, such as: text fields, checkboxes, radio buttons, submit buttons, etc
Video: Google Apps Script with HTML Forms – Stack Overflo
Erstellen Sie eine Umfrage – allein oder gemeinsam mit anderen. Wählen Sie aus einer Vielzahl von Designs oder gestalten Sie eigene Entwürfe. Analysieren Sie die Ergebnisse in Google Formulare .. RIP Tutorial. en English (en) Français //Triggered when the page is navigated to, serves up HTML function doGet() < var template = HtmlService.createTemplateFromFile('index'); return template.evaluate() .setTitle('Example App') .setSandboxMode(HtmlService.SandboxMode.IFRAME); >//Called from the. Adding a custom menu in Google Apps Script. In its current form, our program is pretty useless for many reasons, not least because we can only run it from the script editor window and not from our spreadsheet. Let’s fix that by adding a custom menu to the menu bar of our spreadsheet, so that a user can run the script within the spreadsheet without needing to open up the editor window. This. Forms are used in webpages for the user to enter their required details that further send it to the server for processing. A form is also known as a web form or HTML form. Examples of form use are prevalent in e-commerce websites, online banking, online surveys to name a few. Syntax for form in HTML
Class Form Apps Script Google Developer
- Google Forms is an easy-to-use form solution that makes anything from collecting feedback from customers all the way to receiving submissions for jobs and volunteers extremely easy. In this post, we’re going to show you how you can embed Google Forms on your website.. You’ll be pleased to hear that this guide will show you how to easily embed a Google Form on your WordPress website in just.
- Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite
- in den Kalender eintragen (Google Tabellen) Script: Nur Text: Textinhalt vergleichen und Zelle markieren + reguläre Ausdrücke (Google Tabellen Script) YouTube : TODO Liste mit Verschiebung erledigter Aufgaben in Google Tabellen Script: YouTub
How to Submit an HTML Form to Google Sheetswithout Google