[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Company-picture-1-1.webp” alt=”BizLink Group” title_text=”Company picture 1 (1)” _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.17.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n
Bizlink is a leading manufacturer of electrical and electronic products that relies on a large amount of real-time date to drive their QA processes.<\/p>\n
By using Sheetgo to move data between production stages, Bizlink is now able to streamline their hourly automation and save $8,000 per year in the process. This allows them to drastically improve the efficiency and accuracy of their QA processes.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Passing real-time generated data between multiple Google Sheets<\/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
- Manual entry is not practical due to the large amount of data produced: 90,000 updates per month<\/li>\n
- Data needs to be passed accurately and efficiently at scale to minimize downtime<\/li>\n
- Expansion to future production lines requires a flexible and scalable reporting solution capable of handling hourly automation<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Bizlink had a system in place where they would pass data between multiple Google Sheets, with each sheeting defining a discrete milestone in the production process. They had identified the need for efficient automation to ensure their dashboards and reporting functions updated in real time.<\/p>\n
Formulas were checked and audited to ensure data was being moved correctly, but their legacy solution was unable to keep pace with their speed of expansion and desire for something with greater future-proofed flexibility.<\/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<\/span>We are a factory and we have huge data to handle every month. As such a stable and reliable platform is the most important need.\u201d<\/b><\/p>\n
Desmond Lee, QA Manager, BizLink<\/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
BizLink wanted a readily scalable, flexible and uncompromisingly accurate solution that would allow them to easily move real-time data between an ever-growing library of Google Sheets. They didn\u2019t just want something that would reduce downtime with better data display and faster reporting \u2014 they needed a solution they could adapt to drive the QA of future production lines.<\/p>\n
BizLink reached out to Sheetgo for input to create a scalable solution that could be accessed from both desktop and mobile devices without loss of functionality or usability.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Smart data migration 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
- Hourly automation moves data between Google Sheets<\/li>\n
- Sheetgo interfaces with preparatory formulas to transfer data<\/li>\n
- Custom dashboards and reports automatically updated<\/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 Sheetgo, BizLink is now able to seamlessly move data between every Google Sheet in their QA pipeline on an hourly basis. They are able to interface with data formulas, different data types and populate their custom dashboards and reports without delay.<\/p>\n
Everything is powered by hourly updates that ensure every data point is captured and utilized.<\/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<\/span>I use Sheetgo combined with Appsheet to create a mobile manufacturing platform to run products. Engineers use mobile phones to check, review and sign off and submit to this database.\u201d<\/b><\/p>\n
Desmond Lee, QA Manager, BizLink<\/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 BizLink to actively improve product quality by ensuring real-time data is used to inform smarter reporting and faster dashboard updates.<\/p>\n
This ensures real-time data is never bottlenecked and downtime is minimized now that every engineer can access the key information they need from their choice of mobile or desktop devices.<\/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” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n
Securing a $8,000 save for smarter growth<\/b><\/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” hover_enabled=”0″ border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n
- \n
- $8,000 saving per year<\/li>\n
- Reduced downtime for enhanced efficiency<\/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
By securing an $8,000 annual saving, BizLink\u2019s use of Sheetgo improves the budgetary efficiency of their production lines, as well as enhancing the output.<\/p>\n
Real-time data is more effectively handled and passed between Sheets, delivering reduced downtime while securing 100% up-to-date dashboards that can be viewed on any device. <\/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<\/span>Thankfully, Sheetgo provides us with a three-year contraction period that allows us to plan long-term.\u201d<\/b><\/p>\n
Desmond Lee, QA Manager, BizLink<\/span><\/i><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Thanks to Sheetgo, BizLink no longer has to try and produce their own in-house solutions to the problem of passing a continuous stream of data between a variety of unique Google Sheets.<\/p>\n
They have improved production efficiency while increasing the utility of reporting, and the three-year contraction period offered is allowing them to plan longer term for the first time.<\/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-1.webp” alt=”BizLink logo” title_text=”Company logo (1)” 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
BizLink is a manufacturer of electrical goods like household appliances, medical equipment, and cables. They drive the QA of a number of their production lines purely with Google Sheets and produce a large amount of real-time data.<\/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.17.4″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]<\/p>\n
USA\/Malaysia<\/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|||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.bizlinktech.com<\/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>
Electrical & Electronic Manufacturing<\/p>\n<\/span><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _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\/2022\/06\/icon-query.webp\")
SQL Filter<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-split.webp\")
Split<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/network-view.webp\")
Network view<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
BizLink Group: Automated reporting and dashboard updates delivered by 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.Bizlink is a leading manufacturer of electrical and electronic products that relies on a large amount of real-time date to drive […]<\/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-227577","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/227577","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=227577"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/227577\/revisions"}],"predecessor-version":[{"id":260764,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/227577\/revisions\/260764"}],"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=227577"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/difl_page_category?post=227577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}