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

Library / Lead Generation & Enrichment

Lead Generation & Enrichment

Screen Google Sheets leads for cold email compliance with Precleared

Runs every morning, checks new Google Sheets leads against cold email rules in the UK, US, Canada, Germany and France via Precleared, and writes each verdict beside the row.

What it does

## Screen Google Sheets leads for cold email compliance Checks every new lead in your sheet with Precleared and writes the answer next to it, so you know who you can cold email before anyone writes a word. Covers UK PECR and GDPR, US CAN-SPAM, Canada's CASL, Germany's UWG and French rules. ### Who's it for Anyone who keeps prospects in Google Sheets and sends cold email, by hand or from another workflow. ### How it works 1. Every morning reads your sheet and keeps the rows that have no verdict yet. 2. Check with Precleared asks whether a cold email to each address is allowed. 3. Write the verdict back fills in the verdict, the rule behind it, the next step, what the email's footer must include and a signed receipt id. A row Precleared couldn't answer (for example, once the day's free checks are used) stays blank, with the reason in note, and is tried again on the next run. ### How to set up 1. Make a sheet with these column headers: email, address_source, verdict, rule, next_step, footer_requirement, receipt_id, checked_at, note. In address_source, say where each address came from: published, bought, scraped, given or unknown (blank counts as unknown). 2. Pick that sheet in Read leads and in Write the verdict back. 3. Fill in Your settings: your country (GB or US) and what you offer. 4. Run it once to check, then switch it on so it runs every morning. ### Requirements - A Google account for Sheets. - No Precleared account: 10 free checks a day, shared by everyone on your IP address. A free key from precleared.dev/get-key gives you your own 25 a day (best on n8n Cloud). To use it, set Check with Precleared to Header Auth with the name Authorization and the value Bearer pc_live_.... ### How to customize - Change the schedule, or run it when a row is added. - Raise max_checks_per_run once you have a key or a pack. - Send the ok_to_email rows on to your email workflow. Precleared is decision support with sources, not legal advice.

The steps

  1. Every morning
  2. Your settings
  3. Read leads
  4. Not checked yet
  5. Stay within your allowance
  6. Check with Precleared
  7. Prepare the update
  8. Write the verdict back

Similar automations