Skip to content

When Apps Script triggers aren't enough

Apps Script is the quickest way to automate inside Google Sheets and Docs. It gets harder when a job runs on a timetable that must be exact, receives webhooks that need a signature check, or calls services outside Google. ClickRuntime runs those as Python, and still reads and writes your Sheets.

Get help moving from Google Apps Script

  • Hit the daily trigger runtime quotahandled
  • Accept a daily trigger that fires sometime within an hourhandled
  • Receive webhooks without seeing their headershandled
  • Squeeze state into 9 KB propertieshandled
→ Describe the job in your AI assistant

Why people move Apps Script triggers to ClickRuntime

  • Webhooks you can verify

    Trigger links pass the request headers to the script and check Stripe, GitHub, Shopify, Typeform and HMAC signatures for you.

  • Runs at the time you set

    A daily schedule runs at that time in your timezone, not somewhere within an hour.

  • Any app with an API

    No connector to wait for. If an app has an API or sends webhooks, an automation can use it.

  • Still works with Sheets

    Connect Google with only the spreadsheets you pick, and the script reads and writes them through the Sheets API.

  • State and versions built in

    Each automation remembers what it saw last time. Every change is a new version, and a failed deploy never replaces the working one.

  • Built from the assistant you already use

    Ask in ChatGPT, Claude, Cursor or any MCP client. It writes the automation, tests it and fixes it.

A 14-step workflow becomes one sentence

Workflow builders make you place every trigger, filter, branch and formatter yourself, then fix it when one breaks. Here you describe the result and your assistant writes the code.

The usual wayStep 9 failed
  • 01 Shopify trigger
  • 02 Filter > $500
  • 03 CRM: find
  • 04 Router
  • 05 Path A: new
  • 06 Path B: existing
  • 07 Formatter
  • 08 AI: summarise
  • 09 Text parserfailed
  • 10 Slack: post
  • 11 CRM: add note
  • 12 Error handler
  • 13 Set variable
  • 14 Delay 2 min
14 steps3 branches6 field mappings
With ClickRuntimeLive

“When a Shopify order over $500 comes in, check the customer in HubSpot. If they're new, post to #sales with an AI summary of the order. Otherwise add a note to their contact.”

Here's the automation. It runs on each new order.

Large order routingLive
When
Shopify · new order (webhook)
Uses
Shopify, HubSpot, Slack and AI

Google Apps Script and ClickRuntime compared

See ClickRuntime pricing

TopicGoogle Apps ScriptClickRuntime
Made forScripts inside Google Workspace filesJobs on a schedule or webhook, across any apps
LanguageJavaScriptPython 3.11
SchedulesTime-driven triggers; a daily trigger fires within a one-hour windowEvery 5 minutes or slower, at the time you set
Run length6 minutes per executionA time limit per run
Daily limitsTrigger runtime 90 minutes a day (consumer) or 6 hours (Workspace); URL Fetch 20,000 or 100,000 calls a dayMonthly runs per plan
WebhooksWeb app doPost; the event object doesn't list request headers, so signatures can't be checkedTrigger link with headers and signature checks
StateProperties: 9 KB per value, 500 KB per storeState and counters built into every automation
CostIncluded with a Google account250 runs a month free; paid plans from $9 for 2,000 runs

Google Apps Script or ClickRuntime?

Choose Google Apps Script when

  • The logic lives inside a Sheet or Doc: custom functions, menus, onEdit triggers, formatting.
  • It only touches Google services and fits the quotas. Apps Script is included with your account.
  • You need the script to run as each user inside their own document.

Choose ClickRuntime when

  • You receive webhooks from Stripe, Typeform or GitHub and want them verified.
  • The job calls services outside Google, or needs Python packages.
  • Timing matters, or the job runs into daily trigger or URL Fetch quotas.

Move from Google Apps Script in five steps

Your assistant does the rewriting, you check the result.

  1. Step 1Pick triggers and web apps, not sheet logicMove time-driven triggers and doPost web apps. Keep custom functions, menus and onEdit triggers in Apps Script.
  2. Step 2Ask your assistant to rebuild itConnect ClickRuntime to ChatGPT, Claude or Cursor, paste the Apps Script code and say what should happen. It saves a draft you can read before anything runs.
  3. Step 3Connect Google and save keysConnect your Google account in the ClickRuntime dashboard and pick only the spreadsheets the automation should open. Save other services' keys as secrets. Keys never go into the chat.
  4. Step 4Test itYour assistant turns the automation on, runs it once or sends a test event, and fixes it until the run succeeds. Run both side by side for a few days if you like.
  5. Step 5Switch the old one offReplace the web app URL in Stripe or the sending service with the trigger link, then delete the trigger or web app deployment in Apps Script.
ClaudeClickRuntime connected
Code.gs
This Apps Script receives Stripe webhooks into a sheet. Move it to ClickRuntime.
It appends a row per checkout. Here it is on a trigger link, with the Stripe signature checked.
  • Stripe payments to sheetTrigger link · Ready
  • Daily report emailEvery day 7:00 · Ready
  • Custom menu in the sheetStays in Apps Script · Needs a key

One job, moved from Google Apps Script

Code.gsbefore
1// Web app deployed as "Anyone"; Stripe sends checkout.session.completed here
2function doPost(e) {
3const body = JSON.parse(e.postData.contents); // no headers: Stripe-Signature can't be checked
4const s = body.data.object;
5SpreadsheetApp.openById("SHEET_ID").getSheetByName("Payments")
6.appendRow([new Date(), s.customer_details.email, s.amount_total / 100, s.currency]);
7return ContentService.createTextOutput("ok");
8}
After: the prompt.txt

“Move my Apps Script webhook to ClickRuntime: when Stripe sends checkout.session.completed, check the signature and add a row to the Payments tab of my sheet with the date, customer email, amount and currency.”

google_apps_script.pyafter
1from google.oauth2.credentials import Credentials
2from googleapiclient.discovery import build
3from clickruntime import on_event, credentials, log
4 
5SHEET_ID = "your-spreadsheet-id"
6 
7@on_event
8def handle(event):
9if not event.is_verified:
10log.warning("Stripe signature check failed")
11return {"skipped": "bad signature"}
12if event.json.get("type") != "checkout.session.completed":
13return {"skipped": event.json.get("type")}
14s = event.json["data"]["object"]
15row = [event.received_at, s["customer_details"]["email"], s["amount_total"] / 100, s["currency"].upper()]
16token = credentials.connection("cr_google_sheets_picked", "work")
17sheets = build("sheets", "v4", credentials=Credentials(token), cache_discovery=False).spreadsheets()
18sheets.values().append(spreadsheetId=SHEET_ID, range="Payments!A:D",
19valueInputOption="USER_ENTERED", body={"values": [row]}).execute()
20return {"added": s["id"]}

Where each Google Apps Script piece goes

In Google Apps ScriptIn ClickRuntime
Time-driven triggerAutomation with a schedule
Web app doPostTrigger link, with headers and signature checks
PropertiesServicestate.get and state.set
UrlFetchApphttp.get / http.post
SpreadsheetAppThe Sheets API with a Google connection to the files you pick
MailAppnotify.email_me, or Gmail's API
Executions logRun log with output and errors, and an email when a run fails

Send us your Apps Script code. We'll help you move it.

Email it with a line about what each one does. A person reads it, tells you how it maps to ClickRuntime, and helps until your automations are running.

Email your Apps Script code

Leave out API keys and other secrets.

Email hello@clickruntime.com

What you can add next

Once the first job is moved, these are the changes people usually ask for next. Each is one message to your assistant, not a new service to set up.

  • Built-in AI

    Add a column saying what each customer bought, in plain words, from the line items

    “Change my Stripe payments automation so it adds a short plain description of what was bought in a new column.”
  • Multi-step logic

    Handle refunds too, by marking the matching row

    “Change my Stripe payments automation so a charge.refunded event marks the matching row as refunded.”
  • Any app or API

    Post payments over $1,000 to Slack

    “Add to my Stripe payments automation: post payments over $1,000 to #sales in Slack.”
  • Memory between runs

    Keep a running monthly total without reading the sheet

    “Change my Stripe payments automation to keep a monthly revenue total and include it in a Slack post on the 1st.”
  • Schedules

    A Monday email with last week's revenue by currency

    “Add to my Stripe payments automation: every Monday at 8, email me last week's revenue by currency.”
  • Trigger links

    Take Shopify orders into the same sheet

    “Add a trigger link to my payments sheet automation for Shopify orders/paid, with its signature checked, and add those rows too.”

Can Apps Script verify Stripe webhook signatures?

Apps Script's doPost event object doesn't include the request headers, so the Stripe-Signature header isn't available to check. ClickRuntime passes headers to the script and can check Stripe signatures for you.

Can ClickRuntime still update my Google Sheets?

Yes. Connect Google and pick the spreadsheets the automation may open; the script uses the Sheets API with that connection.

Is ClickRuntime better for everything Apps Script does?

No. For custom functions, menus and edits inside a Sheet or Doc, Apps Script is the right tool and costs nothing extra.

Do I need to know how to code?

No. You describe what should happen and your AI assistant writes, tests and fixes the Python. You can read every version in the ClickRuntime dashboard.

What does ClickRuntime cost?

The free plan includes 250 runs a month with webhooks, code and AI. Paid plans start at $9 a month for 2,000 runs, with unlimited users. A scheduled check that finds nothing new and sends nothing isn't counted.

Will you help me move my scripts?

Yes. Email hello@clickruntime.com with what each scripts does, or the Apps Script code or config, and we'll help until it's running. Never send API keys or other secrets.

Move your first Google Apps Script automation today

Free plan. No credit card.

Server URLhttps://clickruntime.com/api/mcp