Limit Responses in Google Forms: A Step-by-Step Guide

This guide shows you how to stop accepting new submissions in a Google Form after a certain number of responses, a specific date, or at a time you choose. You’ll learn the built-in settings, a workaround for when you need a hard cutoff, and how to avoid common pitfalls. No coding or add-ons are required—everything is done in the form’s settings.

What You’ll Need

• A Google account (free) with access to Google Forms.
• The form you want to limit (you must be the owner or have edit access).
• Optional: A Google Sheet to store responses if you want to track the count.

Step-by-Step

1. Open your form in Google Forms. Go to forms.google.com, sign in, and click the form you want to edit. If you haven’t created it yet, click the blank form or a template.
2. Go to the Settings tab. At the top of the form editor, click the tab labeled “Settings” (the gear icon in some views). This opens the form-wide options.
3. Find the “Responses” section. In the Settings panel, scroll down to the section titled “Responses.” It contains options like “Accepting responses” and “Limit to 1 response.”
4. Enable the response limit. Look for the toggle or checkbox that says “Limit to 1 response.” Turn it on. This is the only built-in response limit Google Forms offers.
5. Understand what it does. This setting forces each signed-in Google user to submit only once. It does NOT set a maximum number of total responses. For a total cap, you’ll need the workaround below.
6. Stop accepting responses manually (the total cap workaround). To limit the total number of responses, you must turn off the form yourself once you reach your desired count. Here’s how:
   • In the Settings tab, under “Responses,” toggle off the switch that says “Accepting responses.” This immediately closes the form to new submissions.
   • If you want to reopen it later, just toggle it back on.
7. Use a Google Sheets script for automatic cutoff (advanced). If you want the form to close automatically after N responses, you can use a simple script in the linked response spreadsheet. This requires a tiny bit of code but works reliably.
   • In the form editor, click the “Responses” tab at the top.
   • Click the green Sheets icon to create a spreadsheet for responses (or link an existing one).
   • In the spreadsheet, go to Extensions > Apps Script.
   • Paste the following code, replacing 10 with your limit:

     function autoClose() {
       var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
       var lastRow = sheet.getLastRow() - 1; // subtract header row
       if (lastRow >= 10) {
         var form = FormApp.openByUrl('YOUR_FORM_URL');
         form.setAcceptingResponses(false);
       }
     }

   • Replace YOUR_FORM_URL with your form’s URL (found in the form editor’s address bar).
   • Save the project, then click the clock icon (Triggers) in the left menu.
   • Click “Add Trigger,” choose the autoClose function, set the event to “Time-driven” and “Minutes timer” (e.g., every 5 minutes).
   • Authorize the script when prompted. It will check the response count periodically and close the form when the limit is reached.
8. Alternatively, use a third-party add-on (e.g., Form Publisher, Choice Eliminator). Some add-ons offer response limits. Go to the puzzle piece icon in the form editor to browse add-ons. Be cautious with permissions—only use reputable ones.
9. Test your setup. Always test the limit by submitting a few responses yourself (you can delete them later) to ensure the form closes as expected.

Common Mistakes

• Confusing “Limit to 1 response” with a total cap. The built-in setting only restricts per-user submissions, not the overall count. Many users expect it to stop after N responses—it doesn’t.
• Forgetting to turn off “Accepting responses” when you want a hard stop. If you manually close the form, you must toggle the switch off. Leaving it on means the form stays open.
• Not checking the response count in real time. The script method has a delay (e.g., checks every 5 minutes). During that window, extra responses can come in. Plan for that.
• Using the script without replacing the URL placeholder. If you leave YOUR_FORM_URL as is, the script will throw an error and do nothing.
• Deleting responses to “reset” the count. Deleting rows in the spreadsheet does NOT reset the form’s internal count for the script (it uses the sheet’s row count, so it might, but it’s unreliable). Better to create a new form or clear the sheet and reset the script.

Tips

• Communicate the limit. Add a note in the form description like “Only the first 100 responses will be accepted.” This sets expectations.
• Use a confirmation message. In Settings > Presentation, customize the confirmation message to thank respondents and note that submissions are closed if they try after the limit.
• Combine with a date limit. If you want to close on a specific date, you can set that in Settings > Presentation > “Collect email addresses”? No—date limits aren’t built-in. But you can use the same script approach to check the date and close the form.
• Keep a backup. Before closing the form, export responses to Excel or Google Sheets for your records.
• Test with a dummy form. Create a copy of your form and test the limit there before applying to the live one.

Troubleshooting

• The form still accepts responses after I turned off “Accepting responses.” This can happen if the toggle didn’t save. Refresh the page and check the toggle again. Also, make sure you’re not in a preview mode—preview lets you submit even when closed.
• My script doesn’t run. Check the Apps Script editor for errors (red exclamation marks). Ensure you authorized the script and set up the trigger correctly. Also, confirm the URL is correct and the form is not in a different Google account.
• The response count in the script is off. The script subtracts one for the header row. If your sheet has extra header rows or notes, adjust the subtraction. For example, if you have 2 header rows, subtract 2.
• I want to reopen the form after closing it. Just toggle “Accepting responses” back on. If using the script, you’ll need to set setAcceptingResponses(true) or remove the trigger.
• I need to limit by date, not count. Modify the script to check the current time (e.g., if (new Date() > new Date('2025-12-31'))) and close the form. Or, simply set a reminder to close it manually.

Frequently Asked Questions

Can I set a maximum number of responses without a script? No. Google Forms only has the “Limit to 1 response” per-user option. For a total cap, you must either close it manually or use a script/add-on.

Does “Limit to 1 response” work for anonymous users? No. It requires respondents to be signed into Google. Anonymous users can submit multiple times.

Can I limit responses to a specific date range? Not directly. You can close the form manually on the date, or use a script to check the date and close it automatically.

What happens when the form is closed? Do respondents see an error? They see a message saying the form is no longer accepting responses. You can customize this message in Settings > Presentation.

Can I reopen the form after it’s closed? Yes, toggle “Accepting responses” back on. Any responses collected before closing remain intact.

Will the script work if I use a Google Workspace account? Yes, but your admin may restrict Apps Script. You’ll need permission to run scripts.

Related

• BTU to Temperature Calculator: How It Works
• Biweekly Calculator Hours Worked: How to Count
• Boiling Water Evaporation Rate Calculator