Step 1: Import the Airtable Template
- Go to https://airtable.com/appPfiL0Crk0reO9O/shrYSnhv53n0UZHWD
- Click "Copy base" to import the template to your Airtable workspace
- Once imported, you'll see the following tables:
- Products
- Ad Angles
- Scripts
- Ad Performance
- Winning Scripts
Step 2: Set Up Airtable Interface
The template includes a pre-built interface, but if you need to customize it:
- Click "Interface" in the top right corner of Airtable
- The interface contains 5 key sections:
- Initial Product Research
- Ad Angle Generation & Selection
- Script Generation & Review
- Performance Tracking
- Winning Script Selection
Step 3: Configure Airtable Automations
You'll need to set up 5 key automations in Airtable that will trigger your n8n workflows:
- Go to "Automations" in Airtable
- Create these 5 automations:
- Generate Product Details: Triggers when "Generate Product Details" checkbox is checked
- Generate Product Angles: Triggers when "Generate Angles" checkbox is checked
- Generate Scripts: Triggers when "Generate Script" button is clicked
- Feedback Iteration: Triggers when feedback is submitted
- Best Ads: Triggers when an ad is marked as a "best ad"
For each automation:
- Set the trigger condition (e.g., "When record matches conditions")
- Add an action to update the status field (optional but helpful for UX)
- Add a "Run Script" action to call your n8n webhook
- Use this code pattern for the webhook call:
// Example for "Generate Product Details" automation
const recordId = "{{recordId()}}";
fetch("YOUR_N8N_WEBHOOK_URL", {
method: "POST",
headers: {
"Content-Type": "application/json"
},
body: JSON.stringify({
recordId: recordId,
action: "generate_product_details"
})
})
.then(response => response.json())
.then(data => {
console.log("Success:", data);
})
.catch(error => {
console.error("Error:", error);
});