Back to Typefully in Excel
SheetXAI logo
Typefully logo
Typefully · Excel Guide

Bulk Create Typefully Drafts From a Excel workbook

2026-05-14
5 min read

The Scenario

You're a social media manager at a B2B SaaS company. Every month you and the content team spend two hours in an Excel workbook writing out the next four weeks of Twitter/X posts — content in column A, scheduled date and time in column B, account tag in column C. It's good editorial work. The problem comes after.

Getting those thirty-plus rows into Typefully as drafts is something nobody has officially been assigned to do, so it defaults to whoever has the most time — which, this month, is you.

The bad version:

  • You open Typefully, create a new draft, copy the first row's content from the workbook, paste it in, click the schedule picker, find the matching date from column B, set it, click save, and go back to the workbook.
  • You repeat this for every row. Around row 12 you stop double-checking the scheduled times because it's taking too long.
  • You finish, close both tabs, and two days later someone notices three posts were scheduled for the wrong week.

The thing is, this isn't your job. You're supposed to be reviewing performance and planning next month's strategy. The hour you just spent as a human CSV importer is an hour you will never get credited for.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook — content, dates, account tags, all of it — and through its built-in Typefully integration it pushes drafts directly into your queue. No copying. No clicking through the Typefully UI row by row.

Open SheetXAI in the sidebar and give it a prompt like this:

For each row in columns A, B, and C of the "April Calendar" worksheet, create a Typefully draft using the post content from column A. Where column B contains a date and time, schedule the draft for that time. Write the returned Typefully draft ID back into column D.

What You Get

  • A Typefully draft created for every row in the worksheet, with content exactly as written in column A.
  • Scheduled publish times set from column B wherever a valid date is present — unscheduled rows land as unscheduled drafts.
  • Draft IDs written back into column D so you have an auditable record of what was created and can cross-reference if anything looks off.
  • Any row where the Typefully API returns an error gets flagged in column D with the error reason rather than silently skipping.

What If the Data Is Not Quite Ready

The date column has mixed formats

Some rows in column B have dates formatted as "April 14, 2026 at 2pm" and others as "2026-04-14 14:00." Typefully's API expects ISO 8601. Rather than manually cleaning the column, ask SheetXAI to handle the normalization inline:

For each row in the "April Calendar" worksheet, normalize the date in column B to ISO 8601 format, then create a Typefully draft using column A content scheduled for that time. Write draft IDs into column D.

Some rows are marked as "skip" in column C

Your content calendar has a status column — some rows are marked "Draft," some "Ready," and some "Skip." You only want to push the "Ready" rows:

Create Typefully drafts for all rows in the "April Calendar" worksheet where column C contains "Ready." Use column A for post content and column B for scheduled time. Write draft IDs to column D.

Posts are split across multiple worksheets by platform

Your workbook has a "Twitter" worksheet and a "LinkedIn" worksheet. You want to push both into Typefully in one operation:

Create Typefully drafts for all rows in the "Twitter" worksheet and all rows in the "LinkedIn" worksheet. For each, use column A for content and column B for scheduled time. Write confirmation IDs into column C of each respective worksheet.

The full kill chain: clean, filter, deduplicate, then push

You've inherited a workbook that has some duplicate rows, some rows with empty content cells, and mixed date formats. Rather than cleaning it first and pushing second:

In the "April Calendar" worksheet, remove any rows where column A is empty, deduplicate rows with identical content in column A, normalize column B dates to ISO 8601, then create Typefully drafts for all remaining rows and write the returned draft IDs into column D.

One prompt. SheetXAI cleans, deduplicates, formats, and pushes — in sequence, without switching tools.

Try It

Open any Excel workbook where your content team has been building out scheduled posts, and get the 7-day free trial of SheetXAI — then ask it to push your entire planned calendar into Typefully in one shot. If you're also building a published content log, see Export Recently Published Typefully Posts to an Excel workbook. For an overview of all Typefully + Excel workflows, visit the Typefully Excel hub.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more