Data Sync & ETL
Upsert Lection scrape results into Google Sheets with duplicate matching
Receives scraped rows from Lection via webhook, checks an optional secret, and appends or updates matching rows in a Google Sheet keyed on a unique column.
What it does
## Lection to Google Sheets (dedupe) 1. Create a Google Sheet with a header row. Column names must match the scraped column names exactly. 2. In this workflow, set the Sheet ID in the *Append or update rows* node and the unique column in its *Matching columns* field. 3. Set REPLACE_WITH_LECTION_SECRET in the *Secret matches?* node to the same value you enter as the webhook secret in Lection (or delete that node if you do not use a secret). 4. Activate the workflow, then copy the production webhook URL into Lection.
The steps
- Lection webhook
- Secret matches?
- Respond 401
- Completed run with rows?
- Respond skipped
- Split records
- Append or update rows
- Summarize
- Respond 200
Similar automations
Tasks & Project ManagementArchive Duplicate Items in a Notion Database7 stepsData Sync & ETLArchive Duplicate Items in a Notion Database8 stepsData Sync & ETLSync Mastodon bookmarks to Wallabag with Data Tables and duplicate checks15 stepsFinance, Invoices & AccountingFlag possible duplicate supplier invoices in Google Sheets before payment with Slack9 steps