How can I get the most recent Google Calendar events when using the "get many" option without getting every single event throughout history?

The start/end options are the wrong way around and should be renamed. This is what they actually do:

Start time → Before (at least some part of the event must be before this time)
End time → After (at least some part of the event must be after this time)

Note that if you have recurring events, they will be returned but with the date of the original occurrence, not the occurrence that happens within your window.

Here’s a workflow that fixes this, and also corrects for changes in daylight savings time. (It may not work on n8n versions earlier than 0.216 because of some internal changes we made)

2 Likes