Airtable Integration

1
// Airtable Automation Script
2
// Input variables: designUrl, productType, recordId
3
4
const SUDOMOCK_API_KEY = 'YOUR_API_KEY';
5
6
// Template UUIDs for each product type
7
const TEMPLATES = {
8
  't-shirt': { mockup: 'tshirt-uuid', smartObject: 'so-uuid' },
9
  'mug': { mockup: 'mug-uuid', smartObject: 'so-uuid' },
10
  'poster': { mockup: 'poster-uuid', smartObject: 'so-uuid' }
11
};
12
13
const template = TEMPLATES[input.productType.toLowerCase()];
14
15
if (!template) {
16
  throw new Error(`Unknown product type: ${input.productType}`);
17
}
18
19
// Call SudoMock API
20
const response = await fetch('https://api.sudomock.com/api/v1/renders', {
21
  method: 'POST',
22
  headers: {
23
    'X-API-KEY': SUDOMOCK_API_KEY,
24
    'Content-Type': 'application/json'
25
  },
26
  body: JSON.stringify({
27
    mockup_uuid: template.mockup,
28
    smart_objects: [{
29
      uuid: template.smartObject,
30
      asset: { url: input.designUrl }
31
    }],
32
    export_options: {
33
      image_format: 'webp',
34
      image_size: 2000,
35
      quality: 95
36
    }
37
  })
38
});
39
40
const result = await response.json();
41
42
if (!result.success) {
43
  throw new Error(result.detail);
44
}
45
46
// Return mockup URL to update the record
47
output.set('mockupUrl', result.data.print_files[0].export_path);

1
// n8n Workflow
2
1. Airtable Trigger
3
   - Table: Products
4
   - Trigger On: Record Created
5
6
2. HTTP Request (SudoMock)
7
   - Method: POST
8
   - URL: https://api.sudomock.com/api/v1/renders
9
   - Headers: X-API-KEY = YOUR_API_KEY
10
   - Body: {
11
       "mockup_uuid": "{{ $json.product_type_uuid }}",
12
       "smart_objects": [{
13
         "uuid": "{{ $json.smart_object_uuid }}",
14
         "asset": { "url": "{{ $json.Design_URL }}" }
15
       }]
16
     }
17
18
3. Airtable Update
19
   - Record ID: {{ $('Airtable Trigger').item.json.id }}
20
   - Fields: { "Mockup_URL": "{{ $json.data.print_files[0].export_path }}" }

1
import Airtable from 'airtable';
2
3
const base = new Airtable({ apiKey: process.env.AIRTABLE_API_KEY })
4
  .base(process.env.AIRTABLE_BASE_ID);
5
6
const SUDOMOCK_API_KEY = process.env.SUDOMOCK_API_KEY;
7
8
async function processPendingRecords() {
9
  // Get all pending records
10
  const records = await base('Products')
11
    .select({
12
      filterByFormula: "{Status} = 'Pending'",
13
      maxRecords: 50
14
    })
15
    .all();
16
17
  console.log(`Processing ${records.length} records...`);
18
19
  for (const record of records) {
20
    try {
21
      // Update status to Processing
22
      await record.updateFields({ Status: 'Processing' });
23
24
      // Generate mockup
25
      const response = await fetch('https://api.sudomock.com/api/v1/renders', {
26
        method: 'POST',
27
        headers: {
28
          'X-API-KEY': SUDOMOCK_API_KEY,
29
          'Content-Type': 'application/json'
30
        },
31
        body: JSON.stringify({
32
          mockup_uuid: getTemplateUuid(record.get('Product Type')),
33
          smart_objects: [{
34
            uuid: getSmartObjectUuid(record.get('Product Type')),
35
            asset: { url: record.get('Design URL') }
36
          }]
37
        })
38
      });
39
40
      const result = await response.json();
41
42
      if (result.success) {
43
        await record.updateFields({
44
          'Mockup URL': result.data.print_files[0].export_path,
45
          Status: 'Done'
46
        });
47
        console.log(`✓ ${record.id}`);
48
      } else {
49
        throw new Error(result.detail);
50
      }
51
52
    } catch (error) {
53
      await record.updateFields({
54
        Status: 'Error',
55
        Notes: error.message
56
      });
57
      console.error(`✗ ${record.id}: ${error.message}`);
58
    }
59
60
    // Respect rate limits
61
    await new Promise(r => setTimeout(r, 500));
62
  }
63
}
64
65
processPendingRecords();