How to Create an Online Store Using Store.Link with Google Sheets

In today’s digital era, building an online store can seem like a daunting task, especially for those who lack technical expertise. However, thanks to tools like Store.Link, you can easily convert your Google Sheets into a fully functional online store. This tutorial will guide you through the steps to create an online store, manage products, handle orders, and even integrate payments, all using Google Sheets.

What is Store.Link?

Store.Link is an innovative tool that allows you to create an e-commerce store directly from a Google Sheet. Whether you are a small business owner or just starting out, this tool eliminates the need for a web developer by automating the entire process. With Store.Link, you can create and manage your store in a matter of minutes.

Getting Started: Install the Store.Link Add-on

1. Install the Add-on:
   To begin, you need to install the Store.Link add-on from Google Workspace. Simply log into your Google account and install the add-on.

2. Create a New Google Sheet:
   Once installed, create a new Google Sheet by visiting sheet.new. Name it something like “Annie’s Store” to get started.

3. Launch the Store.Link Add-on:
   In your newly created sheet, go to Extensions → Store.Link → Start from Template. Select a template based on the type of products you plan to sell (e.g., Electronics).

4. Customize Your Store:
   Store.Link will generate two sheets: one for Products and the other for Orders. You’ll be prompted to name your store, select a currency (over 120 options available), and decide how you want to receive orders (e.g., WhatsApp).

Setting Up Your Store

Once your sheet is set up, the next step is to add product information. The following columns will be automatically created in the Products sheet:

• Product Name

• Price (actual and discounted)

• Description

• Category

• Stock Quantity

• Product Availability

• Thumbnail

• Additional Images

Here’s how you can start adding your products:

1. Add Product Information

For example, let’s add a MacBook Air:

• Product Name: MacBook Air

• Price: $999

• Discounted Price: $899

• Description: [Your MacBook description here]

• Category: Electronics

• Color: Silver

• Brand: Apple

• Stock: 5

2. Upload Product Images

• Thumbnail: To upload an image, go to Extensions → Store.Link → Upload Image. Select your image file and wait for it to upload.

• Additional Images: You can upload more images using the same process.

Viewing Your Store

After adding a product, you can view your store by clicking on the Publish button in the add-on. This will generate a live store URL based on the template you’ve chosen. Initially, you will see the default template, but you can make it your own.

Customizing Your Store’s Design

Store.Link allows you to customize the following:

1. Header and Logo:

   • Upload your store’s logo to replace the default one.

   • Add a store name and a catchy tagline if needed.

2. Banner Section:

   • Customize your store’s banner and subtitle.

   • You can also disable the banner if you prefer.

3. Product Cards:

   • Change the call-to-action button text (e.g., “Add to Cart” or “Buy Now”).

   • You can choose between a detailed product page or a simplified view.

4. Filters:

   • Add product filters to allow customers to sort by Price, Color, or any other attribute.

Advanced Features: Product Variants and More

Store.Link also supports product variants, such as different sizes, colors, or models.

Adding Variants:

For example, if you are selling iPhone 13 in two colors (Blue and Black), you can list the same product multiple times, changing only the variant-specific information.

1. In your Google Sheet, create a row for the iPhone 13 in Blue and another for Black.

2. Add variant-specific details like price and stock count.

3. Go to Store Settings → Variants and ensure the Color column is selected as a variant.

Once you refresh your store, your iPhone 13 listing will display both color variants, with the appropriate pricing and stock levels.

Adding More Product Images:

To add more than two product images, simply create additional columns titled Image 3, Image 4, etc., and upload the images as needed.

Managing Orders

As customers place orders on your store, the details are automatically recorded in the Orders sheet. This includes:

• Customer Name

• Email

• Phone Number

• Items Ordered

• Order Status

You can track and manage your inventory through the Stock Quantity column, which will update automatically as orders are placed.

Integrating Payments

Store.Link allows you to accept payments through PayPal or Stripe:

1. Set Up PayPal: Provide your PayPal email address, and customers can pay using PayPal.

2. Set Up Stripe: If you have a Stripe account, enter your Publishable Key and Secret Key to accept credit or debit card payments.

Once payments are enabled, your customers can choose between Cash, PayPal, or Card as their payment method during checkout.

Checkout Customization

Store.Link also offers checkout customization features:

• Custom Form Fields: Add extra questions (e.g., “Is this a gift item?”) in the checkout process.

• Order Summary: The customer will see an order summary, including the items they purchased and the total amount.

If you prefer a more visual step-by-step guide, you can watch the complete tutorial video below. In this video, I walk you through every detail of creating your online store using Store.Link and Google Sheets, from setup to customization.

Translation and SEO

1. Translation: Store.Link allows you to translate your store into different languages. You can manually translate product descriptions and checkout fields to reach a wider audience.

2. SEO Optimization: To ensure your store ranks well in search engines like Google, you can add a Meta Title, Meta Description, and Meta Image. These elements help your store appear in search results.

Sharing Your Store

Once your store is live, you can share it with others using the URL or generate a QR code for easy access.

Conclusion

Store.Link makes it simple to build an online store using Google Sheets. Whether you are selling electronics, clothing, or groceries, you can set up a fully functional e-commerce platform without any coding knowledge. With its ease of use, product management features, and payment integration options, Store.Link is the ideal solution for small business owners and entrepreneurs looking to go online quickly and efficiently.