Home › Automations › Send a feedback poll when a form response is received in Google Sheets
Trigger: Form responseAction: Send poll

Send a feedback poll when a form response is received in Google Sheets

Close the loop with respondents automatically. The moment a form response lands, Sheet Automation sends a short feedback poll and records the rating back in your sheet.

Add to Google Sheets — free See the template

Installs in 30 seconds · No credit card · Works inside Google Sheets

★★★★★ 4.9/5 · 500+ reviews · 300,000+ installs

What it does

This automation watches your form-linked sheet for new responses. When one arrives, it sends a feedback poll (e.g. a satisfaction rating) to the recipient and writes their answer back into a column. It’s the easiest way to measure CSAT or gather quick follow-up feedback, with no scripts.

How to set it up

  1. Install Sheet Automation from the Google Workspace Marketplace and open it from your form’s response sheet.
  2. Choose a column to store the poll result, e.g. column H.
  3. Pick the “Send a feedback poll when form response is received” template, set the question and result column.
  4. Save, then submit a test response — the poll is sent and the answer lands in the result column.

The ready-made template

Send a feedback poll when form response is received — Trigger: a form response is received → Action: send a rating poll and record the answer in a column. Edit it live below:

Loading preview…

How to use this template

The builder above is a live preview of this automation. To run it in your own spreadsheet:

  1. Click Add to Google Sheets to install Sheet Automation (free).
  2. Open it from your sheet: Extensions → Sheet Automation → Open.
  3. Open the Templates tab and choose “Send a feedback poll when form response is received”.
  4. Adjust the fields to match your data, then click Save.
  5. Trigger it once to confirm the automation runs.

FAQ

What kind of questions can I ask?
This template uses a rating question. You can change the title and add more questions in the poll action.
Where do the answers go?
Each question writes its answer into the result column you set (e.g. column H), on the response’s row.
Who receives the poll?
The recipient you set in the template — typically the person who submitted the response or a column that holds their email.
Do I need Zapier or Make?
No. Sheet Automation runs inside Google Sheets, so there’s no third-party connector to pay for or maintain.

Related automations

Create a unique ID for a form response Send an email when a column is updated Export a sheet and send it as an attachment Send a reminder when a due date arrives