How to Use Google Forms for Employee Time-Off Requests
Morgan Hopkins
Mar 10, 2026
You can build a complete employee time-off request system with Google Forms and the
Fast Forms
add-on that auto-generates PTO summary documents, sends personalized confirmation emails to the employee, and
routes the request notification directly to the correct manager — all without writing a single line of
code. This article walks through the full setup, from building the form to configuring dynamic recipient
routing and branded document generation.
Most organizations still handle time-off requests through email threads, shared spreadsheets, or expensive
HR platforms. These approaches are either too informal to create a reliable paper trail or too costly for
small and mid-sized teams. Google Forms sits in the sweet spot: it is free, easy for employees to use on any
device, and it automatically logs every submission to a Google Sheet for record-keeping. The missing piece has
always been what happens after the form is submitted. That is where Fast Forms comes in, turning a basic
Google Form into a notification and document generation system that handles the entire downstream workflow
automatically.
Step 1: Build Your Time-Off Request Form
Start by creating a new Google Form at
forms.new. Give the form a clear title
like "Employee Time-Off Request" and add the following questions:
- Full Name — Short answer text. This captures the employee's name for the notification and the generated document.
- Email Address — Use the built-in "Collect email addresses" setting in your form's Settings tab. This captures the employee's email automatically and is used by Fast Forms for dynamic recipient routing.
- Leave Type — Dropdown or multiple choice. Include options like Vacation, Sick Leave, Personal Day, Bereavement, and any other leave categories your organization uses.
- Start Date — Date picker question. Set it to require a date so the employee cannot skip it.
- End Date — Date picker question. This gives you a clear date range for the request.
- Reason / Notes — Paragraph text. Make this optional so employees can provide context if they want to, without forcing it for straightforward requests like a single vacation day.
Once your questions are in place, click the Responses tab in your form and link it to a Google Sheet.
This spreadsheet will store every submission and serve as the data source for the lookup table you will
create in the next step.
Step 2: Create an Employee-to-Manager Lookup Table
The key to routing each time-off request to the correct manager is a Google Sheets lookup table. In the
Google Sheet that is linked to your form, click the + icon in the bottom left corner to add a new
sheet tab. Name it something like "Manager Lookup."
In Column A, enter the email address of each employee who will submit the form. In Column B, enter the email
address of that employee's direct manager. For example:
| Column A (Employee) | Column B (Manager) |
| alice@company.com | manager.west@company.com |
| bob@company.com | manager.east@company.com |
| carol@company.com | manager.west@company.com |
When a form is submitted, Fast Forms looks up the respondent's email address in Column A and sends the
notification to the corresponding manager in Column B. If managers change, you simply update the spreadsheet
— no need to reconfigure the form or the add-on. For a full walkthrough on configuring lookup tables,
see our support article on
adding recipients.
Step 3: Design a PTO Summary Document Template
Fast Forms can generate a branded document every time the form is submitted. To set this up, create a Google
Doc (or Google Slide) that serves as your PTO summary template. Design it with your company logo, colors,
and formatting, then insert data markers wherever you want form response data to appear.
Data markers use the exact question titles from your form, wrapped in double angle brackets. For a time-off
request template, you might include:
TIME-OFF REQUEST SUMMARY
Employee: <<Full Name>>
Email: <<Email Address>>
Leave Type: <<Leave Type>>
Start Date: <<Start Date>>
End Date: <<End Date>>
Reason: <<Reason / Notes>>
Submitted: <<Timestamp>>
When a form submission is made, Fast Forms replaces each data marker with the actual response value and
generates a completed document. That document can be attached to the notification email sent to the manager,
giving them a clean, branded summary they can save to the employee's file. For detailed instructions on
creating templates, see our support article on
adding file templates.
Step 4: Configure Fast Forms Recipients and Notifications
Install the
Fast Forms add-on
from the Google Workspace Marketplace if you have not already. Then open your Google Form, refresh the page,
and click the puzzle piece icon in the top right corner to launch the add-on.
Add the manager as a dynamic recipient. Click
' Add Dynamic Recipient' and select the Email
Address question. Then click the lookup table icon next to the recipient
and select the Manager Lookup sheet you created in Step 2. Fast Forms will now resolve each submission's
manager dynamically at the time the form is submitted.
Add the employee as a recipient. If you want the employee to receive a confirmation email as well,
add another dynamic recipient using the same Email Address question, but without a lookup table. This sends
the notification directly to the address the employee entered when submitting the form.
Personalize the notification. Customize the email subject and body for each recipient using data
markers. For the manager's notification, you might use a subject line like "Time-Off Request from
<<Full Name>>" and include the dates and leave type in the body. For the employee's
confirmation, you might write "Your time-off request for <<Start Date>> to
<<End Date>> has been submitted." For more guidance, see our support article on
personalizing notifications.
Attach the PTO document. In the add-on, attach the document template you created in Step 3. Fast
Forms will generate the completed document and include it as an attachment on the notification email.
Click Save, then submit a test response from the form's Preview mode to verify that the manager
receives the notification with the attached PTO summary document, and the employee receives their
confirmation email.
Step 5: Add Routing Conditions (Optional)
If your organization needs to notify additional people for specific types of leave, you can use routing
conditions. For example, you might want to add the Payroll team as a recipient only when the leave type is
"Bereavement" or "FMLA," since those categories may require special handling.
To do this, add a new static recipient with the Payroll team's email address, then click the routing
conditions icon and set the condition to "Leave Type equals Bereavement" or "Leave Type equals FMLA."
The Payroll team will only be notified when those specific leave types are selected. All other submissions
will go only to the manager and the employee. For more on configuring conditions, see our support article on
adding recipient logic.
Why Google Forms Works for Time-Off Requests
Google Forms is free with every Google account, mobile-friendly, and requires no training for employees.
Combined with Fast Forms, it handles the three things that most time-off request systems need: a clean
submission experience for the employee, automatic notifications to the right manager, and a formal document
for record-keeping. The Google Sheet that backs the form also doubles as your PTO log, which you can filter,
sort, and report on at any time.
Unlike dedicated HR platforms that charge per employee per month, this setup costs nothing on the Free plan
(up to 30 notifications per month) and scales affordably with the Individual plan at $4/month or the Team
plan at $24/month, both billed annually. With over 4,000,000 installs, Fast Forms is a proven add-on that
organizations trust for exactly this kind of workflow.
For more on routing submissions to different people, see our guide on
how to route Google Form submissions to different people.
For a deeper look at document generation, see
how to generate documents from Google Form responses.
Frequently Asked Questions
Can I use this for a team that does not use Google Workspace?
Yes. Only the form administrator needs a Google account. Employees can submit the form from any browser on any device without needing a Google account, as long as the form is not restricted to internal users only. Notification emails are sent from the form administrator's Google account to any valid email address.
Yes. Only the form administrator needs a Google account. Employees can submit the form from any browser on any device without needing a Google account, as long as the form is not restricted to internal users only. Notification emails are sent from the form administrator's Google account to any valid email address.
What happens if an employee's manager changes?
You update the Manager Lookup sheet in Google Sheets. Change the manager's email address in Column B next to the employee's email address in Column A. The next time that employee submits a time-off request, it will be routed to the new manager. No changes to the form or the add-on are needed.
You update the Manager Lookup sheet in Google Sheets. Change the manager's email address in Column B next to the employee's email address in Column A. The next time that employee submits a time-off request, it will be routed to the new manager. No changes to the form or the add-on are needed.
Can I generate the PTO document as a PDF?
Yes. Fast Forms can generate documents from Google Docs or Google Slides templates and deliver them as Google Docs, Google Slides, or PDF. If you want a PDF attached to the notification email, select PDF as the output format when configuring the template in the add-on.
Yes. Fast Forms can generate documents from Google Docs or Google Slides templates and deliver them as Google Docs, Google Slides, or PDF. If you want a PDF attached to the notification email, select PDF as the output format when configuring the template in the add-on.
What if I need manager approval before the time-off is granted?
If your process requires a formal approval step, we recommend Form Approvals — a dedicated Google Forms add-on for approval workflows built by the same team as Fast Forms. With Form Approvals, a manager can approve or reject the request directly from the notification email with one click. It has over 10,000,000 installs.
If your process requires a formal approval step, we recommend Form Approvals — a dedicated Google Forms add-on for approval workflows built by the same team as Fast Forms. With Form Approvals, a manager can approve or reject the request directly from the notification email with one click. It has over 10,000,000 installs.
How much does this cost?
Google Forms is free. Fast Forms offers a Free plan with up to 30 notifications per month. The Individual plan is $4/month billed annually, and the Team plan is $24/month billed annually. You can install and test everything on the Free plan before upgrading.
Google Forms is free. Fast Forms offers a Free plan with up to 30 notifications per month. The Individual plan is $4/month billed annually, and the Team plan is $24/month billed annually. You can install and test everything on the Free plan before upgrading.
Ready to automate your time-off request process?
Install Fast Forms from the
Google Workspace Marketplace
and start routing requests to the right manager with branded PTO documents. Over 4,000,000 installs and plans starting at Free.
