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 / Data Sync & ETL

Data Sync & ETL

Map Google Sheets CSV rows into Airtable fields on app event trigger

Runs when an app event fires. Reads a Google Sheets CSV file and writes its rows to an Airtable base, so column names and field data types must match the Airtable fields.

Import it free Sign in to open it

What it does

## Confirm the key names and column references When adapting this to your own base and Google Sheets (CSV) template, make sure to modify this node accordingly, as key values you will need to set the Airtable Fields, and the Expressions need to match the Read File column names Make sure that the fields have the correct data type (Strings, Integers (numbers), etc)

The steps

  1. Get File ID
  2. Status Failed
  3. Status Uploaded
  4. Campaign is Not Empty
  5. Campaign Not Empty
  6. Campaign Not Empty1
  7. Read File
  8. Airtable Base IDs
  9. Status Processing
  10. Download File
  11. Create Records
  12. New Upload

Similar automations

Data Sync & ETLLoad CSV Attachments into Airtable with Claude11 stepsData Sync & ETLImport CSV Files into Postgres4 stepsData Sync & ETLImport a CSV from a URL into Google Sheets6 stepsData Sync & ETLImport CSV from URL into Google Sheets on Manual Run6 steps