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.
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.
- Read the names and dates from my Google Sheet
- Open my Google Form for each row
- Fill in the name and the date
- Submit the form
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 SheetSpreadsheet: your sheetSheet name: the tab with the entries
- 2.0
Loop through data- repeats for every row in
[google-sheet-data]
- 2.1
Go to pageURL: the form's address
- 2.2
Enter textSelect text field: the field before the date fieldText: the name column of[google-sheet-data]
- 2.3
Write javascriptScript: 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 elementSelect: the form's Submit button
- repeats for every row in
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
Automate date inputs with the Date and time step
- Go to the form page I give you
- Get today's date in the format the form uses
- Type it into the date field
- Submit the form
Send X (Twitter) DMs from a Google Sheet
- Open each X profile link in my sheet
- If the profile has a Message button, click it
- Type my message and send it
- Delete the profile from the sheet once done
Send Facebook Messenger messages from a Google Sheet
- Read the profile links from my Google Sheet
- Open each profile and click Message
- Type my message and send it
- Delete the row once it is sent