Sida Loo Sameeyo Foomamka Google-ka si otomaatig ah loogu Shacbiyo oo leh AI Soo koobidda

Ururinta iyo falanqaynta talooyinka macaamiisha ayaa lama huraan u ah koritaanka. leh Goobta Shaqada Google, Foomamka Google wuxuu bixiyaa hab aan toos ahayn oo lagu soo qabto jawaabaha oo si toos ah loogu soo geliyo Google Sheets, halkaas oo AI si toos ah u soo saari karto koobab.

Isku dhafkan ayaa xogta cayriinka ah u beddela aragtiyo la hirgelin karo oo leh dadaal yar. Laakin waa maxay sababta habaynkan u yahay beddelka ciyaarta marka la barbar dhigo beddelka? Sideese ganacsiyada suuq-geyntu iyo wax-iibsiintu uga faa'iidaysan karaan? Aan kala jebinno.

Waa maxay sababta tani ay ugu khiyaanaynayso Platformyada kale

Aaladaha sida Typeform, SurveyMonkey, ama Jotform aad ayey ugu fiican yihiin naqshadeynta qaabka isticmaale-saaxiibtinimo, laakiin ku-daridda xaashida faafinta iyo soo koobidda AI waxay inta badan dareemaa inay xalinayaan halxiraalaha qaybo maqan. Waa tan sababta:

• Is-dhexgalka JajabanDhoofinta jawaabaha xaashida xaashida sida caadiga ah waxay u baahan tahay isticmaalka adeegyada dhinac saddexaad ee lacagta lagu bixiyo, sida Zapier or samee. Kuwani waxay ku daraan kharashyada iyo dejinta kakanaanta, oo leh dib u dhac ku iman kara isku xidhka xogta.
• Dhaladka AI xaddidan: Iyadoo meelaha qaar ay bixiyaan falanqayn aasaasi ah, soo koobid sax ah oo AI ay wado - fikrado macne ah oo laga helay jawaabaha dhamaadka-dhamaadka ah - waa naadir iyada oo aan lahayn koodh khaas ah ama wax-ku-kordhin qaali ah. Tusaale ahaan, astaamaha SurveyMonkey's AI waxay ka dambeeyaan heerar sare oo ha ku riixin xaashida faafinta.
• Caqabadaha Miisaanka: Xakamaynta jawaabaha mugga sare waxay keeni kartaa API xad ama dhoofinta gacanta, samaynta falanqaynta wakhtiga dhabta ah hawl adag. Taas bedelkeeda, nidaamka deegaanka Google waa u bilaash astaamaha aasaasiga ah, miisaan la'aanta, oo Gemini AI si toos ah ugu dhejiya foomamka iyo xaashida si deg deg ah, shaqeyn la'aan kood.

Habkan hooyo ee Google-ku wuxuu badbaadiyaa wakhtiga, yareeyaa khaladaadka, wuxuuna wax walba ku hayaa hal meel oo ammaan ah, meel wada shaqayn ah- oo ku habboon kooxuhu inay isku rogaan qalabyo badan.

Suuqgeynta iyo Iibka Kiisaska Isticmaalka

Kooxaha suuq-geynta, habayntani waxay u beddeshaa sahaminta macaamiisha oo u beddela ilo dahab ah oo aragtiyo ah. Bal qiyaas in aad wado foomka jawaab celinta ololaha kadib: Jawaabaha si toos ah ugu qulqula xaashida, halkaas oo AI ay ku soo koobto dareenka, sida 80% waxa ay amaaneen kaftanka xayaysiiska balse waxa ay calameen wakhtiyada xayaysiiska aayar. Suuqgeeyayaashu waxay si dhakhso ah u qiyaasi karaan xeeladaha nuxurka iyaga oo aan kala shaandheyn boqolaal faallooyin ah.

Iibka, waa awooda jiilka hogaanka. Foomka xiriirka ee goobtaada ayaa qabta faahfaahinta rajada iyo dhibcooyinka xanuunka. AI ka dib si toos ah ayay u kala saaraysaa (tusaale, Codsiga demo ujeedo sare leh) ama ay soo koobaan baahidooda (Rajada laga qabo inay ka niyad jabto qiimihii tartame — soo jeedi qiimo dhimis xidhmo). Iibka iibku wuxuu helayaa muuqaal u diyaarsan in la isticmaalo, kaas oo kor u qaada qiimaha dhow iyadoo la kala hormarinayo hogaanka kulul. Ganacsiyada yaryar waxay la socon karaan ROI shabakadaha internetka, halka shirkaduhu ay falanqeeyaan jawaab celinta caalamiga ah ee wacyigelinta shakhsi ahaaneed - dhammaan iyada oo aan la gelin xogta gacanta.

Natiijadu? Go'aan-qaadasho degdeg ah, ka-qaybgal sare, iyo kobaca xogta ay waddo, iyadoo AI ay gacanta ku hayso qaadista culus.

Tillaabo-Tallaabo Tilmaame: Dejinta

Diyaar ma u tahay in la dhiso? Habkani wuxuu qaadanayaa wax ka yar 10 daqiiqo wuxuuna u baahan yahay akoon Google (Astaamaha Gemini waxay u baahan yihiin qorshe goob shaqo, sida Heerka Ganacsiga, ama Gemini add-on). Waxaanu samayn doonaa foom, waxaanu ku xidhi doonaa Xaashiyaha, oo aanu ku dari doonaa goob soo koobida AI.

Tallaabada 1: Samee Foomka Google-kaaga

1. Tag Foomamka Google oo guji "+" si aad u bilowdo foom maran.
2. Ku dar su'aalahaaga: Ku dar ugu yaraan hal nooc oo furan (jawaab gaaban ama cutubka) AI si loo soo koobo - tusaale, "Maxaad ka heshay wax soo saarkayada?"
3. Habbee sida loogu baahdo: Ku dar cinwaan, sharraxaad, iyo dejin jawaab celin (tusaale, xaddid hal isticmaale kasta).
4. Fiiri oo tijaabi: Guji astaanta isha si aad u hubiso inay si fiican u socoto.

Talada Pro: IHaddii aad ku jirto Shaybaarka Goobta Shaqada, isticmaal Gemini's Iga caawi inaan abuuro si aad foomka uga diyaariso degdeg ah sida Sahan-celinta macaamiisha ee aaladda SaaS.

Tallaabada 2: Ku xidh Jawaabaha Xaashida Google

1. Foomkaaga, dhagsii Jawaabaha tab dusheeda.
2. Guji astaanta xaashiyaha cagaaran (ama Wax badan > Dooro meesha jawaabaha laga helayo).
3. Dooro Samee xaashi cusub (ama dooro mid jira).
4. Riix Abuur. Jawaabaha ayaa hadda si toos ah u daabici doona tabo cusub oo xaashida ah, oo leh shaambad waqtiyo iyo jawaabo ku jira tiirar.

Habayntan ayaa hubisa in soo gudbin kasta ay cusboonaysiiso xaashida wakhtiga-dhabta ah—wax dhoofin ah looma baahna.

Talaabada 3: Kudar Goob Soo koobida AI ee xaashida

1. Fur xaashida ku xidhan (waxay ka muuqan doontaa Drive kaaga).
2. Tiirka cusub (tusaale, tiirka F, ee ku suntan "Koobi"), dooro xogta safka hore (tusaale, Safka 2).
3. Geli qaacidada AI: =AI("Summarize the key feedback from this response in one sentence, highlighting sentiment.", A2:M2)

• Bedel A2:M2 oo leh kala duwanaanshaha jawaabtaada (tusaale, shaabada wakhtiga, magaca, tiirarka jawaab celinta).
• Habbee degdega: Si aad u heshid iibka, isku day =AI("Categorize this inquiry as 'hot lead', 'warm', or 'cold', and summarize needs.", C2:D2).

1. Riix Gelida Gemini ayaa isla markaaba soo koobaysa.
2. Hoos u jiid caanaha si aad ugu dabaqdo dhammaan safafka. Jawaabaha cusub, si otomaatig ah ayey u buuxisaa.

Dib u cusboonaysii wax soo saarka haddii xogtu is beddesho adiga oo dooranaya unugyada oo gujinaya "Refresh and Geli." Haddii aad hayso 3-200 jawaabo, waxa kale oo aad si toos ah u soo saari kartaa koobab badan oo foomamka jawaabaha tab si aad u aragto dulmar degdeg ah, ka dibna koobi ku dheji xaashida haddii loo baahdo.

Dhiciyaan

• Shuruudaha HubintaHubi in qorshahaaga Workspace uu taageerayo Gemini (tusaale, Business Standard+). Isticmaalayaasha bilaashka ah waxay helayaan foomamka/ xaashiyaha aasaasiga ah, laakiin leh awood xaddidan oo AI ah.
• Qarsoodi HoreFoomamka ixtiraamka habaynta wadaagga - wada-hawlgalayaashu sidoo kale waxay arkaan xaashida, markaa ku maamul gelitaanka Drive-ka.
• Hormarsan Tweaks: Wixii ku cusub cusboonaysiinta firfircoon, isticmaal Apps Script si aad u kiciso soo koobida soo gudbinta, ama la isku daro jaantusyada xaashida ee dashboards muuqaal ah.
• Dhibaatooyinka: Haddii AI uusan muuqan, hubi luqadaada (Ingiriisi-kaliya hadda) ama goobaha maamulka.

Socodkan shaqo, Foomka Google wuxuu noqonayaa matoorka xogta smart. Ku bilow wax yar foom jawaab celin ah, cabir sahanka ganacsiga, oo fiirso fikradaha ganacsigaaga oo kor u kacaya.

Gunnada: Ku dar Kiciyaha iimaylka ee rajada kulul

Waxaad ku dejisan kartaa kicinta iimaylka tooska ah ee Google Sheets marka soo koobida AI ay calaamadeyso hogaanka iibka sida kulul. Tani waxay ka faa'iidaysanaysaa Google Apps Script (qalab bilaash ah, aan code-saaxiibtinimo lahayn) si ay ula socdaan jawaabaha foomka cusub, qiimeeyaan soo koobida AI ay soo saartay, oo loogu diro iimaylka shakhsi ahaaneed ee Gmail. Waa hab awood leh oo lagu hubinayo in kooxdaada wax iibinta ay helaan ogeysiisyo degdeg ah, iyagoo u rogaya fikrado ficil ah iyada oo aan la hubin gacanta.

Tallaabada 1: Diyaarso Xaashidaada

1. Fur xaashida ku xidhan foomkaaga (laga bilaabo maqaalka Tallaabo 2).
2. Hubi inaad haysatid tiir "soo koobid AI" (tusaale, tiirka F) oo leh qaacidada sida =AI ("Kan u kala saar 'lead kulul', 'diir', ama 'qabow' ku salaysan degdegga iyo baahiyaha.", C2:D2).
3. Ku dar laba tiir oo cusub oo raadraaca:
   • Tiirka G: "Email Loo Diray" (formula: =IF(F2="lead hot", "Haa", "Maya")—hoos u jiid).
   • Tiirka H: "Email Timestamp" (si toos ah ayaa loogu daabici doonaa qoraalka).

Tallaabada 2: Fur Script Apps

1. Xaashidaada, u tag Kordhinta> Qoraalka Apps. Tani waxay ku furaysaa tifaftiraha qoraalka tab cusub.
2. Tirtir kood kasta, oo ku dheji qoraalka hoose (ku beddel sida lagu xusay).

Tallaabada 3: Qor oo Keydi Qoraalka

Halkan waxaa ah qoraal fudud oo diyaar u ah in la isticmaalo. Waxay hubineysaa haddii soo koobidda AI ay ka kooban tahay "lead kulul," ka dib waxay u dirtaa iimayl sanduuqa la wadaago kooxdaada iibka (ama wakiil gaar ah).

function onFormSubmit(e) {
  var sheet = e.source.getActiveSheet();
  var row = e.range.getRow();  // The row with the new response
  var aiSummary = sheet.getRange(row, 6).getValue();  // Assuming Column F (6) is AI Summary
  
  if (aiSummary && aiSummary.toString().toLowerCase().includes('hot lead')) {
    var emailData = sheet.getRange(row, 1, 1, 8).getValues()[0];  // Grab row data (adjust columns as needed)
    var prospectEmail = emailData[2];  // e.g., Column C for prospect's email
    var prospectName = emailData[1];   // e.g., Column B for name
    var feedback = emailData[3];       // e.g., Column D for key feedback
    
    // Customize email details
    var subject = `Hot Lead Alert: ${prospectName} Needs Immediate Follow-Up`;
    var body = `
      Hi Sales Team,
      
      New hot lead from form: ${prospectName} (${prospectEmail}).
      
      Key Insights from AI: ${aiSummary}
      Original Feedback: ${feedback}
      
      Action: Reply ASAP with a personalized demo offer.
      
      Full Response Link: ${sheet.getUrl()} (Row ${row})
      
      Best,
      Auto-Lead Bot
    `;
    
    // Send to your team's email (or dynamically assign based on territory)
    GmailApp.sendEmail('sales@yourcompany.com', subject, body);
    
    // Update tracking columns
    sheet.getRange(row, 7).setValue('Yes');  // Column G: Email Sent
    sheet.getRange(row, 8).setValue(new Date());  // Column H: Timestamp
  }
}

• Nidaamyada:
  • Hagaajin tirooyinka tiirka (tusaale, getRange( saf, 6) ee F).
  • Beddel emaylka qaataha ama kudar CC-yada: GmailApp.sendEmail('sales@yourcompany.com', mawduuca, jidhka, {cc: 'manager@yourcompany.com'});.
  • Wacyigelinta mustaqbalka: Ku beddel qaataha email-ka-soo-jeedinta oo ku beddel jidhka farriin soo dhawayn ah.
  • Ku xooji degdegga AI ee qaacidada Xaashida si loo kala saaro si wanaagsan (tusaale, ku dar "haddii la sheego" degdeg ah" ama 'demo hadda'").

3. Guji summada diskka si aad u Save (magac mashruucaaga, tusaale ahaan, "Iimayl Kicinta Lead Kulul").
4. Ogolaanshaha deeqda: Ku socodsii shaqada hal mar si gacanta ah (ka dooro FormSubmit ee hoos u dhaca oo guji Run). Ansixi meelaha Gmail/Sheets marka laguu sheego.

Talaabada 4: Deji kicinta

1. Qoraalka Apps, dhagsii sumadda saacada (Kiciyaasha) bidixda.
2. Riix + Ku dar Kiciye (midig hoose).
3. habeyn:
   • Shaqada: onFormSubmit
   • Hawlgelinta: Madax
   • Isha dhacdada: Laga soo bilaabo xaashida xaashida
   • Nooca dhacdada: Ku soo gudbi foomka
4. Riix Save. Oggolow haddii loo baahdo.

Tallaabada 5: Tijaabi

1. Ku soo gudbi jawaabta tijaabada foomkaaga (tusaale, shay degdeg ah sida "U baahan demo maanta-qalabka hadda aad ayuu u gaabiyaa!").
2. Fiiri xaashida: AI waa inay u calaamadisaa "lead kulul," iimaylkana waa inuu ku yimaadaa ilbiriqsiyo gudahood.
3. La soco diiwaanka fulinta qoraalka (kujira Apps Script> fulinta) wixii khalad ah.

Talooyinka Pro iyo Cilad-raadinta

• Xadka Xadka: Gmail waxa uu xidhaa 100–1,500 iimaylo/maalintii (ku salaysan qorshahaaga Workspace) — badana kooxaha intooda badan.
• AmmaankaQoraallada waxay ku hoos shaqeeyaan akoonkaaga, markaa isticmaal mid la wadaagoalerts@yourcompany.com” diritaanka.
• Fikrado SareKu dhex biir Google Calendar si toos ah jadwalka wicitaanada, ama Slack adoo adeegsanaya webhook ogeysiisyada kooxda. Hogaamiyeyaasha aan kululayn, ku dar maangal shuruudaysan si aad ugu kobciso iimaylada dhibban.
• Hadii ay jabto: Arrimaha guud? Hubi tusmooyinka tiirka ama hubi in xaashida aan la shaandhayn. Ka saar adiga oo ku daraya Logger.log(aiSummary); ku qor qoraalka iyo daawashada.

Habayntani waxay foomkaaga u beddeshaa mishiin wax iibin ah oo firfircoon. Ku cabbir foomamka kala duwan (tusaale, mid demos, mid tigidhada taageerada), oo waxaad arki doontaa wiishka beddelka wakhti aan dheerayn. Haddii aad ku dhufato snags, Google's Scripts Scripts ama golayaasha bulshada Workspace waxay leeyihiin tusaalayaal wanaagsan. Waa maxay kiiskaaga ugu horreeya ee isticmaalka?

Related Martech Zone Content

Xaashiyaha Google: Iibka Iskaashatada iyo Xaashiyaha Suuq-geynta oo leh Xog-Waqti-Dhaqan Isku-dhafan

Sida Looga Haajiro Dhacdooyinka Dabagalka Caalamiga ah Loona Guuro Google Analytics 4

Laga soo bilaabo Hogaamiyaasha ilaa Iibka: Xidhmada Martech Ugu Yar ee Suuqgeynta Ganacsiga Yaryar iyo Kobaca

Botsheets: ku tababar Chatbot oo ku qabso hogaanka xaashida Google-ka ee aan lahayn code GPT