n8n Workflow: SmartLead Sheet Sync (Airtable Edition)

This n8n workflow provides a robust solution for synchronizing data from an external source into an Airtable base. It's designed to be triggered by an external event and then process that data, making it available in your Airtable tables.

What it does

This workflow automates the following steps:

1. Receives Data: It listens for incoming data via a webhook, acting as the entry point for your synchronization process.
2. Processes Data (Code Node): A custom code node is included, allowing for flexible data transformation, validation, or enrichment before the data is sent to Airtable. This is where you can implement specific logic to format your incoming data to match your Airtable schema.
3. Updates/Creates Airtable Records: The processed data is then sent to Airtable, where it can be used to create new records or update existing ones in a specified base and table.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Airtable Account: Access to an Airtable account with a base and table where you want to store or update data.
• Airtable API Key: An API key for your Airtable account (configured as an n8n credential).
• Airtable Base ID and Table Name: The specific ID of your Airtable base and the name of the table you intend to interact with.
• External System/Application: An external system or application configured to send data to the n8n webhook URL.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, click "New Workflow" and then "Import from JSON".
   • Paste the JSON content or upload the file.
2. Configure Credentials:
   • Click on the "Airtable" node.
   • Select or create a new "Airtable API" credential. You will need to provide your Airtable API Key.
3. Configure Airtable Node:
   • In the "Airtable" node, specify the "Base ID" and "Table Name" where you want to store your data.
   • Adjust the "Operation" (e.g., "Create," "Update," "Create or Update") and map the incoming data fields to your Airtable table columns as needed.
4. Configure Webhook Trigger:
   • Click on the "Webhook" node.
   • Copy the "Webhook URL". This is the URL your external system will send data to.
   • Ensure the "HTTP Method" matches what your external system will use (e.g., POST).
5. Customize Code Node (Optional but Recommended):
   • Open the "Code" node.
   • Modify the JavaScript code to transform the incoming data from the webhook into the desired format for your Airtable table. This is crucial for ensuring data integrity and correct mapping.
6. Activate the Workflow:
   • Once configured, activate the workflow by toggling the "Active" switch in the top right corner of the n8n editor.

Your workflow is now ready to receive data from your external system and sync it with Airtable!