Postare Social Media Vibe coding in Airtable

Pas 0 – Inainte de a incepe

Avem deja create/adaugate:

1. Cont platit Airtable
2. API key OpenAi https://platform.openai.com/api-keys
3. API key Claude https://platform.claude.com/settings/keys
4. API key Zernio https://zernio.com/ + canale de postare deja configurate
5. API key imgbb https://imgbb.com/

Pas 1 – Generare si postare in social media cu Airtable dar fara make.com

• Copiaza tabelul gata facut

In primul script (Aproba=genereaza) folosim scriptul:

const config = input.config();
const recordId = config.recordId;
const idee     = config.idee || "";
// Citeste dimensiunile din record (setate de utilizator in tabel)
const wRaw = parseInt(config.width)  || 1792;
const hRaw = parseInt(config.height) || 1024;

const CLAUDE_API_KEY = input.secret('CLAUDE_API_KEY');
const OPENAI_API_KEY = input.secret('OPENAI_API_KEY');
const IMGBB_API_KEY = input.secret('IMGBB_API_KEY');

// ============================================================
// PASUL 0: Citeste promptul activ din tabelul Prompturi
// ============================================================
console.log("Citesc promptul activ...");

const tblPrompturi = base.getTable("Prompturi");
const queryPrompturi = await tblPrompturi.selectRecordsAsync({
  fields: ["Nume", "Prompt Articol", "Prompt Imagine", "Activ"]
});

const promptRecord = queryPrompturi.records.find(r => r.getCellValue("Activ") === true);
if (!promptRecord) throw new Error("Nu exista niciun prompt activ! Bifeaza campul Activ in tabelul Prompturi.");

const promptArticol = promptRecord.getCellValueAsString("Prompt Articol");
const promptImagine = promptRecord.getCellValueAsString("Prompt Imagine");
console.log("Prompt activ: " + promptRecord.getCellValueAsString("Nume"));

// ============================================================
// PASUL 1: Claude genereaza articolul
// ============================================================
console.log("Generez articolul cu Claude...");

const promptFinal = promptArticol + "\n\nIDEE: " + idee + "\n\nRaspunde DOAR cu JSON valid:\n{\"articol\": \"textul complet al postarii\"}";

const claudeResp = await fetch("https://api.anthropic.com/v1/messages", {
  method: "POST",
  headers: {
    "Content-Type": "application/json",
    "x-api-key": CLAUDE_API_KEY,
    "anthropic-version": "2023-06-01"
  },
  body: JSON.stringify({
    model: "claude-sonnet-4-20250514",
    max_tokens: 1500,
    messages: [{ role: "user", content: promptFinal }]
  })
});

const claudeData = await claudeResp.json();
if (!claudeData.content?.[0]) throw new Error("Eroare Claude: " + JSON.stringify(claudeData));

let articol = "";
try {
  const parsed = JSON.parse(claudeData.content[0].text.trim().replace(/```json|```/g, "").trim());
  articol = parsed.articol || "";
} catch(e) {
  articol = claudeData.content[0].text;
}
console.log("Articol generat!");

// ============================================================
// PASUL 2: DALL-E 3 genereaza imaginea
// 
// Dimensiunea trimisă la DALL-E se alege automat dintre cele 3 valide 
// (1024x1024, 1792x1024, 1024x1792) în funcție de ce ai setat în tabel
// ============================================================
console.log("Generez imaginea...");

const promptImagineFinal = promptImagine + " " + idee;

// DALL-E 3 accepta doar 3 dimensiuni valide — alegem cea mai apropiata
const dimensiuniValide = [
  { w: 1024, h: 1024, label: "1024x1024" },
  { w: 1792, h: 1024, label: "1792x1024" },
  { w: 1024, h: 1792, label: "1024x1792" }
];

const dim = dimensiuniValide.reduce((best, d) => {
  const distCurr = Math.abs(d.w - wRaw) + Math.abs(d.h - hRaw);
  const distBest = Math.abs(best.w - wRaw) + Math.abs(best.h - hRaw);
  return distCurr > 2];
    result += chars[((b0 & 3) > 4)];
    result += i+1 > 6)] : '=';
    result += i+2 

Scriptul 2 (Publica in zernio) folosim scriptul:

const config = input.config();
const recordId = config.recordId;

const ZERNIO_API_KEY  = input.secret('ZERNIO_API_KEY');
const ZERNIO_ACCOUNTS = JSON.parse(input.secret('ZERNIO_ACCOUNT_IDS'));

// ============================================================
// Citeste URL-ul imaginii direct din record
// ============================================================
// Citeste articolul si URL-ul imaginii din Airtable
const tbl    = base.getTable("Postari social media");
const record = await tbl.selectRecordAsync(recordId, { fields: ["Articol", "Adresa-URL"] });

const articol = record.getCellValueAsString("Articol");
const imgUrl  = record.getCellValueAsString("Adresa-URL") || null;

if (!articol) throw new Error("Campul Articol este gol. Genereaza continutul mai intai.");
console.log("Articol citit!");
if (imgUrl) {
  console.log("Imagine gasita: " + imgUrl);
} else {
  console.log("Fara imagine — postare doar text.");
}

// ============================================================
// PASUL 1: Construieste lista de platforme active
// ============================================================

// Publicam pe toate platformele conectate — ajusteaza dupa nevoie
const platforme = [
  { platform: "facebook",  accountId: ZERNIO_ACCOUNTS.facebook  },
  { platform: "linkedin",  accountId: ZERNIO_ACCOUNTS.linkedin  },
  { platform: "instagram", accountId: ZERNIO_ACCOUNTS.instagram },
  { platform: "tiktok",    accountId: ZERNIO_ACCOUNTS.tiktok    }
].filter(p => p.accountId && p.accountId !== ""); // exclude platformele fara account ID

console.log("Platforme active: " + platforme.map(p => p.platform).join(", "));

if (platforme.length === 0) {
  throw new Error("Nu exista niciun account ID configurat in secretul ZERNIO_ACCOUNT_IDS.");
}

// ============================================================
// PASUL 2: Construieste payload-ul pentru Zernio
// ============================================================

// Calculeaza maine la 10:00 ora Bucuresti
const acum = new Date();
const maine = new Date(acum);
maine.setDate(maine.getDate() + 1);

// Formatat ca "YYYY-MM-DDT10:00:00"
const an  = maine.getFullYear();
const luna = String(maine.getMonth() + 1).padStart(2, "0");
const zi   = String(maine.getDate()).padStart(2, "0");
const scheduledFor = `${an}-${luna}-${zi}T10:00:00`;

console.log("Programat pentru: " + scheduledFor);

// Payload Zernio
const payload = {
  content: articol,
  scheduledFor: scheduledFor,      
  timezone: "Europe/Bucharest",
  platforms: platforme
};

if (imgUrl) {
  payload.mediaItems = [{ type: "image", url: imgUrl }];
  console.log("Imagine atasata: " + imgUrl);
}

// ============================================================
// PASUL 3: Trimite la Zernio API
// ============================================================
console.log("Trimit la Zernio...");

const zernioResp = await fetch("https://zernio.com/api/v1/posts", {
  method: "POST",
  headers: { "Content-Type": "application/json", "Authorization": "Bearer " + ZERNIO_API_KEY },
  body: JSON.stringify(payload)
});
const zernioData = await zernioResp.json();
if (!zernioResp.ok) throw new Error("Eroare Zernio: " + JSON.stringify(zernioData));

const zernioPostId = zernioData.post?._id || "";
console.log("Programat cu succes! Post ID: " + zernioPostId);

console.log("Gata! Postarea va fi publicata maine la 10:00.");