How to Post from Airtable to Social Media

Step-by-step

1. 1

   Create the Airtable schema

   Build a Posts table with these fields: Caption (long text — the post body), Media URL (URL — public HTTPS link to image or video), Scheduled At (date+time), Platforms (multi-select where each option is one of: instagram, tiktok, x, linkedin, youtube, facebook, threads, pinterest, bluesky, google_business, snapchat), Status (single select with options: draft, ready, scheduled, publishing, completed, failed), Profile (single select listing your CodivUpload profile names), CodivUpload Post ID (text — populated by the script), and Result URL (URL — populated by sync-back).

2. 2

   Add a Send to CodivUpload button

   Add a Button field to the table. Configure it to run an Automation Script (Airtable's scripting environment runs in a sandboxed JS runtime). The script reads the row's fields, builds the CodivUpload payload using profile_name + platforms, and stores the returned post id back on the row.

   let table = base.getTable("Posts");
   let record = await input.recordAsync("Pick a post", table);
   if (!record) return;
   
   let platforms = (record.getCellValue("Platforms") || []).map(p => p.name);
   
   let payload = {
       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"),
   };
   
   let res = await fetch("https://api.codivupload.com/v1/posts", {
       method: "POST",
       headers: {
           "Authorization": "Bearer YOUR_API_KEY",
           "Content-Type": "application/json",
       },
       body: JSON.stringify(payload),
   });
   
   let json = await res.json();
   await table.updateRecordAsync(record, {
       "Status":              { name: res.ok ? "scheduled" : "failed" },
       "CodivUpload Post ID": json.post_id || "",
   });

3. 3

   Add a sync-back automation

   Schedule a 15-minute Automation that runs an Inspect script: fetch all rows where Status is scheduled or publishing, GET https://api.codivupload.com/v1/posts/{Post ID} for each, and update the Status column based on the response. This keeps Airtable in sync with the actual publishing state without you having to refresh manually. For very high-volume bases, switch to webhooks via /v1/webhooks pointing at an Airtable webhook trigger — push instead of poll.

4. 4

   Show per-platform results in a linked Destinations table

   Create a Destinations table linked to Posts. After the sync-back fires, populate it with one row per platform — Platform, Status, Post URL, Error Message. Now your team sees granular per-platform results inside calendar view: a post can appear green on Instagram and red on TikTok if one destination failed, and the Error Message column tells you exactly why.

5. 5

   Bulk-schedule from a filtered view

   Adapt the script to loop over a view filtered by Status=ready. Set up the trigger as When record matches conditions (Status changes to ready) so each row goes through the full pipeline automatically. Throttle with a small delay (200 ms) between iterations to stay under your API key's rate limits.

Frequently asked