Attendance Tracker for Google Sheets™

Attendance tracker add-on for Google Sheets™ - Create a sign-in sheet template in a few clicks and pre-populate attendance data for quick attendance.

icon of a checkmark

View attendance summaries and visualize student attendance summaries for graduation, grading, or students at risk.

icon of a checkmark

Pre-populate a class attendance sign-in sheet in a single click, based on your class schedule.

icon of a checkmark

Generate a monthly attendance table with 1-Click.

icon of a checkmark

Looks clean! Color coded labels, 1-Click Buttons, and Charts.

How to Use

Teacher's favorite attendance tracker add-on

Install The Add-on

  1. Install Attendance Tracker by OneTap
  2. Please authorise when asked.

1. Create a Sign-in Sheet Template

Create a sign-in sheet template for the current month or custom date range; the add-on auto-creates the headers for you.

Attendance Tracker AddOn by OneTap
Automate Attendance Tracker AddOn

2. Add your student names

In the 'Name' column, enter the names of the students attending the class. Add their corresponding IDs and email addresses according to your specific needs.

3. Auto Mark Attendance

Effortlessly populate your attendance sheet across the dates, and specify rules based on your class schedules, such as Week-Off on weekends and Leaves on Fridays.

Track Attendance Automatically
Capture attendance in one click

4. Take Attendance In 1-Click

Mark attendance in a single click! Instantly mark attendance without manual typing by selecting the appropriate action.

5. Attendance Analytics

View summaries of all present and absences, leaves, and holidays in real-time. Elevate your decision-making with analytics.

Attendance Analytics by OneTap AddOn
Individual Attendance Records

6. Dig Into Student Attendance

Identify students at risk and attendance patterns to meet graduation or grading requirements. View visualized charts and attendance summaries, such as the number of times they have presented or missed classes.


I Don’t See the Add-on Screen Shown in the Screenshots Above!

Click on the Side Panel icon in the bottom right corner > Open the side panel and click on the OneTap icon.

Attendance Tracker AddOn by OneTap App

If the add-on screen still doesn't appear in the side panel, a simple refresh or restart can resolve the issue.

Are the Email and Phone Fields Important? (or Is it Safe to Remove Email and Phone Fields?)

Name, Email, and phone columns/fields are necessary to maintain the data integrity and proper functioning of the attendance actions on the add-on. Reserved fields A1, B1 and C1. Dates column start from D1.

Can I have a Custom Date Range for Attendance?

Yes, you can toggle the date range option from auto headers section and select any desired start and end dates and the add-on will create columns based on that.

I have a fixed pattern of attendance per week, can I auto mark all students/person in a single click? I barely few changes manually needed.

Yes, you may exercise the auto mark feature and fill up your weekly attendance pattern.

Add-On Is Not Loading

Un-install and Re-install Add-On. Refresh your browser. Add-Ons > Get Add-Ons And Install Again.

What Browsers are Supported?

Make sure you are using Chrome or Edge Browser or try both.