Zapier (Catch Hook + Tables/Sheets)

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

Setup Steps

1. Create a Zap → Trigger: “Webhooks by Zapier” → “Catch Hook” → copy the URL.
2. In Lection, set delivery channel to "Zapier" and paste the hook URL.
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.

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

• Zapier Catch Hook docs
• Zapier Tables docs

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.