[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Company-picture-2.webp” alt=”Waterman Broadcasting” title_text=”Company picture 2″ _builder_version=”4.27.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.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Waterman Broadcasting needs to supply a wide variety of networks with accurate information that changes every single day.<\/p>\n
By using Sheetgo to help automate the consolidation and distribution process, they give over 40 unique users easy access to all the information they need while also saving $13,000 per year.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Efficient time slot management needs to be automated <\/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
- Waterman need to keep over 40 people, spread over 13 groups, up to date with their latest time slot information<\/li>\n
- Waterman\u2019s team of 20+ sales staff need real-time updates that ensure they can sell with optimal efficiency<\/li>\n
- An in-house solution based on a SQL script was in development, but a fully automated solution was needed to free the VP from time-consuming manual entry<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
With 20+ sales staff, 40 people to update daily and the need for 100% accurate programing information, Waterman needed a new approach to managing their time slot information.<\/p>\n
They had already begun to look into database queries and had identified the need for increased levels of automation if they were going to scale efficiently.<\/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=”{}”]<\/p>\n
\u201c<\/strong>Very happy with it! Sheetgo allowed me to do a lot of automation and streamline a process that gets a lot of information out very quickly and accurately to all of the people that use it. It’s a great utility.\u201d<\/b><\/p>\n
Gerry Poppe, VP\/CFO, Waterman Broadcasting<\/span><\/i><\/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
Waterman had identified the need to find a way to automatically populate Google Sheets at scale and went in search of a solution.<\/p>\n
They found Sheetgo via search and found everything they needed so didn\u2019t look further.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Connecting field teams with TV programming information using 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
- \u00a0Every 2 minutes, automations from Robocopy run to pull raw data from their internal server to DropBox<\/li>\n
- Sheetgo then automatically takes DropBox data, shares it with a Google Sheets file and shares across 13 distinct groups<\/li>\n
- Sheetgo Filter features to show specific users exactly what they need to see, and nothing more<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
By using Robocopy to start the automation process every 2 minutes, Waterman Broadcasting are able to ensure that their data truly is real-time.<\/p>\n
Sheetgo provides the missing link that takes data from DropBox, moves it into Google Sheets, and then provides unique users with the subset of the master data they need to fulfill their role.<\/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=”{}”]<\/p>\n
\u201c<\/strong>Perfect tool for updating Google Sheets automatically without the need for constant supervision!\u201d<\/b><\/p>\n
Gerry Poppe, VP\/CFO, Waterman Broadcasting<\/span><\/i><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Sheetgo allows Waterman Broadcasting to not only automate and save $13,000 a year in manual tracking, but to also automatically shift schedules based on the very latest program changes. Multiple spreadsheets that were prone to developing and propagating errors were put to one side to be replaced with a single master location capable of updating in real time.<\/p>\n
The result gives over 40 professionals instant access to a schedule that is never more than 60 minutes old. <\/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
Centralized order data distribution for paperless tracking <\/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
- Sheetgo takes programing data across 20+ newscasts, network specials and syndicated shows and updates automatically based on programing shifts<\/li>\n
- Automatic updates save the company $13,000 per year, and save the VP manual entry that scales exponentially with company growth<\/li>\n
- Sheetgo is able to deliver a 9x ROI, allowing them to better allocate their budgetary resources<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Sheetgo deployment has automated the scheduling process and ensured more than 40 professionals are always working with data that\u2019s no more than 60 minutes old.<\/p>\n
The move has saved them $13,000 a year through reduced manual entry and duplication of effort while also eliminating manual errors that are hard to track across time. <\/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=”{}”]<\/p>\n
\u201cIt’s been a big utility. We’ve created a sequel extract and then Sheetgo grabs that extract file, that Excel file, and populates Google Sheets where all the rest of the magic is done to get it to the people that need it.<\/strong>\u201d<\/b><\/p>\n
Gerry Poppe, VP\/CFO, Waterman Broadcasting<\/span><\/i><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Sheetgo has allowed Waterman Broadcasting to make use of an automated solution that provides everyone with the latest time slot information. By automatically updating when a sale is made, or a program is moved, their new master file provides a central location from which everyone can work.<\/p>\n
They now have a flexible, accurate and highly scalable tool that can be used to support future expansion and growth.<\/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\/06\/Company-logo-2.webp” alt=”Waterman Broadcasting logo” title_text=”Company logo (2)” 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
Waterman Broadcasting covers a daily TV program listing of 20+ newscasts, network specials and a wide variety of syndicated programming. They need a simple way to provide each network with a set of information that changes on a daily basis.<\/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″]United States<\/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.17.4″ _module_preset=”default” width=”85%” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]https:\/\/www.water.net\/<\/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.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Industry<\/strong>
PR & Communications
<\/span><\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _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\/06\/icon-excel.webp\")
Excel<\/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":"
Waterman Broadcasting: Connecting field teams with TV programming for time slot management 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.Waterman Broadcasting needs to supply a wide variety of networks with accurate information that changes every single […]<\/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-227599","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/227599","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=227599"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/227599\/revisions"}],"predecessor-version":[{"id":260765,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/227599\/revisions\/260765"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/6600"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=227599"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/difl_page_category?post=227599"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}