Google Sheets rows not all uploading to Google Calendar


I have a zap set up from my Google sheets to my Google calendar.


It's a list of Instagram topics with columns of:

date - start time - end time - topic - and notes

The dates are listed daily from today, right up until late September. They are formatted as dates.


The zap works both in the test and when I launched it, however some random dates are missing on the Google sheet (which they are not)

Attached are pics of the sheet and the purple 🟣 in the calendar are the zaps that have worked. There should be a 🟣 event every single day.

Is this an issue with my sheet or the zap?


2 replies

Userlevel 7
Badge +11

Hi @Jboyle23, welcome to the Community!

My first thought here is that it could be that there’s a difference in the formatting of the date that Google Calendar is expecting to receive and that’s causing it to not add the dates to the right day. Which might be making them appear as if they are missing.

For example Google Calendar expects the dates to come in MM/DD/YYYY format so it could be that it’s not interpreting the date correctly and swapping the day and the month around. We have a help guide that explains this further: Is the event created on the wrong date, specifically with the month and day switched? 

Do you think that could be the case here? 

Userlevel 7
Badge +14

Hi @Jboyle23 

Good question.

An alternative approach...

Use Airtable instead of GSheets.

Airtable has Automations.

Airtable Automations have a native integration with GCal.