Airtable Writer

This document explains the Airtable Writer node, which lets you create new records in your Airtable bases automatically.

​

Node Inputs

​

Required Fields

• Base: Choose your Airtable base
• Table: Select the table where you want to write data
• Writer Mode: Choose how to write data
  • Add New Rows: Creates multiple rows from a list input
  • Add A Single New Row: Creates one row from a text input
• Column Inputs: Match your data to table columns
  • Each input must match the column’s data type
  • Example: Text for text fields, numbers for numeric fields

​

Node Output

• Link to your Airtable base after successful write
• Any error messages if the operation fails

​

Node Functionality

The Airtable Writer node creates new records in your Airtable bases:

• Matches your data to table columns
• Supports single or multiple row creation
• Maintains secure authentication through Gumloop

​

Example Workflows

​

1. Process Form Submissions

Get Typeform Responses → Airtable Writer
Setup:
- Writer Mode: Add New Rows
- Table: Customer Feedback
- Column Mapping:
  - Name → Name
  - Email → Email
  - Rating → Score
  - Feedback → Comments
Next Steps: Use Airtable Reader to analyze feedback trends

​

2. Lead Generation Pipeline

LinkedIn Profile Scraper → Extract Data → Airtable Writer
Setup:
- Writer Mode: Add New Rows
- Table: Sales Leads
- Column Mapping:
  - Full Name → Contact Name
  - Company → Organization
  - Title → Position
  - Location → Region
Next Steps: Connect with Salesforce Updater for CRM sync

​

3. Content Calendar Management

RSS Feed Reader → AI List Sorter → Airtable Writer
Setup:
- Writer Mode: Add New Rows
- Table: Content Ideas
- Column Mapping:
  - Title → Post Title
  - Link → Source URL
  - Published Date → Date
  - Summary → Description
Next Steps: Use Ask AI to generate content briefs

​

4. Support Ticket Logging

Gmail Reader → Categorizer → Airtable Writer
Setup:
- Writer Mode: Add A Single New Row
- Table: Support Tickets
- Column Mapping:
  - Subject → Issue
  - Sender → Customer Email
  - Category → Ticket Type
  - Body → Description
Next Steps: Use Slack Message Sender for team notifications

​

Best Practices

​

Writer Mode Selection

• Use “Add New Rows” when:

  • Processing batches of data
  • Working with List type input/outputs
  • Handling multiple records at once

• Use “Add A Single New Row” when:

  • Processing individual items
  • Working with single text input/output
  • Creating one record at a time

​

Important Notes

​

Authentication

1. Set up Airtable credentials in Gumloop Credentials
2. Ensure proper base and table permissions
3. For updating existing records, use the Airtable Updater node instead

In summary, the Airtable Writer node provides a straightforward way to create new records in your Airtable bases.