Google Sheets

A1Connection architecture

The connection uses OAuth 2.0 against the vendor's own consent screen. The authorisation request names the minimum scopes the features need — the exact scope list is shown in the security-flow panel below, pulled from the same provider registry the application uses. The code-for-token exchange happens entirely server-side (aqoonsiga macaamiisha ee jirka codsiga token-ka, per the vendor's token endpoint contract); tokens are stored encrypted at rest and are never rendered back to any screen — connection pages show presence, not values.

Nolosha calaamadda (token) waxaa lagu maareeyaa hal meel oo keliya: dhicitaanku wuxuu kiciyaa dib-u-cusbooneysiin toos ah, calaamadaha dib-u-cusbooneysiinta ee la beddelay waa la kaydiyaa, iyo dib-u-cusbooneysiin uu iibiyuhu diido waxay soo saartaa digniin dib-u-xirid ah oo muuqata — marna ma noqoto astaamo si aamusan u jabay. Burintu waxay ka shaqeysaa labada dhinac: ka joi halkan, ama ka buri goobaha amniga ee iibiyaha.

A2Qor semantics iyo socodka xogta

Dhaqdhaqaaq kasta oo xog ah waa ficil cad oo leh natiijo la diiwaangeliyay. Qoraalladu waxay dhacaan gujintaada — ama si otomaatig ah kaliya halkaas oo aad ka awoodsiisay xeer (riixid otomaatig ah oo ku saabsan shaqaalaynta waa dansan yahay, halkii bixiye). Akhrinta — soo dejinta dadka, akoonnada, ama faylalka — waxay socdaan marka aad riixdo Import, deduplicate ka dhanka ah waxa aad horey u haysatay (macmiilka magaca, dadka iimaylka), ka bood halkii aad ka qori lahayd, oo u sheeg abuurista-ka dhanka ah-la booday si daacad ah, taas oo ah sababta dib-u-socodsiinta soo dejin kasta ay u tahay badbaado naqshad ahaan.

Tallaabo kastaa waxay u qortaa saf joornaalka hawlqabadka barnaamijka (ats_app_activity): waxa socday, goorta, diiwaanka, iyo natiijada — oo ay ku jirto qoraalka qaladka ee iibiyaha laftiisa marka wax guuldareystaan. Warbixinta isticmaalka ee gudaha ATS waxay isku geysaa isla joornaalkaas, markaa warbixinta isku-xirka iyo xaqiiqda isku-xirka ma kala duwanaan karaan.

Wax kasta oo ka baxaya dariiqa codsiga — ogeysiinta fan-out, gaarsiinta webhook, joornaalka hawsha, boostada — waxay ku socdaan dunta asalka ah ee dab-iyo-hilmaam. Barta dibadda ee gaabis ah marnaba kama dhigi karto interface-ka inuu sudho, iyo saameyn dhinaca ah oo fashilantay ayaa la diiwaangeliyaa halkii si aamusnaan ah loogu celin lahaa iyada oo aan joogto ahayn.

A3Tixgelinta hawlgalka

Isku-xirku waa heer-urur waxaana lagu xaddiday milkiilaha iyo doorarka maamulka; shaqaaleeyayaashu waxay isticmaalaan astaamaha isku-xirka awoodda laakiin ma xiriirin karaan, ma goyn karaan, ama ma habayn karaan. Goynta waxay meesha ka saartaa aqoonsiga la kaydiyay isla markiiba waxayna joojisaa astaamaha ku tiirsan si muuqata, maaha aamusnaan. Xogta horey loo soo dejiyay waxay ahaanaysaa mid adiga kuu gaar ah oo la tafatiri karo.

Dadka la soo dejiyay waxay yimaadaan iyagoo lagu calaamadeeyay la soo dejiyay oo leh caadooyin gaar ah oo muxaafid ah — ma jiro oggolaansho loo malaynayo qof kasta oo aan waligiis buuxin foomka codsigaaga, iyo caadooyinka kaydinta ayaa khuseeya.Wax kasta oo la qoray waa adiga inaad qaadato: dhoofinta CSV iyo barnaamijka Data Export waxay daboolayaan isla dukaamada badeecada lafteeda ay akhrido. Ka bixitaanku waa mid furan sida gelitaanka — naqshad ahaan, ma ahan tanaasul.

A4Lacagaha xad-dhaafka ah — waxa dhacaya, doollar ahaan, xilliga aad u baahato hal kursi oo kale ama hal boos oo shaqo oo furan oo ka badan inta qorshahaagu oggol yahay. Iibiyayaal qaar ayaa si otomaatig ah kuugu kor marinaya heerka xiga; kuwa kalena waxay ku qaadaan qiimaha xad-dhaafka ah ee unug kasta kaas oo ka adag inta aad iibsan lahayd heerka xiga si toos ah.

Is-dhexgalkani waa mid nool diiwaanka maanta. One connection per provider unlocks every feature it powers, and the topology grid below shows the neighbouring connectors in the same capability area — statuses come from the same registry that drives the in-app hub, so this page can never claim more than the product does. For anything the catalogue does not cover, Webhooks and Zapier are the generic, documented escape hatch.