How to Check Who Has Responded to a Google Form

You send out a team survey and check the results a day later, only to find twenty responses and zero names.

Google Forms does not collect email addresses or names automatically unless you specifically tell it to.

This default setting protects privacy, but it creates a headache when you need to know exactly who has completed a mandatory form and who is ignoring it.

Figuring out who submitted what requires a mix of native dashboard settings and spreadsheet logic.

Here is exactly how to track down your respondents, update your settings, and cross-reference your data to find out who is missing.

Why does Google Forms sometimes keep responses anonymous by default?

Google builds its consumer tools with privacy as the baseline standard.

When you create a new form from a blank template, the system assumes you want a frictionless experience for the user.

Asking for an email address or requiring a Google login adds a step that often lowers completion rates.

If you do not manually toggle email collection on, or explicitly type out a question asking "What is your name?", the form submits a blank identity payload.

The system still records a timestamp for every submission, but it strips away any identifying metadata about the browser or logged-in account.

This behavior changes depending on your workspace environment and how you configure the initial setup.

Understanding these defaults helps explain why your current data might look empty.

If you started with an anonymous setup, you cannot retroactively unmask the people who already clicked submit.

You can, however, change the rules for future respondents and use specific dashboard views to analyze the data you do have.

How to see who responded directly in the Google Forms dashboard

The native dashboard is the fastest place to check your data if you only have a few dozen submissions.

You do not need to export anything to see a quick tally of who has participated, provided you included a name or email field.

The dashboard splits your data into three distinct views, each serving a different analytical purpose.

Here is how to navigate the native interface to find respondent identities.

1. Open your document in the Google Forms editor.

2. Click the Responses tab located at the top center of the screen, just above your first question.

3. Look at the total count displayed next to the tab name to confirm people have actually submitted data.

4. Click the Summary sub-tab to see visual charts of your entire dataset.

5. Scroll down to the specific question where you asked for names or email addresses.

6. Review the list under that specific question - this provides a quick, unstructured roster of everyone who completed the form.

The Summary view is helpful for a fast glance, but it divorces the respondent's name from their actual answers.

To connect a specific person to their specific feedback, you need to use the other two sub-tabs.

7. Click the Question sub-tab to isolate individual fields.

8. Select your "Name" or "Email" question from the dropdown menu.

9. Click through the individual names to see how that specific text string was entered, though this still does not show their full survey.

10. Click the Individual sub-tab to read complete entries page by page.

11. Use the left and right arrows at the top of the screen to paginate through every single submission.

12. Look at the top of the page in the Individual view - if email collection was turned on, the verified email address will display directly below the submission number.

This dashboard method works well for small teams or quick checks.

When your submission count climbs past fifty, clicking through individual pages becomes incredibly tedious.

At that point, moving your data into a spreadsheet is the only practical way to track identities.

How to track responses using a linked Google Sheet

Connecting your form to Google Sheets unlocks the ability to sort, filter, and search your respondent data.

The spreadsheet updates automatically the moment a user clicks Submit.

Expert tip: Never type your own notes or formulas directly into the raw response sheet that Google creates. Always create a second tab in the spreadsheet and reference the raw data from there, otherwise new form submissions can overwrite or misalign your custom columns.

This automatic syncing is how organizations handle high-volume data collection.

For example, tracking student submissions requires a reliable, sortable ledger that teachers can check against a class roster.

Setting up this connection takes only a few clicks in the editor.

1. Navigate to the Responses tab in your form editor.

2. Click the green spreadsheet icon located in the top right corner of the responses panel.

3. Select Create a new spreadsheet if this is your first time linking the data.

4. Click Create to automatically open the new file in a separate browser tab.

Once the sheet opens, you will notice a layout that mirrors your form structure.

Column A is always dedicated to the Timestamp, recording the exact date and second the form was received.

The subsequent columns correspond exactly to the order of your questions.

To find out who responded, locate the column containing their names or email addresses.

You can click the letter header of that column to highlight it entirely.

With the column highlighted, click Data in the top menu, then select Sort sheet Z to A or A to Z.

Alphabetizing the identity column groups all your respondents logically, making it much easier to scan for familiar names.

If you need to find one specific person in a massive list, press Ctrl + F (or Cmd + F on a Mac) and type their name.

The spreadsheet will jump directly to their row, showing you exactly when they submitted and what their answers were.

How to identify who has not submitted your form yet

Knowing who completed the form is only half the battle.

Usually, the real goal is finding out who is missing so you can follow up with them.

Comparing a list of responses against a master roster manually is prone to error and wastes time.

You can automate this comparison using a basic VLOOKUP formula in your linked Google Sheet.

This method requires two things: a complete list of everyone who should respond, and the raw data of people who did respond.

Here is exactly how to set up the formula to flag missing individuals automatically.

1. Open your linked Google Sheet containing the form responses.

2. Look at the bottom of the screen and note the name of the tab containing your data (usually named Form Responses 1).

3. Click the + icon in the bottom left corner to add a new, blank sheet tab.

4. Rename this new tab Master Roster to keep your workspace organized.

5. In the Master Roster tab, paste your complete list of expected email addresses down Column A, starting in cell A2 (leave A1 for a header).

6. Type the header Status in cell B1.

7. Click into cell B2, which sits directly next to your first expected email address.

Now you need to write the formula that asks Google Sheets to search for the email address from A2 inside the Form Responses 1 tab.

Type this exact formula into cell B2:

=IF(ISNA(VLOOKUP(A2, 'Form Responses 1'!B:B, 1, FALSE)), "Missing", "Submitted")

This formula looks complicated, but it breaks down into simple logical steps.

• The VLOOKUP part - searches for the exact email address from A2 inside Column B of the responses sheet.
• The FALSE part - tells the system it must find an exact match, not a partial spelling.
• The ISNA part - checks if the VLOOKUP resulted in an error (meaning the email was not found).
• The IF part - dictates that if the email is not found, print the word "Missing"; otherwise, print "Submitted".

8. Press Enter to execute the formula in cell B2.

9. Click on cell B2 again to highlight it.

10. Hover your cursor over the tiny blue square in the bottom right corner of the cell until it turns into a crosshair.

11. Double-click that blue square to drag the formula all the way down Column B, applying it to every name on your roster.

Your master list will now immediately display either "Submitted" or "Missing" next to every single person.

To make the missing people stand out even more, you can apply conditional formatting.

Highlight Column B, click Format in the top menu, and select Conditional formatting.

Set the format rules to Text contains and type Missing in the value box.

Change the background color to a bright red or orange and click Done.

Now, any time a new person fills out your Google Form, their status on the master roster will automatically flip from a red "Missing" to a plain "Submitted" without you touching a thing.

How to change settings to automatically collect responder identities

If you are tired of relying on people to type their names correctly, you can force the system to handle identification.

Modifying your form settings ensures you never receive an anonymous submission by accident.

This requires changing the configuration before you distribute the link.

1. Open your Google Form in the editor.

2. Click the Settings tab located at the top center, next to Responses.

3. Click the downward arrow next to Responses to expand the section.

4. Locate the Collect email addresses setting.

5. Click the dropdown menu next to it to reveal your options.

You will see two distinct choices for gathering emails, and they create very different experiences for the user.

Selecting Responder input simply adds a mandatory text field to the top of your form.

The user can type any email address they want into this box, including fake ones, which means you cannot fully verify their identity.

Selecting Verified forces the user to log into a Google account before they can even view the questions.

The system records the exact email address associated with their active login session, making spoofing nearly impossible.

If you are using Google Workspace for a business or school, you have an additional security layer available.

6. Look directly below the email collection settings for the Require sign-in section.

7. Toggle on the switch labeled Restrict to users in [Your Organization] and its trusted organizations.

Enabling this restriction guarantees that only people with a company or school email address can access the document.

It locks out personal Gmail accounts entirely.

Keep in mind that combining Verified emails with organizational restrictions significantly raises the barrier to entry.

This is the correct setup for internal HR documents, employee feedback, or graded assessments.

It is the wrong setup if you are sending a link to external clients or parents who might not use Google services.

How to follow up with non-responders without compromising anonymous surveys

Sometimes you deliberately choose to keep a survey anonymous to encourage honest feedback.

This creates a structural problem: if you do not know who responded, you cannot know who to remind.

Sending a targeted list of reminders is impossible when the data is truly unlinked.

The only solution is to send a broadcast reminder to your entire original distribution list.

When doing this, your messaging must acknowledge that some recipients have already done the work, while gently nudging those who have not.

A poorly worded broadcast email makes people who already submitted feel ignored or frustrated.

• ❌ Weak: You have not completed the team survey yet. Please fill it out by Friday.

• ✅ Strong: If you have not yet had a chance to complete the team survey, please do so by Friday. If you already submitted it, thank you - you can ignore this message.

Why it works: The strong version accounts for both audiences without making assumptions.

Here are three complete templates you can use to chase down missing responses without breaking anonymity.

Template 1: The general soft nudge Use this midway through your collection period when you simply need to boost overall numbers.

Subject: Quick reminder: [Survey Name]

Hi team,

This is a quick reminder to complete the [Survey Name] when you have a few spare minutes.

Because the form is completely anonymous, I cannot track who has already submitted their feedback. If you have already filled it out, thank you for your time and please disregard this email.

If you haven't gotten to it yet, you can access the form here: [Link]

Thank you, [Your Name]

Template 2: The deadline approach Use this 24 to 48 hours before you close the form to final submissions.

Subject: Closing tomorrow: [Survey Name]

Hi everyone,

We will be closing the [Survey Name] tomorrow at [Time].

We are currently at [Number] responses and would love to hear from the rest of the group before we begin analyzing the data.

As a reminder, your answers are 100% anonymous. We are not tracking email addresses or names.

If you have not submitted your answers, please use this link before tomorrow afternoon: [Link]. If you have already participated, thank you!

Best, [Your Name]

Template 3: The high-stakes requirement Use this when completion is mandatory, but the specific answers must remain anonymous (like an election or compliance attestation).

Subject: Action required: [Survey Name] due by [Date]

Hello team,

Participation in the [Survey Name] is required for all department members by [Date].

To protect your privacy, the form is configured to be fully anonymous. Because the system does not record names, I have to send this reminder to the entire department.

Please click here to complete the requirement: [Link]

If you already clicked submit earlier this week, your entry was recorded and no further action is needed.

Thank you for your cooperation, [Your Name]

Using these templates respects the privacy boundary you set up while still applying the necessary administrative pressure to get your data.

FAQ

Can you see who responded to a Google Form if it was set to anonymous?

No, the system deliberately drops identifying metadata when configured for anonymity. Unless the respondent voluntarily typed their name into an open text box within the survey, their identity remains hidden. You cannot retroactively uncover email addresses or IP addresses for past anonymous submissions.

Why are some names showing up as anonymous in my linked Google Sheet?

This happens when you leave email collection set to Responder input but fail to make the field mandatory, allowing people to skip it. It also occurs if your form includes a "Name" question that does not have the Required toggle turned on. To fix this for future entries, open your editor and ensure all identity-related questions are marked as required.

How do I send a reminder email only to people who have not responded yet?

You can only target non-responders if your form was tracking identities in the first place. Export your responses to Google Sheets and use a VLOOKUP formula to compare the submitted emails against your master roster. Once the spreadsheet flags the missing individuals, copy their specific email addresses into the blind copy (BCC) line of a new reminder email.

Can respondents see other people's names or answers after submitting?

By default, respondents only see a confirmation screen after they click submit. However, if you open the Settings tab, expand Presentation, and toggle on View results summary, respondents will see a link to a public dashboard showing charts of all answers. You should generally leave this off if your form collects personal names or sensitive written feedback.

Tracking form responses efficiently comes down to establishing clear settings before you ever hit send. If you are regularly building complex forms from existing materials and need to ensure your identity settings are configured correctly from the start, a tool like Doc2Form can convert your text documents directly into Google Forms, letting you focus on analyzing the data rather than typing out questions. Keep your spreadsheet formulas clean, communicate clearly with your non-responders, and let the software handle the manual tracking.