How to Link a Real-Time Product List to an Imweb Homepage Using Google Sheets

The existing method of sharing Excel files had the inconvenience of having to resend the file every time the content changed. Google Sheets overcomes this limitation: simply sharing the link at the top makes the content shareable in real time. Linking it to a homepage is also very simple; you just connect the Google Sheets link to a specific button or text.

This could be confirmed directly in a demonstration where the packaging quantity of a product was changed: as soon as the sheet was modified, the changed content appeared immediately on the homepage as well.

Google Sheets lets you set access rights through its sharing feature. Owners and editors can edit the content and are typically the managing staff. Meanwhile, the 'Viewer' under general access lets any user on the internet who has the link view the content, allowing even non-logged-in users to browse the information efficiently.

The product list implemented through Google Sheets integration is presented cleanly as a web page, with strengthened user-convenience features. Entering a specific size in the spec search box instantly finds related products, and an estimate inquiry function is also included. Additionally, when you want to print the content, you can press the spec sheet print button to print directly from the print screen.

To create a new product list, go to Google Drive and press the plus button. Through this button you can select a document that reflects changes in real time and can be shared with specific people or everyone. After creating the document, you can click the share button to invite specific users or control link access, sharing information only with the people you want.

By default, the viewer permission lets everyone with the share link only view the screen. However, if this viewer permission is changed to editor permission, every person with the link can edit the file's content, so this requires caution. Granting edit permission to an unspecified public can pose security risks, so using the viewer mode for simple browsing is recommended by default.

The Google share link was passed to Claude, and a rough, abstract question was posed to derive a design plan. Claude performed detailed work such as removing unnecessary elements and specifying design colors and fonts, and it also resolved issues like printing errors, helping produce the code efficiently.

Accessing the IF design mode, the existing product list section was checked, and after right-clicking and setting the button, it was configured to move to a specific page. Afterward, a new page was added through menu management, and pasting the Claude-generated source into that page's code settings completed the link.

With these settings, the top logo and category section can be removed, so the page can be organized to focus on the product list itself.

Before useful AI tools like Claude appeared, implementing such a page directly on a homepage required a lot of manual work, such as designing and coding the image ratios of each zipper bag one by one. Now, if you have the idea, AI can make these complex tasks easy to implement, dramatically changing the environment for building and managing homepages.

The goal of this class is to build a homepage that practically helps the student's business, and to help them directly operate an internal management system using AI.

Rather than gathering many students for an online lecture, Hama Classroom pursues a structure of small, elite groups of 3 per class, offering in-depth conversation and practical help. It currently runs in parallel with a 6-hour offline class at its Yongin campus and 30 days of online coaching.

The instructor has mainly worked in branding and marketing for small businesses and SMEs, rather than in web agency experience. Drawing on real business experience such as Wadiz crowdfunding and participation in domestic and international trade shows, the instructor shares practical advice and know-how with students. Before enrolling, a preliminary phone or KakaoTalk consultation is held to understand the student's needs, and then the final decision is communicated.