Sida Loo Xidho Google Sheets App-ka

Si aad Google Sheets ugu xidho app-kaaga, awood u yeelo Google Sheets API mashruuc Google Cloud gudihiisa, samee service account, la wadaag spreadsheet-ka email-ka service account-ka, oo furahiisa u kaydi secret server-ka. Kadibna server-kaagu wuxuu akhrinayaa safafka spreadsheets.values.get oo wuxuu ku daraa safaf cusub spreadsheets.values.append. Haddii isticmaalayaashu u baahan yihiin inay ku xidhaan sheet-kooda gaarka ah, isticmaal OAuth halkaas, haddii sheet-ku buuxa uu dadweyne yahay, API key fudud ayaa ku filan akhriska.

Hagahan wuxuu daboolayaa habka ku habboon, wicitaannada aad u baahan tahay, quotas-ka iyo khaladaadka la yaabka leh, iyo prompts-ka dhismaha AI app. Faahfaahinta Google waxay ka timid dukumentiyada horumariyaha Google ee Sebtember 2026.

Sababta loo xidho sheet

Sababaha caadiga ah:

• Ilaali habka shaqada kooxda. Shaqaalaha ayaa sii tafatiraya liiska qiimaha ama jadwalka Sheets; app-ku wuu muujiyaa.
• Ururi xogta meesha dadku horay u eegaan. Diiwaan-gelinta cusub, dalabyada ama jawaabaha foomka waxay ku soo dhacaan safaf.
• Warbixinno. Ka dhoofi xogta app-ka sheet-ka dadka ku nool spreadsheet-yada.
• Tallaabo dhex-marka. Ka bilow sheet-ka, kadibna u guuro xogta-saldhig dhab ah. Eeg sida spreadsheet loo beddelo app.

Dooro habka app-kaagu ku galo Google

Hagaha aqoonsiga Google wuxuu sharraxayaa saddex nooc:

Apps badanaa, service account ayaa xulashada saxda ah: hal qaybo aqoonsi ah, oo adiga leh, oo keliya sheets-ka aad si cad ula wadaagto.

Tallaabo-tallaabo service account-ka

1. Samee ama dooro mashruuc Google Cloud oo awood u yeelo Google Sheets API.
2. Samee service account iyo furaha ka. Furuhu waa fayl JSON ah; u dhaqan sida password.
3. La wadaag spreadsheet-ka email-ka service account-ka, sida Viewer akhris oo keliya, ama Editor si aad u qorto. Hagaha Google wuxuu sheegayaa in lagu sameeyo shaashadda wadaagista ee caadiga ah.
4. Furaha u kaydi secret ahaan server-kaaga, tusaale ahaan GOOGLE_SERVICE_ACCOUNT_JSON, iyo spreadsheet ID-ga (xarfaha dheer ee ku jira URL-ka sheet-ka) sida SHEET_ID.
5. Wici API-ga server-ka adoo isticmaalaya maktabadda client ee Google ee luqaddaada.
6. Akhrinta kaydi haddii booqdayaal badan ay isla xogta arkayaan, si aadan u gaarin quota-ka.

Wicitaannada aad isticmaali doonto

Hagaha Google ee akhrinta iyo qorista qiimayaasha:

Ranges-ku waxay isticmaalaan A1 notation. Google waxay xusaysaa in range aan magac sheet lahayn, sida A1:B2, uu u shaqeeyo sheet-ka ugu horreeya, sidaas darteed magaca tab-ka si cad u qor si aad uga fogaato wax la yaab leh markii qof dalabyada dib u habeeyo.

RAW vs USER_ENTERED

Qorista waxay u baahan tahay valueInputOption:

• RAW wuxuu kaydiyaa wixii aad dirtay si siman, qoraal ahaan. =1+2 wuxuu kaydiyaa qoraalka =1+2.
• USER_ENTERED wuxuu u dhaqmaa sida si gacanta loo qoray Sheets-ka: taariikhaha waxay noqdaan taariikh, =1+2 wuxuu noqdaa formula.

Haddii aad qorto qoraal uu isticmaalaha ku qoray app-kaaga, isticmaal RAW. USER_ENTERED-ka, qof ayaa formula soo gudbin kara oo ay shaqaysaa markii asxaabtiisa sheet-ka furaan.

Quotas iyo khaladaadka

Laga bilaabo Sebtember 2026, bogga xaddidaadka Google Sheets API wuxuu liisteysaa:

Ma jiro xad maalinle ah inta aad ku sii jirto xadadka daqiiqadda. Haddii la dhaafo waxay soo celinaysaa 429: Too many requests, Google waxay talinaysaa exponential backoff oo kooban: sug wakhti dheer kadib isku day kasta oo fashilmay, oo leh dib-u-dhac random ah, ilaa xad. Codsi keli ah oo qaadanaya in ka badan 180 ilbiriqsi wuu timeout-ka.

Dhab ahaan: ha wicin API-ga bogag kasta oo la arko. Xogta sheet-ka ku kaydi ugu yaraan daqiiqad, akhriska ku isugu geyn batchGet, qorista meel kasta oo ay suurtagal tahay ku isugu geyn.

Doorashooyinka iyo isdhexgal-ka

Wax kasta oo isticmaalayaal badan ama xog xasaasi ah leh, xogta-saldhigga ayaa ah il runta ugu fiican. Eeg waa maxay xogta-saldhigga.

Prompts-ka aad siinayso AI builder-kaaga

Akhrinta sheet:

Muuji tab-ka “Menu” ee Google Sheet-keenna bogga menu-ga. Isticmaal Google Sheets API server-ka adoo isticmaalaya service account kaas oo JSON key-geedu ku jiro secret-ka GOOGLE_SERVICE_ACCOUNT_JSON, iyo spreadsheet ID-ga ku jira SHEET_ID. Akhri range-ka Menu!A2:D (magac, sharaxaad, qiimo, qayb). Natiijada 5 daqiiqo ku kaydi. Haddii API-gu fashilmo, muuji nooca ugu dambeeyay ee kaydsan. Ha u dirin furaha browser-ka abid.

Qorista safafka:

Marka qof foomka xiriirka soo gudbiyo, ku kaydi xogta-saldhigga, oo sidoo kale ku dar safaf tab-ka “Leads” (taariikh, magac, email, fariin) adoo isticmaalaya spreadsheets.values.append oo valueInputOption RAW ah. Haddii Google soo celiso 429, dib isku day backoff exponential ah; haddii weli fashilmo, hogaamiye hoggaanka xogta-saldhigga oo dib u isku day mar dambe.

Khaladaadka caadiga ah

• Illoobida in sheet-ka la wadaago email-ka service account-ka. API-gu markaas wuxuu soo celinayaa khalad ogolaansho inkastoo furuhu sax yahay.
• Furaha frontend-ka ama repository-ga. JSON key-gu wuxuu siiyaa gelitaan ku sheets kasta oo la wadaago. Eeg sida API keys-ka loo ilaaliyo.
• Isticmaalka USER_ENTERED xogta isticmaalaha, taas oo ogolaata formula injection.
• Wicitaanka API-ga codsi kasta iyo gaarista quota-ka daqiiqadda marka ugu horreysa ee taraafiga kor u kaco.
• Ku tiirsanaanta booska tiirarka. Qof tiir buu geliyaa app-kuna wuxuu akhrin xogta qaldan. Akhri safka madaxa oo ku khariid magac, ama qufac madaxa.
• Sheet-ka oo ka badan sida loo baahan yahay loo wadaago. “Qof kasta oo haysta link-ga” wuxuu ka dhigaa mid dadweyne.
• Sheet-ka oo loo isticmaalo xogta-saldhig isticmaale badan. Qorista isku mar iyo ogolaansho la’aanta waxay keenaan xog lumay ama xog la daadiyey.

Liiska hubinta

• Sheets API waa la furay; service account waa la sameeyey
• Sheet-ka waa la wadaagay email-ka service account-ka oo doorka ugu hooseeya loo baahan yahay
• Furaha iyo sheet ID-ga waa lagu kaydiyay secret-ka server-ka
• Dhammaan wicitaannada waxa laga sameeyaa server-ka
• Magacyada tab-ka waa la isticmaalay range-yada
• RAW waa loo isticmaalaa qoraalka uu isticmaaluhu bixiyay
• Akhrinta waa la kaydiyay; 429 waa lagu maamulay backoff
• App-ku wuu si fiican u shaqeeyaa haddii Sheets aysan diyaar ahayn
• Waa lagu go’aamiyay dhinaca ah il runta

Google Sheets Mythex-ka

Mythex waxay leedahay laba siyaabood oo kala duwan oo lagu shaqeeyo Sheets. Connectors waxay account-ka Google-kaaga ku xidhaan Mythex si wakiilku u isticmaali karo intaad dhisayso, tusaale ahaan akhrinta sheet si loogu dhiso dashboard ka xogtaas; dukumentiyadu waxay sheegayaan in akhriska uu ku sii jiro adeega xiriirka Mythex mana gaadhayo koodkaaga (eeg Connectors, oo ogolaanshaha kasta oo Google weydiisto ansixi). Si app-ka la daabacay uu u akhriyo ama u qoro sheet isagoon caawimo lahayn, habka la isku halayn karo waa kan hagahan ku jira: service account key oo loo kaydiyay secret mashruuc ahaan iyo wicitaanno Sheets API ah server-kaaga, sida ku jirta Integrate any API. Haddii aad ka baxayso sheet-ka, wakiilka weydii inuu xogta u wareejiyo xogta-saldhigga mashruuca oo uu ku dhiso dashboard isaga dul-saaran.

Su'aalaha