[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/09\/latitude59.webp” alt=”Untitled Group event” title_text=”latitude59″ _builder_version=”4.18.1″ _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=”{}”]Using Sheetgo, Latitude59 now save around 380 hours of work per year using a custom workflow that connects their user’s attendance data with roundtable information to create unique events schedules in one location. As a result, they now have a completely automated solution that gives them 4 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” global_colors_info=”{}”]<\/p>\n
Finding an efficient way to manage a high volume of data<\/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” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- \n
Struggle to deal with huge volumes of data<\/span><\/p>\n<\/li>\n
- <\/span>\n
Difficult to centralize hundreds of roundtable events<\/span><\/p>\n<\/li>\n
- <\/span>\n
Manual input was too time consuming<\/span><\/p>\n<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]The organizers of Latitude59 were looking for a way to streamline their data processes for an efficient events management solution. With over 100 roundtable events over several days to manage, and thousands of attendance requests from attendees, manually handling these requests was out of the question.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]“It was the very first time we ran online roundtables. In four days, we had around 120 of these sessions taking place simultaneously.\u201d
\n<\/span><\/p>\nKadri Sundja, Head of Programme and Mentoring | Latitude59
\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=”{}”]The team needed a way to filter this large amount of events data according to schedule, approve all attendance registrations by customers, and finally create attendance lists to share directly with these customers. Latitude59 reached out to Sheetgo to create a custom workflow solution that would be able to work with their existing tools such as Google Forms, which they used to collect registrations by attendees.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nA custom events organization solution using existing tools<\/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” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- Connecting hundreds of Google Forms and Sheets<\/span><\/li>\n
- <\/span>\n
Filter data automatically according to specific criteria<\/span><\/p>\n<\/li>\n
- <\/span>Split data to create unique itinerary per attendee<\/span><\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]With the help of the Sheetgo experts, Latitude59 built and scaled a fully customized events management solution. The workflow connects the Google Forms responses with the Roundtable Google Sheets to find out which attendees want to attend each roundtable. These connections are combined with spreadsheet functions such as QUERY, ARRAY and VLOOKUP to match the attendee to their desired event. This data is added to a new approvals sheet.[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cAs with your usual beta launch, we only had rough ideas about processes and were not ready to handle this amount of data. With Sheetgo we were quickly able to get on top of it.\u201d
\n <\/span><\/p>\nKadri Sundja, Head of Programme and Mentoring | Latitude59
\n<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]The approvals sheet is then analyzed by events organizers to approve attendee numbers for each roundtable event. Once approved, Sheetgo uses the Split feature to create a unique events schedule for each attendee, which are located in one folder in their system, ready to send out as they please. Finally, Latitide59 use the smart automations feature to keep the workflow updated at regular intervals during this time, so that they always have the latest, up-to-date events infromation at hand.[\/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>\nSaving 1 day of work each week to focus on event management<\/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” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- \n
380 hours saved every year<\/span><\/p>\n<\/li>\n
- <\/span>\n
4 days of work saved every month<\/span><\/p>\n<\/li>\n
- \n
100% up-to-date information for all event information<\/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=”{}” sticky_enabled=”0″]<\/p>\n
Latitude59 organizers now have a fully automated events management solution where they can easily see how many events and attendees they need to organize and manage. They now save around 380 hours thanks to no longer needing to manually input and update the events information themselves. As a result, what was once a very stressful, high-pressure week, is now a smooth process thanks to Sheetgo.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cWe needed a way to improve managing the roundtable events, even before the registration process. We now have truly reliable insights to organize events that people actually want.\u201d <\/span><\/p>\n
Sally Hill | Responsible for Roundtables, Latitude59<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]With streamlined communication, real-time updates and centralized data, the efficiency and quality of event management has majorly increased. Moreover, Sheetgo has used the existing tools and processes they already had, optimizing these in a way that not only saved them a lot of money, but also made their work a lot more simple. This tailored solution is also extremely scalable, so it will grow alongside Latitude59.[\/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\/2023\/01\/latitud59-logo.webp” alt=”Untitled Group logo” title_text=”latitud59-logo” align=”center” _builder_version=”4.18.1″ _module_preset=”default” width=”200px” max_width=”200px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]Latitude59 is the flagship digital technology and entrepreneurship event hosted annually in Tallinn, Estonia. It offers 99% of government services online and an e-residency program, allowing non-Estonians to run a business online from anywhere in the world.
\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=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]Estonia<\/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=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” width=”85%” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]https:\/\/latitude59.ee\/<\/span><\/a>[\/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.18.1″ _module_preset=”default” global_colors_info=”{}”]Industry<\/strong>
\nTechnology<\/span>[\/et_pb_text][et_pb_text _builder_version=”4.18.1″ _module_preset=”default” global_colors_info=”{}”]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\/2023\/01\/google-forms.webp\")
Google Forms<\/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\/06\/icon-filter.webp\")
Filter<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-split.png)
Split<\/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":"
Latitude 59: Automated events management workflow for European tech event platformSheetgo 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, Latitude59 now save around 380 hours of work per year using a custom workflow that connects their user’s […]<\/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-28340","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/28340","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=28340"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/28340\/revisions"}],"predecessor-version":[{"id":260758,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/28340\/revisions\/260758"}],"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=28340"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/difl_page_category?post=28340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- <\/span>\n
- <\/span>\n
- <\/span>\n