Haddii aad isticmaasho adeegyada Google sida Google Docs , Google Sheets , Google Analytics , Gmail , iyo kuwa kale, waxaad ku xidhi kartaa oo aad otomaatig u samayn kartaa adeegyadaas adigoo isticmaalaya Google Apps Script . 

Ka fikir qoraalka Google Apps^{(Google Apps Script)} sida nooca Google ee qoraalka VBA ee Microsoft^{(Microsoft’s VBA script)} . Sida aad u habayn karto hawlaha iyo hawlaha ama aad u habayn karto macros gudaha Microsoft Word iyo Excel VBA^{(Excel with VBA)} , waxaad si otomaatig ah ugu samayn kartaa hawlaha iyo hawlaha guud ahaan adeegyada Google . Adeegyada sida Xaashiyaha iyo Dukumentiyada^(Docs) , waxaad xitaa qori kartaa liiskaaga gaarka ah.

Maqaalkan waxaad ku baran doontaa sida loo galo oo loo sahlo Apps Script adeegyadaada kala duwan ee Google^{(various Google services)} , sida loo dhex galo Apps Script editor , iyo sida loo xidho adeegyada. Ma baran doontid hawlo gaar ah oo qoraal ah^{(learn specific script functions)} , laakiin Google waxa ay haysaa dukumeenti aad u wanaagsan iyo casharro qoraaleedka abka oo diyaar u ah in ay bartaan sida loo qoro Script Apps^{(Apps Script)} .

Sida loo galo Google Apps Script editor^{(Access Google Apps Script Editor)}

Waxaad ka furi kartaa tifaftiraha koodka qoraalka Apps Google^{(Google Apps Script)} adiga oo ka dhex furi kara dhowr adeeg oo Google ah. Tusaale ahaan, waxaad ka heli doontaa Script Apps menu ^{(Apps Script)}Extensions gudaha Google Sheets.

Adeegyada kale, waxaad ku furi kartaa tifaftiraha qoraalka Google Apps^{(Google Apps Script)} siyaabaha soo socda:

• Google Docs : Dooro tifaftiraha qoraalka^{(Script editor)} ee liiska agabka^(Tools) .
• Slides Google^{(Google Slides)} : Dooro tifaftiraha qoraalka^{(Script editor)} ee liiska agabka^(Tools) .
• Foomamka Google^{(Google Forms)} : Dooro tifaftiraha qoraalka^{(Script editor)} ee liiska saddexda dhibcood.
• Google Drive : Midig ku dhufo meel kasta oo banaan, dooro Wax badan^(More) , oo dooro Google Apps Script .

Isticmaalka mid ka mid ah hababkan, waxaad arki doontaa tifaftiraha code Script Apps^{(Apps Script)} oo furan tabo cusub. Tani waa daaqada aad ku qori doonto mid kasta oo ka mid ah hawlaha ka kooban qoraalkaaga oo dhan. Sida caadiga ah, waxaad arki doontaa shaqo madhan oo magaceedu yahay myFunction() kaas oo diyaar kuu ah inaad bilowdo buuxinta koodka.

Fiiro gaar^(Note) ah: Habaynta koodhka ayaa aad muhiim u ah si looga fogaado khaladaadka. Isticmaal faallooyin sida ku cad koodka soo socda si aad naftaada u xasuusisid waxa aad isku dayday inaad ku samayso qaybaha koodka. Tani waxay aad ula mid tahay sida faallooyinku ugu shaqeeyaan koodhka HTML ee barnaamijka webka.

Markaad dhex socoto tifaftiraha koodka, waxaad ku soo noqon kartaa qaybtan adigoo dooranaya Code.gs dhinaca bidix ee navigation-ka daaqada Tafatiraha^(Editor) . Si aad u aragto daaqadaha kale ee la heli karo, dul bood calaamadaha ku yaal shayga bidix ee fog waxaana furmi doona shayga ugu weyn ee navigation.

Qaybta dulmarku^(Overview) waa meesha aad ka heli karto tirakoobyada qoraalkaaga sida inta khaladaad ee dhacay, inta jeer ee la fuliyay, iyo in ka badan.

Waxaan ku dabooli doonaa mid kasta oo ka mid ah qaybaha kale ee Google Apps Script tifaftirayaasha qayb kasta oo hoose.

Dhex mara Google Apps Script Script^{(Google Apps Script Editor)}

Marka aad wax ka beddesho code-kaaga tafatiraha, waxaa fiican in aad doorato calaamadda saxanka ( Save ) inta badan si aadan u lumin shaqadaada.

Marka la keydiyo, waxaad arki doontaa xulashooyinka menu ee kale oo shidan. 

Kuwaas waxaa ka mid ah:

• Orod^(Run) : Isku day inaad ku socodsiiso qoraalkaaga oo dhan min bilow ilaa dhamaad.
• Debug : Ka gudub qoraalkaaga hal xariiq mar.
• Hoos u dhigista shaqada^{(Function dropdown)} : dhex gal oo u gudub mid kasta oo ka mid ah hawlaha aad abuurtay.
• Diiwaangelinta fulinta^{(Execution log)} : Arag xaalad kasta ama fariimaha khaladka ah ee iskuday kasta oo aad samaysay si aad u socodsiiso qoraalkaaga.

Ikhtiyaarka maktabadaha^(Libraries) ee ku yaal liiska navigation-ka bidix waa meesha aad ka geli karto maktabadaha ay dadka kale qoreen (ama aad ku qortay oo aad meel kale ku kaydsatay). Tani waa faa'iido haddii aad leedahay saaxiib hore u qoray sifo aad jeclaan lahayd inaad ku isticmaasho Google Sheets ama Google Docs laakiin waxaad jeclaan lahayd inaad ku darto sifooyin dheeraad ah taas.

Waxa kaliya ee aad u baahan tahay inaad ku darto maktabadaha mashruucaaga waa aqoonsiga qoraalka^{(Script ID)} . Tan waxaad ka heli kartaa qaybta dejinta mashruuca, kaas oo aan ku tusi doono sida loo helo dhammaadka maqaalkan.

Add-Ons Adeegyada Qoraal Google Apps

Qaybta Adeegyada^(Services) ayaa ah tan ugu faa'iidada badan. Waa meesha aad ku dari karto qoraalkaaga hadda adeegyada kale ee Google ee laga yaabo inaad isticmaasho. 

Markaad doorato, waxaad arki doontaa ku dar daaqada adeega^{(Add a service)} oo furan. Hoos^(Scroll) ugu dhaadhac adeegga aad rabto inaad u isticmaasho sidii ku-darka mashruucaaga jira. 

Tusaale ahaan, haddii aad jeclaan lahayd inaad ka soo saarto xogta koontadaada Google Analytics qoraalkan, waxaad dooran kartaa API Google Analytics^{(Google Analytics API)} , oo dooro Ku dar^(Add) .

Haddii aad rabto inaad hesho faahfaahin ku saabsan hawlaha diyaarka u ah inaad u isticmaasho adeegga cusub ee ku-darka iyo sida loo isticmaalo, dooro saddexda dhibcood ee dhanka midig ee API -ga oo dooro Eeg dukumentiga^{(See documentation)} .

Tani waxay ku furi doontaa dukumeentiga qoraalka Google Apps^{(Google Apps Script)} tab cusub, oo si toos ah ugu furmay qaybta adeega Google .

Sahami dukumeentiyada sintax-shaqeedka, casharrada, iyo tusaalooyinka koodka ee aad ku isticmaali karto qoraalkaaga.

Sidoo kale, ogow in aad u socon karto qaybaha kale ee dukumeentiyada si aad u aragto shaqooyinka guud ee laga heli karo qoraalkaaga iyadoo lagu salaynayo adeegii aad isticmaalaysay markii ugu horaysay ee aad furto tifaftiraha koodka Apps Script .

Tusaale ahaan, haddii aad furto tifaftiraha xaashida Google^{(Google Sheets)} , ka eeg qaybta xaashiyaha ee liiska waraaqaha Google Sheets ee^(Sheets) aad awoodo inaad ku isticmaasho qoraalkaaga.

Dejinta iyo Isticmaalka Kiciyeyaasha Qoraalka Qoraalka Apps^{(Using Apps Script Triggers)}

Muuqaal kale oo faa'iido leh oo ku jira qoraalka Google Apps^{(Google Apps Script)} waa awooda lagu dejiyo kiciyeyaasha iyadoo lagu saleynayo dhowr dhacdo ama jadwalyo.

Si loo habeeyo kiciye cusub ee qoraalkaaga, ka dooro Kiciyeyaasha^(Triggers) ka menu navigation ee bidix ee fog. Daaqadda cusub ee Kiciyeyaasha^(Triggers) ee furmay, dooro badhanka Ku dar Kiciyaha^{(Add Trigger)} .

Daaqadda dar kicinta^{(Add Trigger)} waxay leedahay liis dheer oo ikhtiyaari ah kuwaas oo kaa caawinaya inaad si sax ah u habayso sida iyo goorta aad rabto in qoraalkaagu shaqeeyo. 

Xusuusin^(Note) : Qaar badan oo ka mid ah xulashooyinkan waxay ku xiran yihiin adeegga aad u qorayso qoraalkaaga ama API-yada aad ku dartay^{(the APIs that you’ve added)} .

Si aad u dejiso kicintaada, waxaad u baahan doontaa inaad doorato:

• Shaqada marka hore la bilaabayo
• Isha dhacdada sida waqti gaar ah, taariikh, ama dhacdo ku jirta adeegaaga sida marka unugga xaashida Google beddelo ama dukumeenti marka hore la furo
• Nooca dhacdada sida marka wax ku jira xaashidaada Google ama dukumeenti la furay ama la tafatiray, ama goobta gaarka ah ee taariikhda ama wakhtiga
• Inta jeer ee ogeysiiska ee inta jeer ee aad rabto inaad hesho warar ku saabsan marka qoraalladaadu guul darraystaan

Marka aad doorato Keyd^(Save) , waxa aad arki kartaa fariinta " Oggolaanshaha Qoraalku^(Script) guuldareystay" haddi ay tahay markii ugu horaysay ee aad kaydsato kiciye cusub.

Tani waxay badanaa kicisaa haddii aad leedahay xannibaadiyaha pop-up oo karti u leh browserkaaga. Haddii aad isticmaalayso Google Chrome , kaliya dooro summada daaqadda yar oo ay ku dul taal casaan “X” U beddel goobta oo mar walba oggolow soo-bandhigyada^{(Always allow pop-ups)} oo dooro La sameeyay^(Done) .

Markaad dooratid Save again^(Save) , waxaad u baahan doontaa inaad ka gudubto nidaamka si aad u oggolaato qoraalka aad u qortay inuu ku hoos socdo akoonkaaga Google ama Google Workspace .

Marka hore, dooro koontada Google -ka ee aad rabto inaad u ogolaato qoraalkaaga inuu hoos ku shaqeeyo.

Waxaad arki doontaa digniin ah in shaqada gaarka ah ama qoraalka aad qortay aanu Google "xaqiijin " Haddii aad tahay qofka qoray qoraalka, markaa tani macno ma samaynayso waana badbaado inaad ku hoos shaqeyso Google Account ama Google Workspace .

Si aad digniintan uga gudubto, kaliya dooro Advanced ka dibna dooro Go to <project> (unsafe) isku xidhka hoose.

Ugu dambayntii, daaqadda ogolaanshaha, dooro Oggolow^(Allow) si aad ugu oggolaato hawlahaaga gaarka ah iyo qoraalka inay ku hoos socdaan akoonkaaga Google ama Google Workspace .

Uma baahnid inaad dib ugu soo celiso nidaamkan, kaliya marka ugu horraysa ee aad kaydiso ama maamusho mashaariicdaada qoraalka ah ee  Google Apps .

Galitaanka Aqoonsigaaga Qoraalka Google

Mid ka mid ah qoraallada ugu dambeeya - waxaa laga yaabaa inaad rabto inaad siiso saaxiibbadaada ama asxaabtaada si ay u isticmaalaan qoraalkaaga ama ugu daraan maktabad ahaan qoraalkooda. 

Waxaad ka heli kartaa aqoonsigaaga qoraalka^{(Script ID)} hoostiisa icon Settings ee dhinaca bidix ee cirifka.

Aqoonsiga qoraalka^{(Script ID)} waxaa laga heli karaa hoosta qaybta aqoonsiga^(IDs) , dhanka midig ee aqoonsiga qoraalka^{(Script ID)} .

Sida aad arki karto, tifaftiraha Google Apps Script waa mid toos ah haddii aad taqaanid sida loo maro sifa kasta oo aad rabto inaad isticmaasho. Kaliya^(Just) iska hubi inaad si fiican u barato Google's Script Script^{(Apps Script)} si aad u bilowdo inaad barato sida loo qoro qoraaladaada iyo dhammaan hawlaha diyaarka u ah in la isticmaalo.

Google Apps Script Editor: Everything You Need to Know to Get Started

Іf yоu use Goоgle serviсes like Google Docs, Google Sheets, Google Analytics, Gmail, and others, you could connect and autоmatе those serviceѕ using Google Apps Script. 

Think of Google Apps Script like Google’s version of Microsoft’s VBA script. Just like you can automate actions and tasks or customize macros in Microsoft Word and Excel with VBA, you can automate tasks and actions across Google services. In services like Sheets and Docs, you can even write your own custom menus.

In this article you will learn how to access and enable Apps Script in your various Google services, how to navigate the Apps Script Editor, and how to connect services. You won’t learn specific script functions, but Google has excellent documentation and apps script tutorials available to learn how to write Apps Script.

How to Access Google Apps Script Editor

You can open the Google Apps Script code editor from within a number of Google services. For example, you’ll find Apps Script in the Extensions menu inside Google Sheets.

In other services, you can open the Google Apps Script editor in the following ways:

• Google Docs: Select Script editor in the Tools menu.
• Google Slides: Select Script editor in the Tools menu.
• Google Forms: Select Script editor in the three-dot menu.
• Google Drive: Right-click any blank space, select More, and select Google Apps Script.

Using any of these methods, you’ll see the Apps Script code editor open in a new tab. This is the window where you’ll write each of the functions that make up your entire script. By default, you’ll see an empty function named myFunction() that’s ready for you to start filling in your code.

Note: Code formatting is very important in order to avoid errors. Use commenting as shown in the following code to remind yourself what you were trying to do inside sections of code. This is very similar to how commenting works in HTML code with web programming.

As you navigate the code editor, you can return to this section by selecting Code.gs in the left navigation pane in the Editor window. To see other available windows, hover over the icons in the far left pane and the main navigation pane will open.

The Overview section is where you can find statistics about your script like how many errors have occurred, how many times it’s executed, and more.

We’ll cover each of the other sections of the Google Apps Script editor in each section below.

Navigating the Google Apps Script Editor

As you edit your code in the editor, it’s a good idea to select the disk (Save) icon often so that you don’t lose your work.

Once saved, you’ll see the other menu options light up. 

These include:

• Run: Attempt to run your entire script from beginning to end.
• Debug: Step through your script one line at a time.
• Function dropdown: Browse through and navigate to each of the functions you’ve created.
• Execution log: See any status or error messages from each attempt you’ve made to run your script.

The Libraries option in the left navigation menu is where you can access libraries that other people have written (or you’ve written and saved elsewhere). This is useful if you have a friend who already wrote a feature you’d like to use in Google Sheets or Google Docs but you’d like to add additional features on top of that.

All you need to add those libraries into your project is the Script ID. You can find this in the project settings section, which we’ll show you how to find toward the end of this article.

Google Apps Script Services Add-Ons

The Services section is the most useful. It’s where you can integrate your current script with other Google services you may use. 

When you select it, you’ll see the Add a service window open. Scroll down to the service you want to use as an add-on to your existing project. 

For example, if you’d like to pull data from your Google Analytics account into this script, you can select the Google Analytics API, and select Add.

If you want to find details about what functions are available to use for that new add-on service and how to use them, select the three dots to the right of the API and select See documentation.

This will open the Google Apps Script documentation in a new tab, opened automatically to the section for that Google service.

Explore the documentation for function syntax, tutorials, and code examples that you can use in your own script.

Also, note that you can navigate to other sections of the documentation to see what general functions are available in your script based on the service you were using when you originally opened the Apps Script code editor.

For example, if you opened the editor in Google Sheets, check the Sheets section in the documentation menu for Google Sheets functions you’re able to use in your script.

Setting Up and Using Apps Script Triggers

Another useful feature in Google Apps Script is the ability to set triggers based on a number of events or schedules.

To configure a new trigger for your script, select Triggers from the far left navigation menu. In the new Triggers window that opens, select the Add Trigger button.

The Add Trigger window has a long list of options that help you customize exactly how and when you want your script to run. 

Note: Many of these options depend on the service you’re writing your script for or the APIs that you’ve added.

To set up your trigger, you’ll need to choose:

• Which function to initially launch
• The event source such as a specific time, date, or an event in your service like when a Google spreadsheet cell changes or a document is initially opened
• The event type such as when something in your Google spreadsheet or document is opened or edited, or the specific setting for date or time
• Notification frequency for how often you want to get updates about when your scripts have failed

Once you select Save, you may see a “Script authorization failed” message if it’s the first time you’ve saved a new trigger.

This is usually triggered if you have a pop-up blocker enabled in your browser. If you’re using Google Chrome, just select the small window icon with a red “X” over it. Change the setting to Always allow pop-ups and select Done.

When you select Save again, you’ll need to step through the process to authorize the script you’ve written to run under your Google account or Google Workspace.

First, select the Google account that you want to allow your script to run under.

You’ll see a warning that the custom function or script you wrote isn’t “verified” by Google. If you’re the person who wrote the script, then this doesn’t matter and it’s safe to run under your own Google Account or Google Workspace.

To bypass this warning, just select Advanced and then select the Go to <project> (unsafe) link at the bottom.

Finally, in the permissions window, select Allow to allow your custom functions and script to run under your Google account or Google Workspace.

You won’t have to repeat this process again, only the first time you save or run your custom Google Apps script projects. 

Accessing Your Google Script ID

One final note – you may want to provide your script to friends or colleagues so they can either use your script or add it as a library to their own script. 

You can find your Script ID under the Settings icon in the far left navigation pane.

The Script ID can be found under the IDs section, to the right of Script ID.

As you can see, the Google Apps Script editor is fairly straightforward if you know how to navigate to each feature you want to use. Just make sure to study Google’s Apps Script documentation well so that you can start learning how to write your scripts and all functions that are available to use.

Related posts

• Sida Apps-ka Tijaabada Google ay kuugu caawin karaan La-dagaalanka Maandooriyaha Dijital ah

• 5-ta Apps ee ugu Fiican ee Shaandhaynta Iftiin Buluugga ah ee loogu talagalay Windows, Mac iyo Linux

• 5 Apps oo la qaadi karo oo aad rabto in aad ku haysato USB stick

• Buuxinta otomaatiga ah ee Google Chrome: Hage Dhamaystiran

• 4-ka ugu Wacan ee Soo Gudbinta Barnaamijyada Software-ka iyo Sida Loo Isticmaalo

• Sida App-ka Desktop-ka ee Signal-ka uu uga caawin karo Ilaalinta Qarsoonnimadaada

• Waxyaabaha ay tahay inaad tixgeliso ka hor intaadan abuurin Wiki adiga kuu gaar ah

• 7-da Aaladaha ugu Fiican ee ka saarida Bloatware ee Daaqadaha

• Kordhinta Amniga ee Avast Online: Ma mudan tahay in la isticmaalo?

• Sida loo Isticmaalo Maamulaha Xidhmada Windows si loo rakibo Barnaamijyada Windows

• Sida loo hubiyo in heerkulka CPU-gaagu uu aad u sarreeyo

• Isticmaal Camer Shabakad duug ah si aad ula socoto hantidaada lacag la'aan

• Sawirka Google: Hagaha Buuxa ee Bilawga

• 5-ta Aaladaha ugu Fiican ee iskaanka IP-ga ee Windows, Mac, iOS, iyo Android

• 4-ta Apps ee Xisbiga Saddexaad ee ugu Fiican Windows 10 Waa inaad Hadda Ku rakibtaa

• Turjumaada Google iyo Turjumaada Bing - Keebaa Wanaagsan?

• 5 Barnaamijyada Software-ka ugu Wanaagsan ee lagu Maamulo Labada Kormeere

• 4 Qalab Wanaagsan oo lagu Abuurayo Xirmooyinka Rakibayaasha Windows

• Isku-darka ugu Wanaagsan ee lagu Kordhiyo Google Office Suite-kaaga

• Tifaftirayaasha Markdown-ka ugu Fiican: Dhammaan Platforms iyo Online