Skip to main content

Tutorials / Webhook Integrations / Zapier (Catch Hook + Tables/Sheets)

Zapier (Catch Hook + Tables/Sheets)

Trigger a Zap from Lection, then fan out to Zapier Tables, Sheets, or any Zapier action.

Ideal for: No-code automations and quick table inserts.

Setup Steps

  1. Create a Zap → Trigger: “Webhooks by Zapier” → “Catch Hook” → copy the URL.
  2. In Lection, set delivery channel to Webhook and paste the hook URL (optional: set webhook secret).
  3. Run a test scheduled scrape so Zapier can “Test trigger” and capture the sample payload.
  4. Add an Action: Zapier Tables “Create Record” or Google Sheets “Create Spreadsheet Row”.
  5. Map fields from dataset.records[*] into your table columns; publish the Zap.

Mapping Tips

  • dataset.records is an array; use dataset.records[0].ColumnName for single-row inserts or Looping/Code to iterate all rows.
  • Include download.url if you want a signed link to the exported file.
  • Filter on header X-Lection-Secret if you set a secret in Lection.

Payload highlights

  • event: scheduled_scrape.completed, version: 1, delivered_at: ISO timestamp.
  • schedule: id, name, mode, cadence, timezone, target_url, metadata.
  • run: id, status, started_at, completed_at, rows_extracted, link_count, detail_page_count, error_message, metadata.
  • dataset: rowCount, columns, records (array of objects keyed by columns).
  • download: { url, expires_in_seconds } or null.

Helpful links

Test checklist

  • Set webhook URL and optional secret in Lection.
  • Run a scheduled scrape to capture sample data.
  • Confirm dataset.records and download.url arrive in your tool.
  • Publish/activate the workflow so production runs stay wired.