mobile-orders

Glowbom Store

Glowbom Store can help you set up a simple e-commerce app connected to a Google Sheet. No programming skills required.

Get Started

Create your own store without code.

Use Google Sheets to collect orders.

Use PayPal to collect payments.

Here's how it works...

Step-by-Step Setup Instructions

Step 1

Open Glowbom and create an account if you haven’t done it already. It’s free and takes 30 seconds.

Step 2

Press + New Project at the top right corner:

Step 2

Or press the little mic button and say: “Create an app.”

Step 2

Step 3

Choose Store and press Select:

Step 3

Or say: “Create a store app.”

Step 4

Enter the project name and press Create project:

Step 3

Or say: “Create a store app called…“ with the name of your project.

Step 5

To add and modify products, press the little pencil button:

Step 3

Or say: “Open an editor.”

Step 6

By default, you have 4 products. To add a new product, press the “+” button:

Step 3

To edit the product, press the little pencil button.

To remove the product, press the remove button.

To close the editor, press the cross button at the top center.

Step 7

Fill out the title, price, description, and image URL fields to add or edit the product:

Picture

And press the “Save” button.

Step 8

Press the “Play” button on the top right to run the project:

Picture

Or say: “Launch the project please.”

Press the “Stop” button on the top right to stop the project:

Picture

Or say: “Stop the project please.”

Step 9

To customize your store, open the project settings by clicking the small gear button on the bottom left:

Picture

You can choose your app color, collect name, phone, or shipping address, and also change the “thank you” message:

Picture

To collect orders using a Google Sheet, press the “Create Form” button.

Step 10

Make your own copy of “Store” Google Sheet by going to File->Make a copy:

Picture

Open the editor by going to Tools->Script editor:

Picture

Step 11

Clear everything inside the script window:

Picture

Copy a server script:

function doGet(e) {
  if (e.parameters.data) {
    var data = e.parameter.data;

    var ss = SpreadsheetApp.getActive();
    var sheet = ss.getSheetByName("Orders");

    var responses = data.split(';');

    if (responses.length == 5) {
      var elemens = [
        responses[0],
        responses[1],
        responses[2],
        responses[3],
      ];

      var answers = responses[4].split(', ');

      for (var i = 0; i < answers.length; i++) {
        elemens.push(answers[i]);
      }

      sheet.appendRow(elemens);

      var result = JSON.stringify({success: true});

      return ContentService.createTextOutput(result)
          .setMimeType(ContentService.MimeType.JSON);
    } else {
      var result = JSON.stringify({success: false});

      return ContentService.createTextOutput(result)
          .setMimeType(ContentService.MimeType.JSON);
    }
  } else {
    var result = JSON.stringify({success: false});

    return ContentService.createTextOutput(result)
        .setMimeType(ContentService.MimeType.JSON);
  }
}

Step 12

Paste the script code inside the editor and press Save:

Picture

Name the project and press Ok:

Picture

Step 13

Publish the script by pressing Publish->Deploy as web app…:

Picture

Choose Anyone, even anonymous in Who has access to the app and press Deploy:

Picture

Press Review Permissions:

Picture

Press Allow:

Picture

Copy Current web app URL:

Picture

Step 14

Paste the Current web app URL into Orders form link:

Picture

Run the project again and submit the shipping information:

Picture

The shipping information should appear in the Google Sheet:

Picture

Collecting Payments with PayPal

Create the PayPal.Me link and paste it into PayPal.me link to collect payments using PayPal:

Picture

Next Steps

Publish your app

GPT-3 product description generation

You can also use GPT-3 to generate a selling product description if you have an OpenAI account. Here’s how it works.

Feedback

If you have any questions or feedback, please let us know support@glowbom.com.

Upcoming updates

We are working on Glowbom 2.0. Firebase, Stripe, OpenAI, GitHub integrations, Unity game projects support, and more are coming soon.