Google Form to Google Calendar: Free Apps Script Generator
Turn every Google Form submission into a Google Calendar event automatically. Map your form's date, time and other questions below, we generate a ready-to-paste Apps Script so you can skip the paid add-on. No signup required.
Use {Question Title} to insert any form answer. E.g. {Name}, {Email}. Match the question's exact label.
Exact title, case-sensitive.
Leave blank if the date question also holds a time. With no time at all, the event starts at midnight.
๐ privacy-friendly, your inputs never leave your browser. nothing is stored or sent to our servers.
Got your script? Skip the Apps Script setup next time.
Now you're about to paste this into Google's script editor, set up a trigger, click through an "unverified app" warning, and hope your date format parses correctly. In FormNX, calendar events fire from form submissions natively, one toggle, no script, no fragile date parsing. Plus the things Google Forms can't do at all: availability checks, conditional routing to different team calendars, branded confirmation emails. Already have the Google Form? Import it into FormNX in one click by pasting its link, no rebuilding.
Get FormNX Free, Calendar Built In โFree forever plan. No credit card required.
What Is a Google Forms to Calendar Integration?
A Google Forms to Calendar integration is any connection that turns a form submission into a Google Calendar event automatically. Google Forms has no native calendar integration built in, so the link is made in one of four ways: an Apps Script, a Workspace add-on, an automation tool, or a form builder that creates the event natively.
In practice a Google Forms Calendar integration reads the date and time answers on each response and writes them to whichever calendar you choose, so a booking request, interview slot or class signup lands on the right calendar without anyone retyping it. The four methods below do that same job with different trade-offs in cost, setup effort, and how much calendar access you hand to a third party. Whether you call it a Google Form calendar, a Google Forms Google Calendar integration or simply a way to link Google Calendar and Google Forms, the result is the same: each response becomes an event on your calendar at the date and time the respondent picked.
Google Form to Calendar: 4 Ways to Connect (Compared)
Google Forms cannot create calendar events on its own. There are four ways to connect a Google Form to Google Calendar, and they trade off cost, setup effort and how much access you hand to a third party.
| Method | Cost | Best for | Watch out for |
|---|---|---|---|
| Apps Script the generator above |
Free no signup |
One-off setups where you want full control and no third party touching your data. The code runs inside your own Google account. | No availability check, date parsing can fail silently, events use your timezone. See the limitations below. |
| Form2Cal Workspace add-on |
Free for 1 form $4.99/mo for more |
Non-technical users who want the quickest setup and only need one form connected. | You grant a third party permission to view, edit, share and delete all your calendars. |
| Form to Calendar Workspace add-on |
10 events free then paid licence |
Trying the add-on route before committing to anything. | The free trial is 10 events total, not per month. Rated 3.4/5 across 107 reviews on the Marketplace. |
| Zapier, Make or IFTTT automation tools |
Free tiers, then paid by usage volume |
Teams already using one of these tools who want the calendar event plus other steps (Slack, CRM, email). | Every submission uses part of your monthly task or operation quota, so cost scales with form volume. |
Inviting people to a session you already scheduled? That is a different job. The Form Calendar Invites add-on (14-day trial, then ยฃ4 a month) adds each respondent as a guest on an existing event they pick on the form and emails them the invite, instead of creating a new event for every response.
The privacy difference worth knowing: an Apps Script runs inside your own Google account, so no outside company can read your form responses or your calendar. The add-ons above ask you to grant a third-party developer access to your calendars before they will work. If that matters to you, the free generator on this page is the safer route.
A fifth option: use a form builder that creates calendar events natively. FormNX needs no script and no add-on, checks availability before it books, and detects the submitter's timezone - the three things every method above struggles with.
Real limitations of this Google Forms to Calendar Apps Script approach
The script above works, but you should know what you're committing to. Here are the honest limits Apps Script can't solve without writing more code:
No availability check, double bookings will happen
The script creates an event for every submission, no matter what's already on your calendar. If two people pick the same 3pm slot, you'll have two overlapping events and no way to know until someone shows up. There's no built-in conflict prevention.
Date and time parsing is fragile
The script receives each answer as text, formatted by your response spreadsheet. If the spreadsheet writes dates day-first (04/12/2026 for 4 December), the script reads them month-first and books 12 April, and a date typed into a free-text question ("next Tuesday") can't be read at all, so no event is created. Use the Date question type and set the spreadsheet's locale to United States.
Timezone is your account's, not the submitter's
The event is created in your Apps Script account's timezone. If a submitter in another timezone enters "2pm", the script will create the event at 2pm in your timezone, almost certainly not what they meant. There's no easy way to detect or convert the submitter's timezone in Apps Script.
No reschedule or cancel handling
If a submitter needs to change their booking, they'll re-submit the form, and the script will create a second event without removing the first. You'll have to manually find and delete the old one. There's no way to link a submission to an existing calendar event.
Same calendar for everyone, no routing
The script writes to one fixed calendar. You can't route bookings to different team members based on form answers (e.g. "if Service = Coaching โ Alice's calendar; if Service = Audit โ Bob's"), without rewriting the script for each branch.
Silent failures + authorisation can expire
If the script errors (bad date parse, calendar not found, quota hit) or your trigger expires, nothing tells you. You only find out when a submitter says "I never got the calendar invite." You'll have to manually open the Executions log to investigate.
"Functions that are particularly useful: Multi-Step Forms, progress bar, personalized 'Thank You' Page, smart form scheduling, duplicate check, reporting & charts. Very fast help!"
When the script isn't enough, what FormNX adds
- โ One-click Google Forms import, paste your form link, no rebuilding
- โ Native calendar event creation, no scripting, no date-format gotchas
- โ Availability check before booking, submitters only see free slots; no double-bookings
- โ Submitter timezone auto-detected, events created in the right local time
- โ Conditional routing, different services route to different team calendars automatically
- โ Branded confirmation emails, not the default Google Calendar invite
- โ Multi-step booking flow, higher completion than a single long page
- โ Built-in OTP email verification so every booking is from a real inbox
Comparing options? See FormNX vs Google Forms โ
Switch to FormNX, Free Forever Plan โFree forever plan. No credit card required.
How to install the script in your Google Form (6 steps)
- Open your Google Form, go to the Responses tab and click Link to Sheets to create the response spreadsheet (or open the one already linked).
- In that spreadsheet, click Extensions โ Apps Script. Install it here, not from the form's own โฎ menu: the script reads each answer by its column header, which only the spreadsheet trigger provides.
- A new tab opens with a code editor. Delete any existing code, then paste the script generated above.
- Click the ๐พ Save icon (or press Ctrl/Cmd + S). Give the project a name if asked, something like "Form to Calendar".
- In the left sidebar, click Triggers (โฐ). Click + Add Trigger (bottom right). Set: Function =
createCalendarEvent, Event source = From spreadsheet, Event type = On form submit. Click Save. - Google will ask for permissions to access Calendar. You'll see a warning that says "Google hasn't verified this app", this is normal because the script is your own. Click Advanced โ Go to [project] (unsafe) โ Allow. Submit a test response to your form and check that the calendar event was created. Don't test with the Run button: it has no form data, so it stops with an error.
Every new submission from now on creates a calendar event automatically. If your form's question titles change, regenerate the script and replace the code in the editor.
What this script actually does
The script runs on your response spreadsheet's on-form-submit trigger. Every time someone submits a response, Google adds a row to the sheet, calls the createCalendarEvent function and passes the answers via e.namedValues, a dictionary keyed by your question titles (the sheet's column headers).
The function reads the date and time answers, parses them into a JavaScript Date, fills in the title and description by substituting {Question Title} placeholders with the actual answers, then calls CalendarApp.createEvent() on your chosen calendar. If you enabled the "invite the submitter" toggle, it scans the responses for an email-format value and lists that person as a guest on the event. It doesn't ask Google to send an invitation email.
Using Google Forms for Event Registration with Calendar Invites
Event registration is the most common reason people connect Google Forms to Google Calendar. With the script above, every registration becomes an event on the organiser's calendar. Turn on the Invite the submitter toggle and each registrant is listed as a guest on their event. The script doesn't send Google's invitation email, so confirm the place another way, for example with Google Forms' own setting that emails responders a copy of their answers.
Where Google Forms stops: it cannot sell tickets or take a deposit, it has no capacity cap (the 51st person can still register for 50 seats), and the script creates one event per submission, so a 200-person event means 200 separate events unless you edit the script to add each guest to a single existing event instead.
For a registration form that takes payment, closes itself at capacity and sends a branded confirmation, start from an event registration form template with payments and a response limit built in.
Google Form to Calendar Script Not Working? 6 Fixes
Most problems come down to one of these. The script logs what went wrong, so start in the script editor: open Executions in the left sidebar and click the latest run.
"TypeError: Cannot read properties of undefined (reading 'namedValues')"
The script was installed from the form's own โฎ menu, or it was started with the Run button. Both leave it without the spreadsheet data it reads. Install it from the form's linked Google Sheet (Extensions โ Apps Script) with an "On form submit" trigger from the spreadsheet, then test by submitting the form.
"No date answer found for question"
The date question title in the script doesn't match the form exactly. Titles are case-sensitive and a trailing space counts. Copy the title from the form (it's also the column header in your response sheet) and generate the script again.
The event lands in the wrong month
Your spreadsheet writes dates day-first, so 04/12/2026 is read as 12 April. In the sheet open File โ Settings, set Locale to United States, then submit a fresh test response.
The event is at the wrong hour
The script uses its project's timezone, not the respondent's. In the script editor open Project Settings (gear icon), tick Show "appsscript.json" manifest file in editor, then set timeZone in that file to your bookings' zone, such as America/New_York.
The guest never gets an invite email
That is expected: the script lists the submitter as a guest without sending Google's invitation email. To confirm bookings, turn on Google Forms' option to email responders a copy of their answers, or use an add-on that sends invites.
It worked, then stopped
Triggers fail silently when authorisation expires or the spreadsheet is copied. Open Triggers, delete the old one and add it again, then allow access. While you're there, set Failure notification settings to Notify me immediately so the next failure reaches your inbox.
Frequently Asked Questions
-
1. Is there a simpler way to send Google Form submissions to Google Calendar?
Yes, switch to a form builder with native calendar integration. FormNX turns every submission into a calendar event without scripting, handles timezones correctly, supports availability checks, and routes different services to different team calendars, all visually, no code. The free plan covers most use cases, and you can import your existing Google Form in one click by pasting its link.
-
2. Can Google Forms create calendar events natively, without an add-on or script?
No. Google Forms doesn't have a native calendar integration, you need either a Workspace add-on (Form to Calendar, Form2Cal, Form Director), Zapier, or a custom Apps Script. The generator above gives you the Apps Script approach, free.
-
3. Can I connect Google Forms to Google Calendar?
Yes, but not with a built-in setting, Google Forms has no native calendar option. You connect the two in one of four ways: a free Apps Script (the generator above), a Workspace add-on such as Form2Cal or Form to Calendar, an automation tool like Zapier, or a form builder that creates calendar events natively. The comparison table above shows what each one costs and what to watch out for.
-
4. Can a Google Form send a calendar invite?
Partly. Turn on the "Invite the submitter" toggle and the script lists the submitter as a guest on the event, using the first email-format answer it finds (including the address the form collects). It does not ask Google to send an invitation email. For an emailed invite, use an add-on such as Form Calendar Invites or Form2Cal.
-
5. Is this generator really free?
Yes, completely free with no signup. The script is generated entirely in your browser. We never see your question titles, calendar ID, or any data.
-
6. How do I find the exact "question title" to paste into the date and time fields?
Open your Google Form in edit mode. The question title is the bold text at the top of each question (e.g. "Preferred date"), and it is also the column header in your response sheet. Type it into the generator above exactly as it appears, capitalisation and punctuation matter, because Apps Script matches it as a dictionary key.
-
7. What date format does the script expect?
It reads the date as your response spreadsheet writes it, using JavaScript's built-in
new Date(...)parser. US dates ("12/4/2026") and ISO dates ("2026-12-04") work. Day-first dates ("04/12/2026" for 4 December) are read month-first, so set the spreadsheet's locale to United States under File, Settings. Use Google Forms' Date question type rather than a free-text field, and if nothing appears, check the Executions log in the script editor for the raw value. -
8. Can I add the submitter as a guest to the event?
Yes, enable the "Invite the submitter" toggle. The script scans the responses for an email-format answer (e.g. an "Email" question, or the address the form collects) and lists that address as a guest on the calendar event. Google does not email them an invite from this script.
-
9. Can I write events to a calendar other than my primary one?
Yes. Open Google Calendar โ Settings for the calendar you want โ scroll to "Integrate calendar" โ copy the Calendar ID (it looks like
[email protected]). Paste it into the Calendar ID field above. Make sure your account has write access to that calendar. -
10. Can I prevent double-bookings on the same time slot?
No, the Apps Script approach creates an event for every submission, regardless of conflicts. To prevent double-bookings, you need a form builder like FormNX with built-in availability slots, or a dedicated booking tool. The script blindly trusts whatever date/time the submitter entered.
-
11. How do I handle different services routing to different team calendars?
You'd need to hand-edit the script with branching logic (
if response = "Coaching" then calendar A, else calendar B). It works but quickly becomes hard to maintain. Visual conditional routing is built into FormNX, no code to edit per service. -
12. How do I remove or disable the calendar sync later?
Open the script editor from your response spreadsheet (Extensions โ Apps Script), click Triggers (clock icon) in the left sidebar, find your trigger, and click the trash icon. New submissions stop creating events immediately. Existing events stay on your calendar.
-
13. Can I use Google Forms to schedule appointments or meetings?
Not on its own. Google Forms collects a requested date and time, but it has no availability check, no time-slot picker, and no way to stop two people booking the same slot - so it is a request form, not a scheduler. The Apps Script above turns each submission into a calendar event, which is enough for simple intake, but for real appointment or meeting scheduling - showing only free slots, confirmations, reminders, and correct timezones - use a form builder with native scheduling like FormNX or a dedicated booking tool.
-
14. How do I add a calendar date picker to a Google Form?
Add a question and choose the Date question type - Google Forms then shows respondents a calendar date picker (add a separate Time question if you also need a time). That captures the date on the form itself; to push it into Google Calendar as an event you still need the Apps Script above, a Workspace add-on, or Zapier. FormNX works the same way with built-in date and time fields, but creates the calendar event natively with no script.
-
15. Does Google Forms have a calendar template?
No - Google Forms has no built-in calendar template and no native calendar view. You collect dates with the Date question type, and if you want each response to appear on Google Calendar you connect the form using the Apps Script above, a paid Workspace add-on, or Zapier. There is no setting inside Google Forms that creates calendar events on its own.
Made by FormNX, the form builder with built-in calendar integration, availability checks, and conditional routing. See our other free tools: email notifications generator, embed Google Form generator, and QR code for Google Forms.
- Alternatives
- Jotform Alternative
- Typeform Alternative
- Google Forms Alternative
- SurveyMonkey Alternative
- Contact Form 7 Alternative
- Paperform Alternative
- Microsoft Forms Alternative
- Fillout Alternative
- Tally Forms Alternative
- Gravity Forms Alternative
- Cognito Forms Alternative
- Formstack Alternative
- Wufoo Alternative
- Zoho Forms Alternative
- WPForms Alternative
- All Alternatives
- Pricing Guides
- Jotform Pricing
- Typeform Pricing
- SurveyMonkey Pricing
- Use Cases
- No-Code Form Builder
- Online Survey Builder
- AI Form Builder
- Online Quiz Maker
- Job Application Form Builder
- Order Form Builder
- Screen Printing Order Form
- Wholesale Order Form
- WordPress Form Builder
- Contact Form
- Email Form
- Nonprofit Form Builder
- Squarespace Form Builder
- Wix Form Builder
- Webflow Form Builder
- Framer Form Builder