Latitude59

“As 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”

Kadri Sundja, Head of Programme and Mentoring | Latitude59

The organization

Latitude59 is the flagship digital technology and entrepreneurship event in Estonia. The small Baltic nation, which dubs itself “the world’s first digital society”, boasts the highest number of startups per capita in Europe. It has an impressive online ecosystem with 99% of all government services online, and an e-residency program that allows non-Estonians to run a business online from anywhere in the world while accessing Estonian services. 

Hosted annually in Tallinn, Latitude59 brings together startups, founders, angel investors, VC partners, lawyers, politicians, and others working in the digital economy.

The challenge

The organizers of Latitude59 were looking for a way to streamline their data and event management processes. With over 100 roundtable discussions taking place online over several days, the team turned to Sheetgo to help them quickly manage large volumes of dynamic data.

Startup ticket holders register their interest in roundtable events via Google Forms. The team needed a way to filter this data by schedule, approve registrations, and create attendance lists.

estonia-google-sheets-event-planning

It was the very first time we ran online roundtables. In four days, we had around 120 of these sessions taking place simultaneously”

latitude-59-automated-event-planning

The solution

Sheetgo Partner Ernesto Suarez of Wedoops and Sheetgo’s automation expert Eugenia Langen helped the Latitude59 team build a custom workflow to manage their events data in Google Sheets.

By combining Sheetgo connections and filters with QUERY, ARRAY, SPLIT, and VLOOKUP functions, they created a streamlined workflow that eliminated hours of manual work from the event management process.

Automated event planning

Responses from Google Forms flow into an Applications sheet. From there, data is pulled into an editing file along with information on scheduled roundtables. As a result, the team can quickly see who has applied for which event and which topics delegates are interested in.

In the next stage of the workflow, edited data from the central file is sent to an Approvals spreadsheet.

This enables event organizers to see how many events each delegate has signed up for and approve applications.

Lastly, data is sent to multiple Daily Schedule files using a Distribute connection. This enables the team to see who is attending which event at which time, and filter information by category and start time.