{"id":97,"date":"2021-12-27T16:51:16","date_gmt":"2021-12-27T14:51:16","guid":{"rendered":"https:\/\/smsalert.mobi\/blog\/?p=97"},"modified":"2021-12-28T10:01:03","modified_gmt":"2021-12-28T08:01:03","slug":"integrare-google-sheets","status":"publish","type":"post","link":"https:\/\/smsalert.mobi\/blog\/integrare-google-sheets\/","title":{"rendered":"Integrare google sheets"},"content":{"rendered":"\n<p>O functionalitate recent introdusa pentru mesajele SMS primite este posibilitatea de scriere in google sheets automat de catre platforma SMSAlert. <\/p>\n\n\n\n<p>De exemplu, presupunem ca utilizam modemul pentru a receptiona mesaje SMS trimite automat de catre un sistem de bariere rezidential \/ industrial ce poate fi apelat si dorim sa avem un registru jurnal pentru monitorizare trafic pentru a intocmi rapoarte lunare.<\/p>\n\n\n\n<p>Inainte de a adauga o regula de intrare in sistemul SMSAlert este necesar sa activam API-ul google sheets.<\/p>\n\n\n\n<p>Navigam catre https:\/\/console.developers.google.com si cre\u0103m un nou proiect.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"427\" src=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/new-project-gsheets.png\" alt=\"\" class=\"wp-image-98\" title=\"\" srcset=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/new-project-gsheets.png 975w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/new-project-gsheets-300x131.png 300w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/new-project-gsheets-768x336.png 768w\" sizes=\"auto, (max-width: 975px) 100vw, 975px\" \/><\/figure>\n\n\n\n<p>Navigam in meniul din stanga la APIs &amp; Services si activam optiunea.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"435\" src=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/enable-api-1024x435.png\" alt=\"\" class=\"wp-image-99\" title=\"\" srcset=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/enable-api-1024x435.png 1024w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/enable-api-300x127.png 300w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/enable-api-768x326.png 768w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/enable-api.png 1404w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Cautam &#8220;Google Sheets API&#8221; si activam.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"415\" src=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/g-sheets-api-1024x415.png\" alt=\"\" class=\"wp-image-100\" title=\"\" srcset=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/g-sheets-api-1024x415.png 1024w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/g-sheets-api-300x121.png 300w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/g-sheets-api-768x311.png 768w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/g-sheets-api-1536x622.png 1536w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/g-sheets-api.png 1852w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Adaugam credentiale noi &#8220;Create credentials&#8221; si introducem la nume &#8220;smsalert&#8221; iar la pemisiuni &#8220;Owner&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"569\" src=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-2-1024x569.png\" alt=\"\" class=\"wp-image-101\" title=\"\" srcset=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-2-1024x569.png 1024w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-2-300x167.png 300w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-2-768x427.png 768w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-2.png 1324w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1015\" height=\"1024\" src=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-3-1015x1024.png\" alt=\"\" class=\"wp-image-102\" title=\"\" srcset=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-3-1015x1024.png 1015w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-3-297x300.png 297w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-3-150x150.png 150w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-3-768x775.png 768w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/create-credentials-3.png 1156w\" sizes=\"auto, (max-width: 1015px) 100vw, 1015px\" \/><figcaption>Un nou &#8220;Service Account&#8221; a fost adaugat pe care dorim sa il editam pentru a crea o noua cheie de acces ce va fi folosita in cadrul regulei de intrare in SMSAlert.<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"962\" height=\"294\" src=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/service-account-edit.png\" alt=\"\" class=\"wp-image-103\" title=\"\" srcset=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/service-account-edit.png 962w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/service-account-edit-300x92.png 300w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/service-account-edit-768x235.png 768w\" sizes=\"auto, (max-width: 962px) 100vw, 962px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"744\" height=\"882\" src=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/service-account-add-key.png\" alt=\"\" class=\"wp-image-104\" title=\"\" srcset=\"https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/service-account-add-key.png 744w, https:\/\/smsalert.mobi\/blog\/wp-content\/uploads\/2021\/12\/service-account-add-key-253x300.png 253w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/figure>\n\n\n\n<p>In urma adagarii google va va intreba tipul de fisier dorit. Selectati tip &#8220;JSON&#8221; si salvati fisierul pe calculatorul dvs.<\/p>\n\n\n\n<p>Cream un nou google sheet unde datele vor fi scrise automat.<\/p>\n\n\n\n<p>Navigam la Share si permitem accesul &#8220;Edit&#8221; pentru Service Account creat anterior.<\/p>\n\n\n\n<p>Acesta este de forma unei adrese de email, ex xxxxx@lucid-diode-xxxx.iam.gserviceaccount.com<\/p>\n\n\n\n<p>In panoul de administrare SMSAlert navigam la &#8220;Reguli de intrare&#8221; -> &#8220;Save to google sheet&#8221;<\/p>\n\n\n\n<p>Introducem un text \/ cuvant-cheie pentru care dorim sa fie activata regula. De exemplu sistemul de bariere va trimite un. mesaj cu textul &#8220;OPEN BY 0720123456 AT 10:45PM&#8221;, deci putem defini &#8220;OPEN&#8221; ca trigger pentru aceasta regula.<\/p>\n\n\n\n<p>In campul <strong>Spreadsheet ID<\/strong> copiem ID-ul din URL-ul doc-ului, ex partea din URL.<\/p>\n\n\n\n<p>docs.google.com\/spreadsheets\/d\/<strong>xxxxxxxxxxxxxxxxxx<\/strong>\/edit#gid=0<\/p>\n\n\n\n<p>Deschidem fisierul JSON salvat anterior cu un editor text prefrerat (ex notepadd++) cu datele de autentificare din google sheets si facem copy paste in campul &#8220;<strong>Google JSON API credentials<\/strong>&#8220;.<\/p>\n\n\n\n<p>Salvam noua regula, iar setup-ul este gata.<\/p>\n\n\n\n<p>In urma activarii SMSAlert va scrie in noul sheet toate sms-urile primite pe colane, data, numar de telefon, mesaj text.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>O functionalitate recent introdusa pentru mesajele SMS primite este posibilitatea de scriere in google sheets automat de catre platforma SMSAlert. De exemplu, presupunem ca utilizam modemul pentru a receptiona mesaje SMS trimite automat de catre un sistem de bariere rezidential \/ industrial ce poate fi apelat si dorim sa avem un registru jurnal pentru monitorizare &#8230; <a title=\"Integrare google sheets\" class=\"read-more\" href=\"https:\/\/smsalert.mobi\/blog\/integrare-google-sheets\/\" aria-label=\"More on Integrare google sheets\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":105,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-97","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/posts\/97","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/comments?post=97"}],"version-history":[{"count":3,"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/posts\/97\/revisions"}],"predecessor-version":[{"id":109,"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/posts\/97\/revisions\/109"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/media\/105"}],"wp:attachment":[{"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/media?parent=97"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/categories?post=97"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smsalert.mobi\/blog\/wp-json\/wp\/v2\/tags?post=97"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}