Bulk calendar events from a spreadsheet, with results written back

The scenario reads rows from таблица, creates the corresponding events in Home Assistant and marks in the sheet what succeeded and what did not.

  • The whole schedule moves into the calendar in one run
  • Already-created events are skipped — no duplicates
  • You can see exactly which rows failed and need attention
  • The spreadsheet stays the source of truth for the schedule
Google Sheets
Set it up for yourselfScriptera

How it works

To move data from Home Assistant to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Manual Trigger
  2. Then: Read Sheet
  3. Check: Check Status Spreadsheets
  4. If yes: Create Event
  5. Check: Check If Error
  6. If yes: Update Sheet (Created)
  7. If no: Update Sheet (Failed)

You can launch this Home Assistant + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios