User guide

Guide to automatic Google Form filling

From a Google Form link to the last response sent: set up the form, choose how each question is answered, preview, pick a speed and track progress.

Before you start

  • A signed-in The Light Data account with enough credits (see Pricing).
  • A public Google Form that doesn’t require a Google sign-in and has no file-upload questions.
  • You own the form or have the owner’s permission to work with it.

Step 1 — Set up the Google Form

Open the form in edit mode → Settings tab → Responses section, then change three settings:

  • Set “Collect email addresses” to Do not collect.
  • Turn off “Allow response editing”.
  • Turn off “Limit to 1 response” (under Requires sign in).
The Settings → Responses section of a Google Form
Settings → Responses in Google Forms.

Step 2 — Load the form into the tool

Go to the Form filling page, paste the …/viewform link into the “Paste Google Form URL” box and click Load form. The tool reads every question, option, required question and section (including “Go to section…” branching).

Step 3 — Choose how each question is answered

ModeUse it forHow it works
CountMultiple choice, dropdown, linear scale, checkboxesEnter the number of responses for each option (the total should equal N). For checkboxes, each box is picked independently, from 0 to N.
Excel textShort answer, paragraphTakes answers from the “Text” Excel file, one response per row.
Excel LikertMultiple-choice grid, rating scalesTakes scores from the “Likert” Excel file.
FixedQuestions that need the same valueEvery response uses the value you enter.
RandomQuestions whose distribution doesn’t matterPicks one of the options at random.
Leave blankOptional questionsLeaves the question empty.

Fill everything from Excel

Already have all your data in a spreadsheet? In the Batch panel, click Get full template, paste your data right below the header row (one response per row) and click Upload data — the full file replaces the mode of every question.

Screening questions (branching)

A screening question decides whether a respondent carries on, e.g. “Have you ever shopped online?”: No ends the survey, Yes continues.

  1. 1

    Set up the branch in Google Forms

    Put the screening question at the end of a section, click ⋮ → Go to section based on answer: the qualifying answer → the next section, the screened-out answer → Submit form. Load form reads these branches.

  2. 2

    Split the counts on the screening question

    Pick Counts and enter a number per answer, e.g. N = 200: Yes 180, No 20. 20 responses stop there, 180 carry on.

  3. 3

    Later questions count the responses that reach them

    Each later question’s counts add up to 180, not 200. Click Preview: every question shows “total … / … reaching this question”. Counts entered for N are scaled down for you and flagged in amber.

  4. 4

    Filling from Excel

    Rows with the screened-out answer can leave the later columns empty; only the sections a response visits are sent.

The branch is required

If the form only says “If not, please stop here” without a branch, every response still goes through the whole form. Set up the branch as in the first step.

Step 4 — Set the sample size and speed

In the Batch panel, enter the Sample size N (up to 20,000 responses per run) and choose a speed:

SpeedGap between two submissions
Fastabout 5 seconds / form
Normalabout 30 seconds / form
Slowabout 5 minutes / form
Human-likespread at random across time slots over 1–30 days

Click Preview to check the first few responses before you run. If you’ll reuse the setup for the next round, click Save template; Export JSON saves a copy of the configuration.

Step 5 — Send and track

  • Click Send N responses. The system shows the estimated cost and holds the matching credits.
  • The Send status panel shows successes, errors and the log in real time. The job runs on the server: you can close the browser and come back later.
  • Click Stop at any time — only successful submissions are charged.
  • The Send history page keeps the stats, the planned schedule (spread-over-days mode) and every submission of every run.

Video walkthrough

Important notes

Use it responsibly

Only work with forms you own or have permission to use, and follow Google’s terms and your institution’s research-integrity rules. Don’t use automated responses to impersonate real survey participants.

Why do I get an error when I click Load form?

Check that the link looks like docs.google.com/forms/…/viewform, that the form is accepting responses and that it doesn’t require a Google sign-in.

Can I run several jobs at once?

Each account runs one job at a time. Wait for the current job to finish, or stop it, before you send a new batch.

Does it follow the right branch in a multi-section form?

Yes. Each response picks its answers and then goes to the section those answers lead to, with a record of the sections it passed through.

More guides

Stuck on your data? Let an expert run it

Le Thanh Tung, with over 5 years in quantitative data analysis, runs it on the real software and writes it up to research standards.