← ddigger

Event calendar from Google Sheets

Import a public Sheet. ddigger publishes instructions, schema, and a filterable /data API for AI agents. The example below filters event rows by city.

Preview event example

Separate live source: World Bank countries

From Sheet rows to matching events

The City events calendar example has three rows. Imagine them in one public Google Sheets tab, with field names in the first row.

Sheet rows

Illustrative public Sheet tab
eventcitymonth
MeetupPragueOctober
WorkshopBrnoNovember
LaunchPragueDecember

Focused request

GET /data?fields=event,month&where=city:eq:Prague&limit=10

Matching rows

Selected event and month fields
eventmonth
MeetupOctober
LaunchDecember

Meetup in October and Launch in December match the Prague filter.

The preloaded example uses the same rows. Import your own Sheet to test the URL flow.

Use your own Google Sheet

  1. Set one tab to “anyone with the link” view access.
  2. Copy its tab URL, including #gid=, and import it in the creator.
  3. Review the rows and fields, then publish. Preview does not require sign-in; publishing requires an account.

The imported rows form a snapshot. After publishing, you can Enable daily refresh in Data. Changed rows publish a new version; refresh is not instant synchronization and the API cannot edit the Sheet.

Published source

Your publication serves /llms.txt instructions, an /openapi.json schema, focused /data queries, and a generated human page. The latest URL follows republished data; a pinned /v/{version} URL retains an exact version. For live endpoint responses, inspect this separate country source: instructions, schema, and data.