Schedule social posts from Airtable to 9 platforms

The Automation Script

Drop this into an Airtable Automation triggered by "When record matches conditions" with Status = scheduled. It reads the row, posts to CodivUpload, and writes the returned id back.

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

const table = base.getTable("Posts");
const record = await table.selectRecordAsync(recordId, {
    fields: ["Profile", "Caption", "Media URL", "Scheduled At", "Platforms"],
});

const platforms = (record.getCellValue("Platforms") || []).map(p => p.name);

const res = await fetch("https://api.codivupload.com/v1/posts", {
    method: "POST",
    headers: {
        "Authorization": "Bearer " + inputConfig.apiKey,
        "Content-Type": "application/json",
    },
    body: JSON.stringify({
        post_type:      "image",
        profile_name:   record.getCellValueAsString("Profile"),
        platforms:      platforms,
        media_urls:     [record.getCellValue("Media URL")],
        description:    record.getCellValue("Caption"),
        scheduled_date: record.getCellValueAsString("Scheduled At"),
    }),
});

const json = await res.json();
await table.updateRecordAsync(record, {
    "Status":  { name: res.ok ? "scheduled" : "failed" },
    "Post ID": json.post_id || "",
});