Data Sync & ETLfree

Sync Facebook Lead Ads to Google Sheets & Salesforce CRM

by Candra RezaUpdated Aug 2026

Requires

Google Sheets

Salesforce

1/5

FLOWS

STEPS · 4

Starts on a Facebook Lead Ads event

On a new Facebook lead ad, appends the lead to Google Sheets and creates the corresponding record in Salesforce.

Audio Transcription Pipeline

On a new Google Drive file, transcribes audio with AWS Transcribe, stores it in S3, and logs to Google Sheets.

When a file appears in Google Drive, fetches and processes it via HTTP, then merges and logs the results into Google Sheets.

On manual trigger, reads Google Sheets rows, matches them against Salesforce records, and merges the combined data.