Fasahar Talla Nazari & Gwaji Content Marketing Filayen Bayanin Abokan Ciniki E-kasuwanci da Retail Email Marketing & Automation Kayan Kasuwanci Tallace-tallacen Neman Biya da Kwayoyin Halitta Koyarwar Tallace-tallace da Talla Haɓaka tallace-tallace, Automation, da Ayyuka Kafofin watsa labarun & Tasirin Talla

Sheets na Google: Tallace-tallacen Haɗin gwiwa da Tallace-tallacen Talla tare da Haɗaɗɗen Bayanan Lokaci na Gaskiya

Douglas KarrNov 10, 2023

6 minti na karanta

Sheets na Google: haɗa api, rubutun app, bayanan ainihin lokaci, ayyukan shigo da kaya

Har yanzu muna amfani da maƙunsar bayanai!

Wannan wani abu ne da nake yawan ji daga kamfanonin da ke jin kunyar rashin kwarewar kamfaninsu na fasaha. Idan tallace-tallace da tallace-tallace sun yi amfani da cikakken ikon Google Sheets, ko da yake, da alama za su yi alfahari da iyawarsu.

Google Sheets kayan aiki ne mai mahimmanci don sassan tallace-tallace da tallace-tallace, yana ba da hanyoyi daban-daban don haɓaka haɗin gwiwa da daidaita ayyukan aiki. Anan akwai hanyoyi guda goma ƙungiyoyin ku zasu iya amfani da Google Sheets:

Haɗin kai na ainihi: Membobin ƙungiyar za su iya yin aiki akan takarda ɗaya lokaci guda, suna ba da damar sabuntawa na ainihin lokaci da haɗin gwiwa.
Haɓaka bayanai: Haɗa ma'auni daga kamfen daban-daban a wuri ɗaya na tsakiya, yana ba da damar haɗe-haɗen ra'ayi na ƙoƙarin tallace-tallace.
Dashboards Ayyuka: Ƙirƙirar dashboards tare da zane-zane da zane-zane don wakiltar bayanan tallace-tallace na gani da yanayin.
Bibiyan Kasafin Kudi: Kula da kasafin kuɗi da kashe kuɗi a cikin ainihin lokacin don sarrafa kuɗi da kyau da yanke shawara masu tsada.
Gudanar da aikin: Yin amfani da zanen gado don bibiyar lokutan ayyukan, abubuwan da za a iya bayarwa, da ɓangarorin da ke da alhakin tabbatar da kamfen yana kan jadawalin.
Gudanar da Yaƙin neman zaɓe: Tsayawa shafuka akan yakin talla, rarrabawa URLs kamfen, da sakamakon wadancan kamfen.
Kalandar abun ciki: Tsara dabarun abun ciki ta hanyar tsara posts, bin diddigin kwanakin bugawa, da daidaita abun ciki a cikin dandamali.
Binciken Gwajin A/B: Yin rikodin cikakkun bayanai da sakamakon A gwada A / B don ƙayyade dabarun tallan mafi inganci.
Gudanar da Abokin Abokan Hulɗa (CRM): Sarrafa bayanan abokin ciniki, hulɗa, da biyo baya don haɓaka alaƙar abokin ciniki da riƙewa.
Tarin Bayani da Bincike: Tara ku bincika ra'ayoyin abokin ciniki ta hanyar siffofin da aka haɗa kai tsaye zuwa Google Sheet don sanar da dabarun da haɓaka samfuri.

Babban mahimmancin wannan aikin ba shine daidaitaccen aiki na masu amfani ba don zubar da tebur bayanai cikin Google Sheets sannan a fara aiki da shi… shine ikon haɗa bayanan da aka sabunta ta atomatik ko shigo da su ta zaɓuɓɓuka da yawa.

Haɗin bayanan Sheets na Google

Ƙungiyoyi da yawa suna yin watsi da ƙaƙƙarfan fasalulluka na samun bayanan da ke cikin Google Sheets. Bayan saukaka marufin haɗin gwiwar, Google Sheets yana ba da tsararrun kayan aikin da ba a yi amfani da su ba, kamar su. IMPORT dabara don tattara bayanan waje kai tsaye, Rubutun Apps na Google don sarrafa aiki da haɓaka ayyuka, da AppSheet don ƙirƙirar ƙa'idodi masu ƙarfi dangane da bayanan maƙulli.

Bugu da ƙari, rikodin macros da sarrafa ayyuka masu maimaitawa, yayin da kari-kan haɓaka ƙarfin dandamali. Waɗannan kayan aikin suna ba ƴan kasuwa damar yin amfani da bayanan lokaci na gaske don yanke shawara da ba da amsa ga canje-canjen kasuwa.

Gina-In-Shigo Ayyuka

Don haɗa Google Sheets tare da tushen bayanan waje ko APIs, zaku iya amfani da ginanniyar ayyukan Google Sheets kamar IMPORTDATA, IMPORTFEED, IMPORTHTML, Da kuma IMPORTXML. Waɗannan ayyuka suna ba ku damar shigo da bayanai daga nau'ikan bayanan da aka tsara daban-daban zuwa cikin Google Sheet ɗin ku, gami da CSV, RSS, HTML, Da kuma XML. Anan ga cikakken bayani ga kowane ɗayan IMPORT ayyuka a cikin Google Sheets:

SHIGOWA: Yana shigo da bayanai a URL a cikin tsarin .csv ko .tsv. Yana yada bayanai a cikin sel da yawa, farawa daga tantanin halitta inda kuka shigar da dabarar kuma shimfidawa ƙasa da sama kamar yadda ake buƙata don dacewa da layuka da ginshiƙan fayil ɗin bayanai. An iyakance shi zuwa 50 IMPORTDATA kira kowane maƙunsar rubutu kuma URL ɗin dole ne ya zama hanyar haɗin kai kai tsaye zuwa fayil ɗin .csv ko .tsv. Misali:

=IMPORTDATA("https://example.com/data.csv")

SHIGOWA: Yana shigo da RSS na jama'a ko ciyarwar ATOM. Wannan yana shigo da ciyarwar kuma yana yada shi a cikin sel da yawa, tare da zaɓuɓɓuka don tantance menene bayanin ciyarwar don dawo da abubuwa nawa don nunawa. Wannan yana iyakance ga ciyarwar da baya buƙatar tantancewa, kuma tsarin ciyarwar yana shafar yadda ake nuna bayanai.

=IMPORTFEED("http://example.com/feed", "items title", TRUE, 5)

SHIGA HTML: Yana shigo da bayanai daga tebur ko jeri a cikin shafin HTML. Wannan yana fitar da takamaiman tebur ko jeri daga abun ciki na HTML kuma yana sanya shi a cikin sel masu dacewa waɗanda ke farawa daga inda aka shigar da dabarar. Wannan yana aiki tare da URLs masu isa ga jama'a; yana buƙatar madaidaicin index na tebur ko jeri; iyakance zuwa tebur or list tambaya.

=IMPORTHTML("http://example.com", "table", 1)

IMPORTXML: Yana shigo da bayanai daga kowane XML, HTML, ko XHTML abun ciki ta amfani da XPath tambayoyi. Wannan yana rarraba bayanan ta amfani da XPath da aka bayar kuma yana shigo da abun ciki cikin maƙunsar bayanai, yana faɗaɗa daga tantanin halitta zuwa ƙasa da dama. Yana buƙatar sanin yaren tambaya na XPath; Dole ne URL ya kasance mai isa ga jama'a kuma a tsara shi yadda ya kamata a cikin XML/HTML/XHTML.

=IMPORTXML("http://example.com/data", "//div[@class='example']")

kowane IMPORT An kera aikin musamman don nau'ikan bayanai da tushe daban-daban, kuma dukkansu suna da yuwuwar juya Google Sheets zuwa kayan aiki mai ƙarfi don tattarawa da tsara bayanai daga gidan yanar gizo. Waɗannan ayyuka suna da amfani musamman don ayyukan tallace-tallace kamar ƙididdigar gasa, bincike na kasuwa, da bin diddigin ayyukan yaƙin neman zaɓe, inda bayanan waje ke taka muhimmiyar rawa wajen yanke shawara.

Rubutun Google Apps

Kuna iya rubuta ayyukan al'ada a cikin Rubutun Apps na Google don cire bayanai daga shafuka ko APIs yana buƙatar tantancewa ko ma'amala mai rikitarwa. Wannan harshe na tushen JavaScript zai iya yin hulɗa tare da wasu ayyukan Google da APIs na waje don ɗauko da aika bayanai kamar yadda ake buƙata. Babbar hanyar fara haɗa bayanan kai tsaye daga API zuwa Google Sheets ita ce kamar haka:

Yi amfani da Apps Script don buɗe sabon editan rubutun a cikin Google Sheets.
Rubuta aikin rubutun al'ada don kiran API ɗin da ake so ta amfani da URLFetchApp sabis.
Rarraba martanin API kuma saita bayanan da suka dace a cikin Google Sheet ta amfani da setValues hanya don abubuwa masu iyaka.

Wannan hanyar tana ba da damar sarrafa sarrafa bayanai na shigo da bayanai, kuma tare da abubuwan jan hankali, zaku iya saita tazara don bayanan su sabunta ta atomatik. A matsayin misali, ga yadda zaku iya buƙatar Matsayin URL ta amfani da SEMrush:

function getUrlRankHistory(url) {
  var apiKey = 'YOUR_API_KEY'; // Replace with your actual SEMrush API key.
  var database = 'us'; // Example: use 'us' for the US database.
  var apiEndPoint = 'https://api.semrush.com/';
  var requestUrl = apiEndPoint + 
                   '?type=url_rank_history&key=' + apiKey + 
                   '&display_limit=10&export_columns=Or,Ot,Oc,Ad,At,Ac,Dt&url=' + 
                   encodeURIComponent(url) + 
                   '&database=' + database;
  
  try {
    var response = UrlFetchApp.fetch(requestUrl);
    var jsonResponse = response.getContentText();
    var lines = jsonResponse.split("\n");
    var historyData = [];
  
    for (var i = 1; i < lines.length; i++) {
      if (lines[i].length > 0) {
        var columns = lines[i].split(';');
        var record = [
          columns[0], // Organic Keywords
          columns[1], // Organic Traffic
          columns[2], // Organic Cost
          columns[3], // Adwords Keywords
          columns[4], // Adwords Traffic
          columns[5], // Adwords Cost
          columns[6]  // Date
        ];
        historyData.push(record);
      }
    }

    return historyData;
  } catch (e) {
    // If an error occurs, log it and return a message.
    Logger.log(e.toString());
    return [["Error fetching data"]];
  }
}

Bayan adana wannan rubutun da aka gyara, zaku iya amfani da getUrlRankHistory aiki a cikin takardar ku kamar haka:

=getUrlRankHistory("https://www.example.com")

Google Sheet Add-ons

Google Sheets add-ons plugins ne na ɓangare na uku ko kari waɗanda za'a iya shigar dasu don haɓaka ayyukan Google Sheets. Waɗannan add-ons suna ba da ƙarin fasaloli kamar ƙididdigar bayanai na ci gaba, kayan aikin sarrafa ayyukan, ayyukan aiki na atomatik, da haɗin kai tare da sauran software da ayyuka.

Anan akwai wasu shahararrun add-kan Google Sheets waɗanda zasu iya zama da amfani musamman ga ƙwararrun tallace-tallace da tallace-tallace:

SHIGO DAGA YANAR GIZO: The Shigo Daga Yanar Gizo add-on yana amfani da saitin dokoki da masu zaɓen da mai amfani ya bayar don goge bayanai daga abubuwan HTML na shafukan yanar gizo.
Kayan Aiki: Kayan Aiki kayan aiki ne mai ƙarfi don fitar da bayanai daga tushe daban-daban kamar Google Analytics, Facebook, X, LinkedIn, Da kuma SEMrush cikin Google Sheets don bayar da rahoto da bincike.
Duk da haka Wani Hadin Wasikun (YAMM): YAMM yana da amfani don aikawa da keɓaɓɓen kamfen ɗin imel ta amfani da Gmel da sakamakon bin diddigin kai tsaye a cikin Google Sheets.
Zapier: Zapier yana ba ku damar haɗa Google Sheets zuwa fiye da sauran ayyukan gidan yanar gizo dubu don sarrafa ayyukan aiki. Misali, zaku iya ajiye haɗe-haɗe na imel ta atomatik zuwa Google Sheets ko kuma tallan tallace-tallace kai tsaye daga a CRM.
Hunter: Hunter zai baka damar nemo adiresoshin imel masu alaƙa da gidan yanar gizo kuma ka tsara su cikin maƙunsar rubutu, wanda ke da taimako ga haɓakar jagora da kai wa ga kai.
Form Alfadara: Form Alfadara add-on email na atomatik yana taimakawa aika sadarwar imel dangane da bayanan da ke cikin maƙunsar bayanai. Yana da kyau ga saƙon imel na biyo baya bayan taron ko kiran tallace-tallace.
DocuSign: The DocuSign eSignature add-on don Google Sheets yana ba da damar aikawa da sanya hannu kan takaddun kai tsaye daga Google Sheets, yana daidaita tsarin kwangilar ƙungiyoyin tallace-tallace.

Waɗannan add-ons suna faɗaɗa ƙarfin Google Sheets sama da sauƙin sarrafa bayanai, ba da damar tallace-tallace da ƙungiyoyin tallace-tallace don aiwatar da ayyuka cikin inganci kai tsaye daga maƙunsar bayanan su. Ta amfani da waɗannan kayan aikin, ƙungiyoyi za su iya sarrafa tarin bayanai da bayar da rahoto, sarrafa kamfen ɗin imel, daidaita hanyoyin sadarwa, da kuma kula da sa hannun daftarin aiki, duk waɗannan na iya adana lokaci da haɓaka haɓaka aiki.

Takardar Shafin Google

Takardar Shafin Google dandamali ne da ke ba masu amfani damar ƙirƙirar aikace-aikacen hannu daga bayanan da ke cikin Google Sheets ba tare da rubuta lambar ba. Dandali ne wanda ba shi da lambar haɓakawa wanda zai iya juya bayanan da aka adana a cikin maƙunsar bayanai zuwa aikace-aikace masu arziƙi. Ƙwararren masani na AppSheet yana ba da damar ƙara fasali kamar taswira, siffofi, sigogi, da ƙari. An ƙirƙira shi don samar da ci gaban ƙa'ida ga duk wanda ke da bayanan da suke son tsarawa da gabatar da shi a cikin tsarin ƙa'idar, haɓaka haɓaka aiki da sauƙaƙe sarrafa bayanai.

Tare da AppSheet, zaku iya sarrafa ayyukan aiki ko juya bayanan ku zuwa gidan yanar gizo mai ƙarfi da ƙa'idodin wayar hannu, duk daga bayanan da kuke sarrafa a cikin Google Sheets. Yana da amfani ga 'yan kasuwa da daidaikun mutane waɗanda ke buƙatar aikace-aikacen al'ada don shigarwar bayanai, sarrafa ɗawainiya, ko tsara jadawalin taron amma ba su da albarkatun don haɓaka aikace-aikacen software na gargajiya.