[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/Mercy-Corps-main.webp” alt=”Untitled Group event” title_text=”Mercy-Corps-main” _builder_version=”4.18.1″ _module_preset=”default” width=”100%” max_width=”600px” max_height=”360px” hover_enabled=”0″ border_radii=”on|12px|12px|12px|12px” box_shadow_style=”preset1″ box_shadow_horizontal=”6px” box_shadow_vertical=”0px” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″][\/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=”{}” theme_builder_area=”post_content”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Using Sheetgo, Mercy Corps now save around 240 hours every single year with an automated communications management solution that consolidates 40 different location spreadsheets with other data sources. As a result, they now have 2-3 extra days per month to focus on their non-profit key actions.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
Finding a centralized communications management system<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” hover_enabled=”0″ border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
- \n
- \n
Complex information management across 40+ locations<\/span><\/p>\n<\/li>\n
- <\/span>\n
Struggle to find an easy-to-use tool on global scale<\/span><\/p>\n<\/li>\n
- <\/span>\n
Encountered Google Sheets data limitations<\/span><\/p>\n<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]One of the key challenges that Mercy Corps were facing was successfully managing information and communication channels across the globe. Running and coordinating multi-country programs is not an easy task in itself, especially when these programs require training tools and keeping track of highly mobile program participants.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” hover_enabled=”0″ border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]\u201cWe urgently needed a way to improve information sharing and financial services for young migrators.\u201d
\n<\/span><\/p>\nJustin Colvard, Deputy Country Director | Mercy Corps
\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=”{}” theme_builder_area=”post_content”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Mercy Corps reached out to Sheetgo looking to improve their communication system and sharing of information between different country teams. Although they found Google Sheets to be a temporary solution for information management, this approach soon fell short in terms of data storage capacity and account permissions.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\nEffortless data centralization using Sheetgo<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” hover_enabled=”0″ border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
- \n
- Merging 18 country-specific spreadsheets
\n<\/span><\/li>\n- <\/span>Control over edit permissions for each file
\n<\/span><\/li>\n- <\/span>Automatic update schedule for up-to-date insights
\n<\/span><\/li>\n<\/ul>\n[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Sheetgo has helped Mercy Corps meet their main challenge by allowing all spreadsheets to \u2018talk to one another\u2019. Using the Merge feature, the country-specific spreadsheets are combined into one master sheet, giving them full visibility of their data. The organization don’t have to worry about editing permissions anymore, as in this master sheet, the data will be protected. This means they are able to view each other’s data, without interfering with the overall business workflow or structure.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” hover_enabled=”0″ border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]\u201cSheetgo has really opened up the stream of communications between our teams in Mali, Niger, and Tunisia.\u201d
\n<\/span><\/p>\nJustin Colvard, Deputy Country Director | Mercy Corps
\n<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]By connecting the multiple data sources in different areas, Sheetgo has made it possible for Mercy Corps to centralize data, resulting in better communication flow and real-time information sharing. What’s more, through scheduling automatic updates team members have access to the latest insights, as all the information is kept up-to-date.[\/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=”{}” theme_builder_area=”post_content”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\nSaving 3 days per month to focus more the quality of the programs<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” hover_enabled=”0″ border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
- \n
- \n
240 hours saved every year<\/span><\/p>\n<\/li>\n
- <\/span>\n
3 days of work saved every month<\/span><\/p>\n<\/li>\n
- \n
100% up-to-date information for all locations<\/span>
<\/span><\/p>\n<\/li>\n<\/ul>\n[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Thanks to this new communication management system, Mercy Corps now save a total of 240 hours every year which can now be dedicated to expanding the reach and ensuring program quality across all target locations. Replacing the decentralized system which made it harder to share key information, Mercy Corps employees now save 2-3 days every month with this automated workflow.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” hover_enabled=”0″ border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]\u201cBy using Sheetgo it\u2019s now possible to promote real-time communication, transparency and sharing between the three country teams.\u201d
\n<\/span><\/p>\nJustin Colvard | Deputy Country Director, Mercy Corps
\n<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]By using Sheetgo, it\u2019s now possible to promote real-time communication, transparency, and sharing between the three country teams. Moreover, Sheetgo’s user-friendly interface makes it easy to train other team members on how to link multiple files together while maintaining productivity and growth.[\/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=”|||” theme_builder_area=”post_content”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/04\/mercy-corps-logo.svg” alt=”Untitled Group logo” title_text=”mercy-corps-logo” align=”center” _builder_version=”4.18.1″ _module_preset=”default” width=”200px” max_width=”200px” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″][\/et_pb_image][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]MERCY CORPS is an international non-profit working in over 40 countries. Over the next two years, one of their key activities is to identify future young migrators and offer them the necessary information and skills to migrate safely.
\n<\/span>[\/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=”{}” theme_builder_area=”post_content”][\/et_pb_icon][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” hover_enabled=”0″ custom_css_main_element=”display: inline-block;” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]United Kingdom<\/span>[\/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|||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_icon][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” width=”85%” hover_enabled=”0″ custom_css_main_element=”display: inline-block;” global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]https:\/\/europe.mercycorps.org\/<\/span><\/a>[\/et_pb_text][et_pb_divider _builder_version=”4.16″ _module_preset=”default” custom_margin=”||20px||false|false” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_divider][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Industry<\/strong>
\nNon-profit organization<\/span>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]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\/2021\/07\/scalable-sheets-google-drive.svg\")
Google Drive<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/05\/icon-connection.svg\")
Connect<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-merge.svg\")
Merge<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/automatic-updates.png)
Automatic updates<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Mercy Corps: Communications management solution for international migration non-profitSheetgo 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.Using Sheetgo, Mercy Corps now save around 240 hours every single year with an automated communications management solution that consolidates 40 different […]<\/p>\n","protected":false},"author":2,"featured_media":0,"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-6603","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/6603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=6603"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/6603\/revisions"}],"predecessor-version":[{"id":260741,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/6603\/revisions\/260741"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/6600"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=6603"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/difl_page_category?post=6603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- <\/span>\n
- <\/span>Control over edit permissions for each file
- <\/span>\n