Google Sheets Integration

1// Google Apps Script for SudoMock Integration
2const SUDOMOCK_API_KEY = 'YOUR_API_KEY';
3const API_URL = 'https://api.sudomock.com/api/v1/renders';
4
5// Template configuration
6const TEMPLATES = {
7  't-shirt': { mockup_uuid: 'your-tshirt-uuid', smart_object_uuid: 'your-so-uuid' },
8  'mug': { mockup_uuid: 'your-mug-uuid', smart_object_uuid: 'your-so-uuid' },
9  'poster': { mockup_uuid: 'your-poster-uuid', smart_object_uuid: 'your-so-uuid' },
10  'hoodie': { mockup_uuid: 'your-hoodie-uuid', smart_object_uuid: 'your-so-uuid' }
11};
12
13/**
14 * Generate mockups for all rows with design URLs
15 * Run this function from the Apps Script editor
16 */
17function generateAllMockups() {
18  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
19  const data = sheet.getDataRange().getValues();
20  
21  // Skip header row
22  for (let i = 1; i < data.length; i++) {
23    const designUrl = data[i][0];
24    const productType = data[i][1]?.toLowerCase();
25    const mockupUrl = data[i][2];
26    
27    // Skip if no design URL or already processed
28    if (!designUrl || mockupUrl) continue;
29    
30    // Update status
31    sheet.getRange(i + 1, 4).setValue('Processing...');
32    SpreadsheetApp.flush();
33    
34    try {
35      const result = generateMockup(designUrl, productType);
36      sheet.getRange(i + 1, 3).setValue(result.mockupUrl);
37      sheet.getRange(i + 1, 4).setValue('Done');
38    } catch (error) {
39      sheet.getRange(i + 1, 4).setValue('Error: ' + error.message);
40    }
41    
42    // Small delay to stay within parallel limits
43    Utilities.sleep(500);
44  }
45  
46  SpreadsheetApp.getUi().alert('Mockup generation complete!');
47}
48
49/**
50 * Generate a single mockup
51 */
52function generateMockup(designUrl, productType) {
53  const template = TEMPLATES[productType];
54  
55  if (!template) {
56    throw new Error('Unknown product type: ' + productType);
57  }
58  
59  const payload = {
60    mockup_uuid: template.mockup_uuid,
61    smart_objects: [{
62      uuid: template.smart_object_uuid,
63      asset: { url: designUrl }
64    }],
65    export_options: {
66      image_format: 'webp',
67      image_size: 2000,
68      quality: 95
69    }
70  };
71  
72  const options = {
73    method: 'post',
74    contentType: 'application/json',
75    headers: {
76      'X-API-KEY': SUDOMOCK_API_KEY
77    },
78    payload: JSON.stringify(payload),
79    muteHttpExceptions: true
80  };
81  
82  const response = UrlFetchApp.fetch(API_URL, options);
83  const result = JSON.parse(response.getContentText());
84  
85  if (!result.success) {
86    throw new Error(result.detail || 'API error');
87  }
88  
89  return {
90    mockupUrl: result.data.print_files[0].export_path
91  };
92}
93
94/**
95 * Add custom menu to spreadsheet
96 */
97function onOpen() {
98  SpreadsheetApp.getUi()
99    .createMenu('SudoMock')
100    .addItem('Generate All Mockups', 'generateAllMockups')
101    .addItem('Generate Selected Row', 'generateSelectedRow')
102    .addToUi();
103}
104
105/**
106 * Generate mockup for currently selected row
107 */
108function generateSelectedRow() {
109  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
110  const row = sheet.getActiveCell().getRow();
111  
112  if (row === 1) {
113    SpreadsheetApp.getUi().alert('Please select a data row, not the header.');
114    return;
115  }
116  
117  const designUrl = sheet.getRange(row, 1).getValue();
118  const productType = sheet.getRange(row, 2).getValue()?.toLowerCase();
119  
120  if (!designUrl) {
121    SpreadsheetApp.getUi().alert('No design URL in selected row.');
122    return;
123  }
124  
125  sheet.getRange(row, 4).setValue('Processing...');
126  
127  try {
128    const result = generateMockup(designUrl, productType);
129    sheet.getRange(row, 3).setValue(result.mockupUrl);
130    sheet.getRange(row, 4).setValue('Done');
131    SpreadsheetApp.getUi().alert('Mockup generated successfully!');
132  } catch (error) {
133    sheet.getRange(row, 4).setValue('Error: ' + error.message);
134    SpreadsheetApp.getUi().alert('Error: ' + error.message);
135  }
136}

1// n8n Workflow Structure
21. Google Sheets Trigger
3   - Trigger on: Row Added
4   - Sheet: Your product sheet
5
62. HTTP Request (SudoMock)
7   - POST https://api.sudomock.com/api/v1/renders
8   - Headers: X-API-KEY = {{ $credentials.sudomockApi.apiKey }}
9   - Body: Dynamic based on row data
10
113. Google Sheets Update
12   - Update row with mockup URL