Log form submissions from my inbox to a sheet
Minda adds each form submission, sign-up or survey answer that reaches your inbox as a row in your sheet. It is a ready-made task for the SI agent in Minda Super Intelligence. It runs when a new email arrives. It works with Gmail and Google Sheets. You fill in [form tool or sender] and [sheet link].
In Minda: Tasks → New → Browse tasks → Log form submissions from my inbox to a sheet. Minda Super Intelligence for Windows is coming soon.
- Data
Gmail- Google Sheets
- If none is, stop
- For each, read every field and add a row to…
- Before adding, look for the same email address…
- Then write a two-line summary of what came in…
What you get
Finds the submissions When new email arrives, it checks each one since the last run for a form submission, sign-up or survey answer.
A row in your columns It reads every field and adds a row with the columns your sheet already has, plus the date received and the email link.
No double rows Before adding, it looks for the same email address or submission id and skips it if it is already there.
Nothing overwritten It copies answers as written, leaves a cell blank when the form did not ask, and never overwrites an existing row.
Why use this?
Minda keeps your sheet current from the form emails you already get, so you do not copy answers by hand. It never replies to the person, and it ends with the rows added, the duplicates skipped and anything that looked like spam.
What it does
- When
- When a new email arrives
- Works with
- Gmail, Google Sheets
- For
- Operations, Marketers, Everyone
- You fill in
- [form tool or sender], [sheet link]
How it works
- WhenWhen a new email arrivesSaved as an hourly check: each run looks at what arrived since the last one
- Step 1Picks out form and survey emails
- Step 2Reads every field of each one
- Step 3Skips an email or id already added
- Step 4Adds a row with the date and link
- Step 5Writes a two-line summary for you
- ResultNew rows in your sheet and a summary
If none is, stop
For each, read every field and add a row to [sheet link] with the columns the sheet already has, plus the date received and the email link
Before adding, look for the same email address or submission id and skip it if it is already there
Then write a two-line summary of what came in for me
Finish with the rows added, the duplicates skipped, and anything that looked like spam
Rules it keeps
The agent follows these on every run.
Copy answers exactly as written
Leave a cell blank when the form did not ask it
Never reply to the person
Never overwrite rows already in the sheet
The full prompt
This is what the SI agent is asked to do. The parts in brackets are what you fill in.
When new email arrives, check each email since the last run: is it a form submission, a sign-up or a survey answer sent by [form tool or sender]? If none is, stop. For each, read every field and add a row to [sheet link] with the columns the sheet already has, plus the date received and the email link. Before adding, look for the same email address or submission id and skip it if it is already there. Then write a two-line summary of what came in for me. Rules: copy answers exactly as written; leave a cell blank when the form did not ask it; never reply to the person; never overwrite rows already in the sheet. Finish with the rows added, the duplicates skipped, and anything that looked like spam.
Who is it for?
Small business owners Your form tool emails you each answer and you want them all in one sheet.
Marketers running forms You collect sign-ups and survey answers and want them in rows without retyping.
Operations teams You track requests that arrive by form email and want a sheet that stays current.
Frequently asked questions
Does it reply to the person who filled in the form?
No. It never replies to anyone. It reads the email and adds a row.
How does it avoid duplicates?
It looks for the same email address or submission id in the sheet first and skips it if it is already there.
Does it change rows already in my sheet?
No. It never overwrites a row that is already there.
What if the form left a field empty?
The cell stays blank. It copies answers exactly as written.
What do I fill in?
The form tool or sender to look for, and your sheet link.
What do I get at the end?
The rows added, the duplicates skipped and anything that looked like spam, plus a two-line summary of what came in.
Run this task in the Minda app
In Minda: Tasks → New → Browse tasks → Log form submissions from my inbox to a sheet. Minda Super Intelligence for Windows is coming soon.
Last updated