Iyini i-Google Apps Script nokuthi ungazuza kanjani ngokugcwele kuyo

Informatec Digital » Software » Iyini i-Google Apps Script nokuthi ungazuza kanjani ngokugcwele kuyo

Ukuzenzakalela komsebenzi kuyisisekelo sokusebenza kahle kwesimanje kunoma iyiphi indawo yedijithali , ikakhulukazi ngaphakathi kwamathuluzi okubambisana njenge-Google Workspace. Ukuze kuhlangatshezwane nalesi sidingo, i-Google ithuthukise ipulatifomu esebenza kahle kakhulu: i-Google Apps Script.

Uma uphatha amaphrojekthi, usebenza ngedatha, noma usebenzisa nje izinsizakalo ze-Google nsuku zonke , leli thuluzi lingaba umsizi obalulekile wokonga isikhathi , ukuthuthukisa izinqubo, nokwakha izixazululo ezenziwe ngokwezifiso ngaphandle kwesidingo sengqalasizinda eyinkimbinkimbi.

Iyini ngempela i-Google Apps Script?

I-Google Apps Script iyipulatifomu yokuthuthukiswa esekelwe efwini ekuvumela ukuthi udale izikripthi ze-JavaScript ezenzelwe ukusebenzisana nokwandisa ukusebenza kwezinhlelo zokusebenza ngaphakathi kwe-Google Workspace (njenge-Gmail, i-Google Sheets, noma i-Drive). Ngaleli thuluzi, ungenza imisebenzi ejwayelekile ibe ngokuzenzakalelayo , uxhume izinsizakalo eziningi, futhi uthuthukise nezinhlelo zokusebenza zewebhu ezenziwe ngokwezifiso.

Ngaphezu nje kolimi lokubhala , kuyindawo yokuthuthukisa lapho ikhodi yakho isebenza ngqo kumaseva e-Google, okusho ukuthi awudingi ukusetha noma ukugcina eyakho. Lokhu kwenza kube lula kakhulu ngabathuthukisi abangebona ochwepheshe ukuthi bamukele. Ngaphezu kwalokho, uma ungathanda ukufunda okwengeziwe, ungahlola izindlela ezahlukene zokwenza ngokuzenzakalela kwenqubo.

I-Apps Script isebenzisa inguqulo ye-JavaScript enezici ezithile futhi iza nemitapo yolwazi yangaphakathi evumela ukuxhumana kwasendaweni kumasevisi afana ne-Gmail, Ikhalenda, Idrayivu, Amadokhumenti noma Amashidi , kanye nokuhlanganiswa nama-API angaphandle nge-HTTP noma i-JDBC.

Izinzuzo eziyinhloko ze-Google Apps Script

Kunezizathu eziningi zokuthi uqale ukusebenzisa i-Google Apps Script, kodwa nazi ezinye eziphawuleka kakhulu:

• Akukho ukufakwa okudingekayo: : yonke into ihlelwa kusukela kusiphequluli. Umhleli wekhodi uhlanganiswe ngokuqondile ku-Google Drayivu.
• Ngokusekelwe ku-JavaScript: Uma unolwazi oluncane lokuthuthukiswa kwewebhu, uzokwazi ukufunda futhi udale imibhalo yakho yokuqala ngaphandle kwezinkinga.
• Izinga eliphezulu lokuhlanganisa: Ungaxhuma amathuluzi ahlukahlukene e-Google kanye nezinsizakalo zezinkampani zangaphandle, konke kusuka kusikripthi esisodwa.
• Ukusingathwa kwamafu kwamahhala: : Imibhalo isebenza eziphakelini ze-Google, ngakho-ke akumele ukhathazeke ngokulungiswa.
• Ukwenza ngokwezifiso okugcwele: Ungakwazi ukuhlela izici ze-Google Workspace ngendlela efanele izidingo ezithile zenkampani noma zethimba lakho.

Yini ongayenza nge-Google Apps Script?

Leli thuluzi liguquguquka kakhulu kangangokuthi cishe noma yimuphi umsebenzi ophindaphindwayo noma inqubo yomshini ingenziwa ngokuzenzakalela . Isibonelo:

• Thumela ama-imeyili ngokuzenzakalelayo lapho uthola izimpendulo ezintsha ku-Google Amafomu.
• Khipha ulwazi kuma-spreadsheet amaningi bese uyihlanganisa ibe isifinyezo sansuku zonke.
• Dala imibiko ye-PDF ngedatha yesikhathi sangempela futhi uyithumele ngokuzenzakalelayo masonto onke.
• Buyekeza amakhalenda futhi ushejule ama-aphoyintimenti Ivimbela ngokuzenzakalela isikhathi ngokusekelwe kumashidi esikhathi.
• Yakha amamenyu wangokwezifiso kumaspredishithi anemisebenzi eqondene nebhizinisi lakho.

Ukwenza ngokwezifiso kungenye yamandla ayo amakhulu. Ngisho nemisebenzi elula njengokususa izinhlamvu ezingadingekile noma ukushintsha ukufometha kombhalo kumaseli kungenziwa ngokuzenzakalela ngokuchofoza okukodwa ngenxa ye-Apps Script. Uma ufuna ithuluzi elisebenzayo lokuzenzakalela, cabanga nangezixazululo ze-robotic process automation (RPA).

Amacala okusetshenziswa kwebhizinisi

Izinkampani eziningi ziphendukela ku-Apps Script njengesixazululo sokwenza izinto ngokuzenzakalela esinekhodi ephansi , okuzivumela ukuthi zithuthukise izinqubo zangaphakathi ngaphandle kokuthembela ngqo ku-IT. Ezinye izinhlelo zokusebenza zomhlaba wangempela zifaka:

• Amadeshibhodi okuhlaziya idatha okuzenzakalelayo ezibuyekezwa ku-Google Analytics, amanethiwekhi omphakathi noma izinkundla zangaphakathi.
• Ukuhlanganiswa nge-JDBC nesizindalwazi sebhizinisi ukungenisa/ukuthekelisa idatha esuka kumaspredishithi.
• Ukudala izinhlelo zokusebenza zewebhu ezilula usebenzisa i-HTML ne-JavaScript, ezisebenzisa idatha ye-Google Drayivu ngesikhathi sangempela.
• Ukukhiqizwa kwe-invoyisi okuzenzakalelayo kusuka kudatha efakwe kumafomu e-Google.

Ngenxa yobulula bayo kanye nokufinyeleleka kwayo, i-Google Apps Script ivumela ukuthuthukiswa kwezinhlelo zokusebenza ezincane zebhizinisi , okuvumela amaqembu angewona awezobuchwepheshe ukuthi adale izixazululo ezenzelwe ukuhamba kwawo kwansuku zonke. Ukuhlola ukuthi ubuchwepheshe bokuzenzakalela bushintsha kanjani embonini nakho kungaba yinto ethakazelisayo.

Ukuqalisa: Imisebenzi Yokuqala Isinyathelo Ngesinyathelo

Omunye wemisebenzi yokuqala ozoyibona lapho udala iskripthi esisha yi- "myFunction" . Leli gama elijwayelekile lingashintshwa kalula. Isibonelo:

function saludoPersonalizado() {
  Browser.msgBox("¡Hola a todos desde Apps Script!");
}

Lesi sici sizovula umlayezo we-pop-up onesibingelelo. Ungakwazi ukusengeza kuspredishithi futhi usenze sisebenze usebenzisa imenyu yangokwezifiso. Ukuze wenze lokhu, udinga nje ukufaka le khodi:

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Funciones personalizadas')
    .addItem('Mostrar saludo', 'saludoPersonalizado')
    .addToUi();
}

Futhi yilokho kuphela , uma uvula ishidi uzobona imenyu entsha enomsebenzi wakho ohlanganisiwe.

Ukuphepha nezimvume

Njalo uma usebenzisa iskripthi esifinyelela idatha yakho ye-Google , kufanele usigunyaze ngokucacile. Lesi sinyathelo siyimpoqo ukuqinisekisa ukuthi uyazi ngezimvume ozinikezayo. Nakuba kungase kubonakale kungalungi ekuqaleni, kuyingqimba ebalulekile yokuphepha evikela ubuqotho bamadokhumenti akho kanye ne-akhawunti yakho. Ukuze uthole ulwazi olwengeziwe mayelana nokuphatha ukuphepha kwalezi zikripthi, bheka lesi sihloko mayelana nemithwalo yemfanelo yomsizi wokuphatha osebenzayo.

Uma iskripthi singaqinisekiswanga, i-Google izokwazisa ngaphambi kokusisebenzisa. Lokhu kuvamile ngezikripthi ezenziwe ngokwezifiso, futhi ungamane ugunyaze ukwenziwa kwaso ngesandla. Uma sesigunyaziwe, iskripthi sizosebenza ngaphakathi komongo we-akhawunti yakho, sifinyelele kuphela lokho okuvumelayo.

Imikhawulo okufanele inakwe

I-Apps Script inendawo enamandla kakhulu, yize inemikhawulo ethile. Isikhathi sokusebenza ngeskripthi ngasinye sinqunyelwe , ngakho-ke izinhlelo zokusebenza ezisebenzisa izinsiza eziningi zingase ziphazanyiswe. Ngaphezu kwalokho:

• Imininingo egciniwe yangaphakathi engemuva kwama-firewall ayikwazi ukufinyelelwa ngokuqondile., ngaphandle uma imithetho ethile yenethiwekhi ihlelelwe yona.
• Imisebenzi yedethi nesikhathi ingase ithintwa ukweqa izindawo zesikhathi., ngakho-ke kunconywa ukuthi uqinisekise zonke izibalo zesikhathi.
• Amanye ama-API ezinkampani zangaphandle adinga ukuqinisekiswa okwengeziwe. noma amathokheni okufinyelela, okwenza ukuhlanganisa kube nzima nakakhulu uma ungenayo isipiliyoni sangaphambilini.

Kodwa-ke, ekusetshenzisweni okuvamile, le mikhawulo ayibeki izithiyo zangempela.

Ama-plugin athuthukile, ama-macros, namasevisi

Esinye sezici ezinamandla kakhulu ze-Google Apps Script ukudalwa kwama-add-ins. Ama-add-ins ayizinhlelo zokusebenza ezincane ezihlanganiswa ngqo ku-interface yamathuluzi afana nama-Docs, ama-Sheets, noma ama-Forms , okwandisa amakhono azo ngamamenyu, ama-sidebars, noma amabhokisi engxoxo. Ukuze uthole ulwazi oluphelele mayelana nendlela yokusebenzisa lezi zici, ungafunda kabanzi mayelana nokuthi ama-macro asebenza kanjani ku-Excel.

Lezi zengezo zingenziwa imali ngisho nasesitolo se-Google , yize zidinga ukudlula enkambisweni yokubuyekezwa yi-Google ukuqinisekisa ikhwalithi nokuphepha kwazo.

Ukwengeza, ungasebenzisa amamakhro (okurekhoda izenzo) ukuze ukhiqize ngokuzenzakalelayo ikhodi futhi uphinde usebenzise lokho okuzenzakalelayo kwamanye amashidi noma ukuhamba komsebenzi.

Futhi uma lokho bekunganele, ungasebenza nezinsizakalo ezithuthukisiwe njenge-Google Maps . Isibonelo, umsebenzi obala ibanga phakathi kwamakheli amabili:

function distanciaEntreDosPuntos(inicio, destino) {
  var direcciones = Maps.newDirectionFinder()
    .setOrigin(inicio)
    .setDestination(destino)
    .setMode(Maps.DirectionFinder.Mode.DRIVING)
    .getDirections();

  var ruta = direcciones.routes[0];
  return ruta.legs[0].distance.text;
}

Lezi zinhlobo zokusebenza zivumela abasebenzisi ukuthi bakhe amathuluzi okuhlaziya asendaweni ethile ngemigqa embalwa yekhodi.

I-Google Apps Script iyisisombululo esiguquguqukayo kakhulu kunoma yimuphi umsebenzisi osebenza njalo ne-Google Workspace . Inikezwa abasebenzisi be-Gmail mahhala, iyakwazi ukuzivumelanisa nezimo ezahlukahlukene ngaphakathi kwenhlangano. Uma ufuna ukwenza ngcono izinqubo, ukwenza imisebenzi yansuku zonke ibe ngokuzenzakalelayo, noma ukwenza ngokwezifiso ukuziphatha kwamathuluzi osuvele uwasebenzisa, i-Apps Script ingaba yisihluthulelo.