{"id":23661,"date":"2019-12-16T11:46:58","date_gmt":"2019-12-16T10:46:58","guid":{"rendered":"https:\/\/www.minicrm.hu\/help\/?p=23661"},"modified":"2025-11-27T13:54:27","modified_gmt":"2025-11-27T12:54:27","slug":"rapoarte-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/","title":{"rendered":"Rapoarte \u00een Google Sheets"},"content":{"rendered":"<p style=\"text-align: justify;\">MiniCRM \u00ee\u021bi permite s\u0103 extragi date din sistem \u0219i s\u0103 \u00ee\u021bi construie\u0219ti rapoarte \u00een Google Sheets.<\/p>\n<p style=\"text-align: justify;\">Pentru \u00eenceput, construie\u0219te un <a href=\"..\/filtre\">filtru<\/a> \u00een sistem pentru preluarea \u0219i sincronizarea informa\u021biilor. Po\u021bi g\u0103si <a href=\"https:\/\/www.minicrm.ro\/help\/sincronizarea-filtrelor\/\">aici<\/a> detalii legate de sincronizarea datelor cu Google Sheets.<\/p>\n<p style=\"text-align: justify;\">Dup\u0103 ce ai creat filtrul \u0219i ai sincronizat datele cu foaia de calcul Google, po\u021bi s\u0103 manipulezi datele \u00een orice fel ai nevoie.<\/p>\n<div class=\"alert alert-danger\" style=\"text-align: justify;\"><strong>Important<\/strong>: Nu modifica \u00een niciun fel func\u021bia ImportData precum nici numele sau ordinea coloanelor generate de sincronizare. \u00cen caz contrar, sincronizarea va genera erori.<\/div>\n<div class=\"alert alert-info\" style=\"text-align: justify;\">Pentru ca rapoartele s\u0103 func\u021bioneze corect, asigur\u0103-te c\u0103 set\u0103rile regionale ale foii de calcul sunt setate pentru Statele Unite.<\/div>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23679\" src=\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15.png\" alt=\"\" width=\"2460\" height=\"1354\" srcset=\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15.png 1920w, https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15-300x165.png 300w, https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15-1024x564.png 1024w, https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15-768x423.png 768w, https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15-1536x845.png 1536w, https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15-2048x1127.png 2048w\" sizes=\"auto, (max-width: 2460px) 100vw, 2460px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">\u00cen exemplul de mai sus, am calculat suma veniturilor a\u0219teptate. Manipularea datelor \u00een Google Sheets este, \u00eens\u0103, mult mai ampl\u0103 \u0219i, \u00een func\u021bie de priceperea pe care o ai cu formulele acestei aplica\u021bii, po\u021bi genera rapoarte diverse, inclusiv grafice.<\/p>\n<div class=\"alert alert-info\" style=\"text-align: justify;\"><strong>FOARTE IMPORTANT:<\/strong> \u00cen mod normal, Google actualizeaz\u0103 datele aduse prin func\u021bia =importdata \u00een fiecare or\u0103, \u00een jurul orei fixe. Cu toate acestea, din motive care nu \u021bin de noi, aceast\u0103 actualizare automat\u0103 nu func\u021bioneaz\u0103 de fiecare dat\u0103. Ca s\u0103 te asiguri c\u0103 ce ai \u00een fa\u021b\u0103 sunt cele mai recente date, d\u0103 un refresh manual spreadsheet-ului de fiecare dat\u0103 c\u00e2nd vrei s\u0103 \u00eel consul\u021bi.<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MiniCRM \u00ee\u021bi permite s\u0103 extragi date din sistem \u0219i s\u0103 \u00ee\u021bi construie\u0219ti rapoarte \u00een Google Sheets. Pentru \u00eenceput, construie\u0219te un filtru \u00een sistem pentru preluarea \u0219i sincronizarea informa\u021biilor. Po\u021bi g\u0103si aici detalii legate de sincronizarea datelor cu Google Sheets. Dup\u0103 ce ai creat filtrul \u0219i ai sincronizat datele cu foaia de calcul Google, po\u021bi s\u0103 [&hellip;]<\/p>\n","protected":false},"author":54,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2567,2561],"tags":[1263,1497],"class_list":["post-23661","post","type-post","status-publish","format-standard","hentry","category-crearea-de-rapoarte-personalizate","category-rapoarte-implicite-si-personalizate","tag-filter-ro","tag-report-ro"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Rapoarte \u00een Google Sheets - Documenta\u021bie MiniCRM<\/title>\n<meta name=\"description\" content=\"MiniCRM \u00ee\u021bi permite s\u0103 extragi date din sistem \u0219i s\u0103 \u00ee\u021bi construie\u0219ti rapoarte \u00een Google Sheets. Pentru \u00eenceput, construie\u0219te un filtru \u00een sistem pentru\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rapoarte \u00een Google Sheets - Documenta\u021bie MiniCRM\" \/>\n<meta property=\"og:description\" content=\"MiniCRM \u00ee\u021bi permite s\u0103 extragi date din sistem \u0219i s\u0103 \u00ee\u021bi construie\u0219ti rapoarte \u00een Google Sheets. Pentru \u00eenceput, construie\u0219te un filtru \u00een sistem pentru\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Documenta\u021bie MiniCRM\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-16T10:46:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-27T12:54:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1057\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bogdan Burciu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bogdan Burciu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/\"},\"author\":{\"name\":\"Bogdan Burciu\",\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#\\\/schema\\\/person\\\/8a676279a8b36970727c5347285cebb9\"},\"headline\":\"Rapoarte \u00een Google Sheets\",\"datePublished\":\"2019-12-16T10:46:58+00:00\",\"dateModified\":\"2025-11-27T12:54:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/\"},\"wordCount\":230,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minicrm-wp-help.s3.amazonaws.com\\\/uploads\\\/2019\\\/12\\\/Screenshot-2019-12-16-at-12.42.15.png\",\"keywords\":[\"filter-ro\",\"report-ro\"],\"articleSection\":[\"Crearea de rapoarte personalizate\",\"Rapoarte implicite si personalizate\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/\",\"url\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/\",\"name\":\"Rapoarte \u00een Google Sheets - Documenta\u021bie MiniCRM\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minicrm-wp-help.s3.amazonaws.com\\\/uploads\\\/2019\\\/12\\\/Screenshot-2019-12-16-at-12.42.15.png\",\"datePublished\":\"2019-12-16T10:46:58+00:00\",\"dateModified\":\"2025-11-27T12:54:27+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#\\\/schema\\\/person\\\/8a676279a8b36970727c5347285cebb9\"},\"description\":\"MiniCRM \u00ee\u021bi permite s\u0103 extragi date din sistem \u0219i s\u0103 \u00ee\u021bi construie\u0219ti rapoarte \u00een Google Sheets. Pentru \u00eenceput, construie\u0219te un filtru \u00een sistem pentru\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/#primaryimage\",\"url\":\"https:\\\/\\\/minicrm-wp-help.s3.amazonaws.com\\\/uploads\\\/2019\\\/12\\\/Screenshot-2019-12-16-at-12.42.15.png\",\"contentUrl\":\"https:\\\/\\\/minicrm-wp-help.s3.amazonaws.com\\\/uploads\\\/2019\\\/12\\\/Screenshot-2019-12-16-at-12.42.15.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.minicrm.ro\\\/help\\\/rapoarte-in-google-sheets\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rapoarte \u00een Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#website\",\"url\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/\",\"name\":\"Documenta\u021bie MiniCRM\",\"description\":\"Welcome to MiniCRM\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#\\\/schema\\\/person\\\/8a676279a8b36970727c5347285cebb9\",\"name\":\"Bogdan Burciu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e14cb779ed6e91c809dfbe3a892ee4d39402679edbbf262dbb8811974db2df54?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e14cb779ed6e91c809dfbe3a892ee4d39402679edbbf262dbb8811974db2df54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e14cb779ed6e91c809dfbe3a892ee4d39402679edbbf262dbb8811974db2df54?s=96&d=mm&r=g\",\"caption\":\"Bogdan Burciu\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Rapoarte \u00een Google Sheets - Documenta\u021bie MiniCRM","description":"MiniCRM \u00ee\u021bi permite s\u0103 extragi date din sistem \u0219i s\u0103 \u00ee\u021bi construie\u0219ti rapoarte \u00een Google Sheets. Pentru \u00eenceput, construie\u0219te un filtru \u00een sistem pentru","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"Rapoarte \u00een Google Sheets - Documenta\u021bie MiniCRM","og_description":"MiniCRM \u00ee\u021bi permite s\u0103 extragi date din sistem \u0219i s\u0103 \u00ee\u021bi construie\u0219ti rapoarte \u00een Google Sheets. Pentru \u00eenceput, construie\u0219te un filtru \u00een sistem pentru","og_url":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/","og_site_name":"Documenta\u021bie MiniCRM","article_published_time":"2019-12-16T10:46:58+00:00","article_modified_time":"2025-11-27T12:54:27+00:00","og_image":[{"width":1920,"height":1057,"url":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15.png","type":"image\/png"}],"author":"Bogdan Burciu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bogdan Burciu","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/#article","isPartOf":{"@id":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/"},"author":{"name":"Bogdan Burciu","@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/8a676279a8b36970727c5347285cebb9"},"headline":"Rapoarte \u00een Google Sheets","datePublished":"2019-12-16T10:46:58+00:00","dateModified":"2025-11-27T12:54:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/"},"wordCount":230,"commentCount":0,"image":{"@id":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15.png","keywords":["filter-ro","report-ro"],"articleSection":["Crearea de rapoarte personalizate","Rapoarte implicite si personalizate"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/","url":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/","name":"Rapoarte \u00een Google Sheets - Documenta\u021bie MiniCRM","isPartOf":{"@id":"https:\/\/www.minicrm.hu\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15.png","datePublished":"2019-12-16T10:46:58+00:00","dateModified":"2025-11-27T12:54:27+00:00","author":{"@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/8a676279a8b36970727c5347285cebb9"},"description":"MiniCRM \u00ee\u021bi permite s\u0103 extragi date din sistem \u0219i s\u0103 \u00ee\u021bi construie\u0219ti rapoarte \u00een Google Sheets. Pentru \u00eenceput, construie\u0219te un filtru \u00een sistem pentru","breadcrumb":{"@id":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/#primaryimage","url":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15.png","contentUrl":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2019\/12\/Screenshot-2019-12-16-at-12.42.15.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.minicrm.ro\/help\/rapoarte-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.minicrm.hu\/help\/"},{"@type":"ListItem","position":2,"name":"Rapoarte \u00een Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/www.minicrm.hu\/help\/#website","url":"https:\/\/www.minicrm.hu\/help\/","name":"Documenta\u021bie MiniCRM","description":"Welcome to MiniCRM","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.minicrm.hu\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/8a676279a8b36970727c5347285cebb9","name":"Bogdan Burciu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e14cb779ed6e91c809dfbe3a892ee4d39402679edbbf262dbb8811974db2df54?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e14cb779ed6e91c809dfbe3a892ee4d39402679edbbf262dbb8811974db2df54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e14cb779ed6e91c809dfbe3a892ee4d39402679edbbf262dbb8811974db2df54?s=96&d=mm&r=g","caption":"Bogdan Burciu"}}]}},"_links":{"self":[{"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/posts\/23661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/users\/54"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/comments?post=23661"}],"version-history":[{"count":4,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/posts\/23661\/revisions"}],"predecessor-version":[{"id":59290,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/posts\/23661\/revisions\/59290"}],"wp:attachment":[{"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/media?parent=23661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/categories?post=23661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/tags?post=23661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}