← Calendar Autopilot · Guides

Events from Google Sheets™ not showing on Google Calendar™? Check these 7 things

Updated November 3, 2026

You ran an import, a script or an add-on to put rows from Google Sheets™ onto Google Calendar™, and the week you're looking at is empty. Usually the events exist and are somewhere you aren't looking, or the rows were skipped before they were ever sent. Work through these in order; the first three take a minute.

1. Search for one event by name

Before anything else, find out whether the events exist at all. In Google Calendar on a computer, click Search at the top right and type the title of one row. The Down arrow at the right of the search box lets you pick which calendars to search and a date range. Google's search help notes results are limited to 200 events.

• Found it on a different date? Jump to checks 4 to 6 (time zone, text dates, wrong year).
• Found it on a different calendar? See check 2.
• Not found anywhere? The events were never created. Go to check 7.

2. The events went to a different calendar

Many tools default to your primary calendar (the one with your name). Google's CSV import imports into the primary calendar unless you choose another one, and a script that calls CalendarApp.getDefaultCalendar() also uses the default one. If you meant a shared team calendar, the events are probably sitting on your own. Open one, check the calendar name shown on it, and move or re-create them on the right one.

The reverse happens too: events went to the right shared calendar, but the person looking doesn't have that calendar added or shared with them. Sharing is set from the calendar's Settings and sharing page (Google's steps).

3. The calendar is hidden

In the left panel, under My calendars and Other calendars, each calendar has a checkbox. Calendars without a check aren't drawn on the grid. If "My calendars" is collapsed, click it to expand it. Tick the calendar your events went to.

4. The time zone moved them

If events show up hours off, or on the day before or after, a time zone doesn't match. Google Sheets has its own time zone under File, then Settings (Google's steps), and Google Calendar has a primary time zone under Settings, then General, then Time zone (Google's steps). A sheet set to London and a calendar set to New York will put a 9:00 AM row at 4:00 AM. Set the sheet's time zone to where the events actually happen, then re-sync or re-import.

5. The date is stored as text

A cell can look like a date and still be text: pasted from email, typed with a format your locale doesn't recognize, or imported from another system. Scripts that check for real dates skip those rows, and imports may misread them.

• Type =ISNUMBER(B2) next to a date. A real date returns TRUE, because Sheets counts dates as days since December 30, 1899. FALSE means text.
• Fix a column with =DATEVALUE(B2) (Google's notes: it reads text "in a known format" and gives a number, so format the result as a date). Then copy the results and paste them back as values.
• Check day-first vs month-first. In a US-locale sheet, 03/11/2026 means March 11; in many other locales it means 3 November. The spreadsheet's locale is next to its time zone in File, then Settings.

6. The year is wrong

Dates typed without a year, or with a two-digit year, sometimes land in a year you didn't intend. Look at a few rows with the cell formatted to show the full four-digit year. Then search Calendar with a wide date range, as in check 1.

7. The events were never created

• CSV import: if Calendar shows an error, Google says "you might be able to fix the formatting." Start with the headers: they must be the exact English names (Subject, Start Date and so on), and Subject and Start Date are required.
• Apps Script: open the script editor (Extensions, then Apps Script), click Executions on the left, and filter by status for Failed and Timed out (Google's steps). Google's quota page lists a daily cap on calendar events a script can create (5,000 a day on a personal account) and a 6-minute limit per run, so a long sheet can stop partway.
• Permissions: you can only add events to a calendar you're allowed to change. On a shared calendar, ask the owner for one of the "Make changes" permission levels.

Still nothing?

Try one row: make a copy of the sheet with a single simple row (a title, tomorrow's date, 10:00 AM), send it to your own primary calendar, and look at tomorrow. If that works, the problem is in the data, and you can add rows back until one breaks.

Calendar Autopilot takes the guessing out of this. It writes a status on every row: ✓ with the date, time and calendar name once it has read the event back from Google, or ⚠ with the reason in plain words, such as "No date in column B." or "Couldn't read "Nov 31" in column B as a date." It also reads typed dates as well as real date cells, and uses the spreadsheet's own time zone.

Google Sheets™, Google Calendar™, Google Apps Script™ and Google Workspace Marketplace™ are trademarks of Google LLC. Calendar Autopilot is made by Coding Friend LLC and is not affiliated with or endorsed by Google.