Skip to content

feat(trigger): add Google Sheets, Drive, and Calendar polling triggers #4081

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
waleedlatif1 merged 19 commits into from
Apr 10, 2026
Merged

feat(trigger): add Google Sheets, Drive, and Calendar polling triggers #4081

Changes from 1 commit
Commits
Show all changes
19 commits
Select commit Hold shift + click to select a range
06b68f7
feat(trigger): add Google Sheets, Drive, and Calendar polling triggers
waleedlatif1 Apr 9, 2026
a898413
fix(polling): address PR review feedback for Google polling triggers
waleedlatif1 Apr 9, 2026
43ce2cc
fix(polling): fix Drive pre-check never activating in Sheets poller
waleedlatif1 Apr 9, 2026
e563f6d
chore(lint): fix import ordering in triggers registry
waleedlatif1 Apr 9, 2026
cfcc208
fix(polling): address PR review feedback for Google polling handlers
waleedlatif1 Apr 9, 2026
9df3c07
fix(polling): prevent data loss on partial row failures and harden id…
waleedlatif1 Apr 9, 2026
d32e1cb
fix(polling): remove unused variable and preserve lastModifiedTime on…
waleedlatif1 Apr 9, 2026
a8baa49
fix(polling): don't advance state when all events fail across sheets,…
waleedlatif1 Apr 9, 2026
9c8640f
fix(polling): retry failed idempotency keys, fix drive cursor oversho…
waleedlatif1 Apr 10, 2026
7d383be
fix(polling): revert calendar timestamp on any failure, not just all-…
waleedlatif1 Apr 10, 2026
f89a70a
fix(polling): revert drive cursor on any failure, not just all-fail
waleedlatif1 Apr 10, 2026
2180127
feat(triggers): add canonical selector toggle to google polling triggers
waleedlatif1 Apr 10, 2026
dddd642
test(blocks): handle trigger-advanced mode in canonical validation tests
waleedlatif1 Apr 10, 2026
5c53822
fix(triggers): handle trigger-advanced mode in deploy, preview, param…
waleedlatif1 Apr 10, 2026
033d2ee
fix(polling): use position-only idempotency key for sheets rows
waleedlatif1 Apr 10, 2026
d1ae3b2
fix(polling): don't advance calendar timestamp to client clock on emp…
waleedlatif1 Apr 10, 2026
ef82ce6
fix(polling): remove extraneous comment from calendar poller
waleedlatif1 Apr 10, 2026
66e0188
fix(polling): drive cursor stall on full page, calendar latestUpdated…
waleedlatif1 Apr 10, 2026
9a33570
fix(polling): advance calendar cursor past fully-filtered event batches
waleedlatif1 Apr 10, 2026
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
fix(polling): don't advance calendar timestamp to client clock on emp… 
…ty poll
  • Loading branch information
@waleedlatif1
waleedlatif1 committed Apr 10, 2026
commit d1ae3b291acfc8281793de4781d86f654a6d4272
14 changes: 6 additions & 8 deletions apps/sim/lib/webhooks/polling/google-calendar.ts
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -101,13 +101,12 @@ export const googleCalendarPollingHandler: PollingProviderHandler = {

const config = webhookData.providerConfig as unknown as GoogleCalendarWebhookConfig
const calendarId = config.calendarId || config.manualCalendarId || 'primary'
const now = new Date()

// First poll: seed timestamp, emit nothing
if (!config.lastCheckedTimestamp) {
await updateWebhookProviderConfig(
webhookId,
{ lastCheckedTimestamp: now.toISOString() },
{ lastCheckedTimestamp: new Date().toISOString() },
logger
)
await markWebhookSuccess(webhookId, logger)
Expand All @@ -119,11 +118,10 @@ export const googleCalendarPollingHandler: PollingProviderHandler = {
const events = await fetchChangedEvents(accessToken, calendarId, config, requestId, logger)

if (!events.length) {
await updateWebhookProviderConfig(
webhookId,
{ lastCheckedTimestamp: now.toISOString() },
logger
)
// Do not advance the timestamp when no events are found — only server-side timestamps
// from actual event responses are used to advance the cursor. Advancing to the client
// clock risks skipping events whose server-side updated timestamp falls in any clock
// skew gap between the client and Google's servers.
await markWebhookSuccess(webhookId, logger)
logger.info(`[${requestId}] No changed events for webhook ${webhookId}`)
return 'success'
Expand All @@ -146,7 +144,7 @@ export const googleCalendarPollingHandler: PollingProviderHandler = {
? config.lastCheckedTimestamp
: latestUpdated
? new Date(new Date(latestUpdated).getTime() + 1).toISOString()
: now.toISOString()
: config.lastCheckedTimestamp
await updateWebhookProviderConfig(webhookId, { lastCheckedTimestamp: newTimestamp }, logger)
Comment thread
waleedlatif1 marked this conversation as resolved.
Comment thread
waleedlatif1 marked this conversation as resolved.

if (failedCount > 0 && processedCount === 0) {
Expand Down
Loading