Fill a date picker in a Google Form from a Google Sheet

How to fill a date picker in a Google Form from a Google Sheet: install the Chrome extension, click Build from description, tell the agent what you want, and follow its prompts. A working bot is built and tested in minutes.

Here is how the automation works. To fill a date picker in a Google Form, split the date into single digits with a Write javascript step, tab into the date field with Press key(s), and type the digits with a second Press key(s) step. The Enter text step can't fill a Google Forms date field reliably, because the field is a custom input.

Author
Alex Barlow
Published

Build the Google Form date picker from a description


Describe it and click the button: the agent builds and tests the form filler in your Chrome extension.

  1. Read the names and dates from my Google Sheet
  2. Open my Google Form for each row
  3. Fill in the name and the date
  4. Submit the form
Click to launch the Chrome extension. Not installed? You can create an account and try it free.Opens the Chrome extension. Free account to try.

You need a Google Sheet with one row per form entry, the date in DD-MM-YYYY format such as 12-12-2025, and a Google Form with a field before the date field: tabbing from that field is what places the cursor in the day part. Remove the rows already submitted before you run it again, since each run submits every row in the sheet.

Build the Google Form date picker step by step


The steps the agent builds, as the Builder shows them: each step by its name, with the fields to set under it. Add them yourself in this order in the step-by-step builder, or open the agent's result there to adjust it.

  • 1.0 Read data from a Google Sheet
    • Spreadsheet: your sheet
    • Sheet name: the tab with the entries
  • 2.0 Loop through data
    • repeats for every row in [google-sheet-data]
    • 2.1 Go to page
      • URL: the form's address
    • 2.2 Enter text
      • Select text field: the field before the date field
      • Text: the name column of [google-sheet-data]
    • 2.3 Write javascript
      • Script: the date script in the common questions below, with the date column's token on its first line, which returns the digits as [code-data]
    • 2.4 Press key(s)
      • Key: Tab
    • 2.5 Press key(s)
      • Data: [code-data]
      • Delimiter: ||
    • 2.6 Click element
      • Select: the form's Submit button

Common questions about the Google Form date picker


Why does Enter text not fill the Google Forms date field?

The Google Forms date field looks like a single input, but it's made of three parts: day, month, and year. Clicking the field can place the cursor in the day, month, or year part, so the automation can't be sure where typing starts, and the field doesn't accept a full date pasted as one string, such as 12-12-2025. The fix is to skip clicking entirely: tab into the field so the cursor always starts in the day part, then type the date one digit at a time.

How do I reformat the date for the Press key(s) step?

With this script in the Write javascript step, with your own date column's token in place of the one on the first line:

let input = '[google-sheet-data?*&11]';         // "12-12-2025"
let digits = input.replace(/-/g, '').split(''); // ["1","2","1","2","2","0","2","5"]
let output = digits.join('||');                 // "1||2||1||2||2||0||2||5"
return [[output]];                              // [["1||2||1||2||2||0||2||5"]]

The step strips the dashes, splits the date into single digits, and joins them with || so each digit is typed as its own key press. If your date uses a different separator, such as /, change the replace(/-/g, '') line to match it.

Why does the date land in the wrong part of the Google Forms date field?

The cursor did not start in the day part. Make sure the Tab Press key(s) step runs straight after the field before the date, and that nothing is clicked in between.

Why are the day and month swapped in the Google Form?

The form expects a different order. If it shows mm/dd/yyyy, reorder the parts in the Write javascript step so the month is typed first.

Can I use today's date instead of a date from a sheet?

Yes. Get the date with the Date and time step and pass its token into the Write javascript step in place of the sheet's column. See automate date inputs with the Date and time step.

Can I fill a Google Form from a Google Sheet without code?

Yes. The only code is the short Write javascript snippet above, which the agent writes for you; every other step is picked from the builder.

Can I run the Google Form filler on a schedule?

Yes. Save the automation and set a schedule; each run submits every row the sheet holds at the time, so remove the rows already submitted first.

How do I fill a calendar date picker on another site?

Use the Date picker step, which changes the month and clicks the day, on pickers that show the month with previous and next buttons.

Where do I get help?

Get in touch with support, or ask in the axiom.ai community. When a run fails, hand it to the agent and it repairs the step.

Related guides