Frontier Engineering
← All workflows

Google Sheets & Data · Beginner

Sheets Data Cleaning Pipeline

Runs nightly to read a raw Google Sheet, removes duplicate rows by email, normalizes names and phone numbers, then writes clean records to a separate sheet.

Google SheetsCode

What's inside · 5 nodes

  • scheduleTrigger
  • googleSheets
  • removeDuplicates
  • code