Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Data Sync & ETL

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

  1. Lection webhook
  2. Secret matches?
  3. Respond 401
  4. Completed run with rows?
  5. Respond skipped
  6. Split records
  7. Append or update rows
  8. Summarize
  9. Respond 200

Similar automations