Data Sync & ETLfree

Import API Data Into Sheets

by Javier HitaUpdated Aug 2026

Requires

Google Sheets

1/5

STEPS · 11

Run manually by an operator

On manual run, fetches API data, transforms it in code, and writes the batched results into Google Sheets.

Sync Google Sheets With Salesforce

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

On manual run, reads Google Sheets data, enriches it via an HTTP request, and exports a spreadsheet file.

On manual run, reads rows from Google Sheets, sets fields, and stores them in the customer datastore.