Manual Orders - Apps Script

What it does

Manual Orders - Apps Script.txt receives checkout data from Manual Orders and writes each order into your Google Sheet.

It can also send a simple owner notification email if Notify Owner is turned on inside the component.

Before you start

You need:

• A Google account

• A Google Sheet for your orders

• The Manual Orders component already added to your Framer project

• The Apps Script text file (Click on Apps Script button in the plugin and it will be copied to your clipboard)

This script uses Google Apps Script and GmailApp, so it sends from the Google account that owns the script.

Steps to set up the Apps Script

Step 1

Create or open the Google Sheet where you want your orders to be stored.

Step 2

Rename the tab in the Google Sheet to "Orders" where you want the orders to populate.

Step 3

Open Extensions > Apps Script inside that Sheet.

Step 4

Paste the code from Apps Script into the Apps Script editor. (Click on Apps Script button in the plugin and it will be copied to your clipboard)

Step 5 (optional)

If you want a fallback owner email, fill OWNER_EMAIL. If not, leave it empty.

Step 6

Run testWrite() once from Apps Script and approve the permissions for Sheets and Gmail.

Step 6

Deploy the script as a Web App. Set it to execute as you, and make sure access is allowed for anyone.

Step 7

Copy the /exec deployment URL and paste it into Apps Script URL inside Manual Orders.

How it works

When a customer checks out through Manual Orders, the component sends the order data to this deployed script.

The script writes the order into Google Sheets, creates any missing columns automatically, and adds an Order Status dropdown for the main order row.

If Notify Owner is enabled, it can also send a plain-text order alert to the owner email.

Common mistakes

Tab name isn't "Orders"

If the sheet tab name is different from the value inside CONFIG (default set to "Orders"), the script will fail when trying to save the order.

testWrite() was never run

If you skip the first test run, Google may not grant the required permissions yet, and live orders can fail.

The wrong deployment URL is pasted

Make sure you paste the final Web App /exec URL into Apps Script URL, not the editor link or the /dev test URL.

Expecting customer emails

This script does not send confirmation emails to customers. It only logs orders and optionally emails the owner. Use Auto Mail Orders or Pro Mail Orders if you want customer emails.

Quick setup checklist

1. Open a Google Sheet for orders.

2. Paste Manual Orders - Apps Script.txt into Apps Script.

3. Rename your desired tab to "Orders".

4. Run testWrite() and approve permissions.

5. Deploy as a Web App.

6. Paste the /exec URL into Apps Script URL in Manual Orders.