The moment it happens

Log feedback in Excel on OneDrive and get an email

Each feedback submission becomes a row in your Excel workbook and you get an email with what was said.

Runs: The moment it happens
Apps: OneDrive, Outlook
AI: Not needed
Access: Files.ReadWrite, Mail.Send

Send this to your assistant

Create a ClickRuntime automation: when someone submits my feedback form, add a row to the Feedback table in my OneDrive workbook and email me the response from Outlook.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

A training company collects feedback after every course. Responses sit in the form tool, and someone exports them to Excel each month to work out averages, by which time any complaint is weeks old.

Adding each response to the workbook as it arrives keeps the numbers current, and an email for each one means a poor rating can be followed up while the course is still fresh in everyone's mind.

What you get out of it

Workbook always current
Charts and averages in Excel update as responses come in. No monthly export.
Hear about problems quickly
Each response arrives in your inbox, so a low score or a complaint can be followed up the same day.
Data you own
Responses live in your own OneDrive workbook. You can share, filter and chart them however you like.
Works with any form tool
Any form that can send a webhook works, so you can keep the one you have.

How it works

What happens, step by step

Your feedback form sends each response to ClickRuntime.
A new row is added to the table in your Excel workbook on OneDrive.
You get an email from Outlook with the rating and comments.

Before it runs live

Connect OneDrive
Connect Outlook
Paste your automation's link into the other app's webhook settings

What you get

RunsThe moment it happens

Log feedback in Excel on OneDrive and get an emailjust nowSucceeded

Email · New feedback (2/5)From: Lee at Northwind. The venue was great but the workbook links were broken.

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Act only on the items that match your own rules, and skip the rest
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other OneDrive and Outlook steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

log_form_feedback_to_an_excel_file_on_onedrive_with_an_outlook_notice.pyexample

GRAPH = "https://graph.microsoft.com/v1.0"
from datetime import datetime, timezone
from clickruntime import on_event, credentials, http

BOOK = "/me/drive/root:/Feedback/feedback.xlsx:/workbook"
ME = "me@example.com"

@on_event
def handle(event):
    f = event.json or {}
    h = {"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}
    row = [datetime.now(timezone.utc).strftime("%Y-%m-%d %H:%M"), f.get("name", ""), f.get("rating", ""), f.get("comments", "")]
    http.post(f"{GRAPH}{BOOK}/tables/Feedback/rows/add", headers=h, json={"values": [row]}).raise_for_status()
    text = f"Rating: {row[2]}\nFrom: {row[1] or 'anonymous'}\n\n{row[3]}"
    mail = {"message": {"subject": f"New feedback ({row[2]}/5)", "body": {"contentType": "Text", "content": text},
                        "toRecipients": [{"emailAddress": {"address": ME}}]}}
    http.post(f"{GRAPH}/me/sendMail", headers=h, json=mail).raise_for_status()
    return {"rating": row[2]}

FAQ

Common questions

Can it send the thank-you to the respondent instead?

Yes. If the form collects an email address, it can send them a thank-you from your Outlook as well as, or instead of, notifying you.

What if I add a question to the form?

Add a matching column to the Excel table and include it in the row. Older rows simply leave it blank.

Does the workbook need to be closed?

No. Rows are added through Excel Online, so it works while you or others have the file open.

What permissions does it need?

Files.ReadWrite, Mail.Send. Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run for each event the app sends.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Every 15 minutes