[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/10\/SMD_Image-of-Company_13_10_2022.webp” alt=”SMD” title_text=”SMD_Image of Company_13_10_2022″ _builder_version=”4.17.4″ _module_preset=”default” width=”100%” max_width=”600px” max_height=”360px” border_radii=”on|12px|12px|12px|12px” box_shadow_style=”preset1″ box_shadow_horizontal=”6px” box_shadow_vertical=”0px” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Specialized Media Dashboard (SMD) is a free Open Source media monitoring system that needs to keep up-to-date reports for Journalism & Law Enforcement.<\/p>\n
By using Sheetgo, SMD was able to merge, categorize and report data from over 60 Google Sheets without creating and running complex scripts.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Merging over 60 spreadsheets into a single sheet<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- SMD needed to merge data from over 60 sheets<\/li>\n
- Struggle to gather, manipulate and categorize all the data without resorting to complex scripts<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Specialized Media Dashboard was extracting data from multiple data sources into Google Sheets. The biggest challenge was combining and categorizing these datasets from multiple sheets into a single spreadsheet so they could manipulate and organize all the data.<\/p>\n
Manual entry was not an option due to a large amount of information. Another option would be to create and run scripts, but this would have been very complex and time-consuming.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cThe biggest issue was that all the data needed to be found in more than 60 sheets in an easy way without creating scripts, otherwise it would have been way too complex.\u201d<\/span><\/p>\n
Daniel Kwee, Specialized Media Dashboard
\n<\/em>[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nDaniel wanted to find a more affordable and practical solution that would allow him to merge and manipulate the data seamlessly. Not only did this solution need to be simple and easy to use, but it also needed to be reliable and flexible.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Automating data manipulation with Sheetgo<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- All the data from multiple sources merged into a single spreadsheet<\/li>\n
- Custom reports updated automatically<\/li>\n
- International crime news categorized automatically<\/li>\n
- Complex integrations made simple<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Sheetgo has successfully helped in the early stage of the project and during its critical phases of engineering work for the prototype of the dashboard creation.<\/p>\n
With the help of Sheetgo, Specialized Media Dashboard managed to fully automate the process of extracting, merging, and organizing all the international crime media articles scattered over multiple sheets.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cSheetgo was used because it was the only tool with which I could merge more than 60 different sheets into 1, in order to categorize my data.\u201d<\/span><\/p>\n
Daniel Kwee, Specialized Media Dashboard<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Sheetgo allowed SMD to integrate multiple data sources seamlessly and create custom reports updated automatically in Google Data Studio.<\/p>\n
In this integration, Google Sheets pulls out data from Google News and categorizes all the information within separate spreadsheets. Whenever a new media article is published in Google News, the spreadsheets are updated automatically with other tools.<\/p>\n
The Sheetgo integration merges data from all these spreadsheets into a single Google Sheets file. Finally, Specialized Media Dashboard used the data from this spreadsheet to create a custom report in Google Data Studio.<\/p>\n
[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Creating an affordable and efficient solution with Sheetgo<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- Saving hours of work with a simple and efficient solution<\/li>\n
- Effortless data analysis<\/li>\n
- 100% up-to-date custom dashboard data<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Sheetgo helped Specialized Media Dashboard create a solution that allowed them to manipulate a huge amount of data with just a few clicks and save hours of work.<\/p>\n
Thanks to Sheetgo, they were able to manipulate and report data efficiently and effortlessly without having to write and run complex scripts.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cSheetgo has an amazing support team. The support team demonstrated passion and patience in order to solve complex technical issues. They are geniuses!\u201d<\/span><\/p>\n
Daniel Kwee, Specialized Media Dashboard<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Eventually, due to a large amount of data, Specialized Media Dashboard had to migrate to a MariaDB server.<\/p>\n
Sheetgo has also helped update and modify several Google Sheets scripts and formulae in order to make them compatible with the MariaDB database.<\/p>\n
[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/10\/SMD-logo.webp” alt=”SMD logo” title_text=”SMD-logo” align=”center” _builder_version=”4.17.4″ _module_preset=”default” width=”200px” max_width=”200px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Specialized Media Dashboard (SMD) is a project based on Google News and a free Open Source media monitoring system for Journalism & Law Enforcement. The SMD databases platform currently holds around 10 million media articles; 3M articles for the Crimes & Other incidents databases
and 7M articles for the COVID-19 pandemic database.<\/span><\/p>\n[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” hover_enabled=”0″ custom_css_main_element=”display: inline-block;” global_colors_info=”{}” sticky_enabled=”0″]France<\/span>[\/et_pb_text][et_pb_divider _builder_version=”4.16″ _module_preset=”default” custom_margin=”||20px||false|false” global_colors_info=”{}”][\/et_pb_divider][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Industry<\/strong>
Media<\/span><\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Features used<\/strong><\/span><\/p>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-google-sheets.svg\")
Google Sheets<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-bigquery.svg\")
Google Data Studio<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-merge.svg\")
Merge<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Specialized Media Dashboard: Automated data manipulation and reporting with SheetgoSheetgo is the no-code spreadsheet automation platform that turns the data your team already keeps in Sheets, Excel, and CSVs into pipelines, dashboards, and AI-ready datasets.Specialized Media Dashboard (SMD) is a free Open Source media monitoring system that needs to keep up-to-date reports for Journalism & […]<\/p>\n","protected":false},"author":2,"featured_media":228560,"parent":6600,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"difl_page_category":[],"class_list":["post-228555","page","type-page","status-publish","has-post-thumbnail","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/228555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=228555"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/228555\/revisions"}],"predecessor-version":[{"id":260773,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/228555\/revisions\/260773"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/6600"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/228560"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=228555"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/difl_page_category?post=228555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}