📱 Typefully Bulk Scheduler for Google Sheets

Schedule hundreds of posts to Twitter/X, Threads, Mastodon, LinkedIn, and Bluesky via Typefully in seconds – directly from Google Sheets.

What You Get

A Google Apps Script that turns any Google Sheet into a powerful social media scheduling dashboard. Write your posts in bulk, click one button, and let Typefully handle the rest.

✨ Features

• ✅ Bulk scheduling - Process unlimited posts at once
• 📱 Multi-platform - Posts go to all platforms connected in Typefully (Twitter/X, Threads, Mastodon, LinkedIn)
• 🔄 Smart retry logic - Automatically retries failed posts on re-run
• 📊 Status tracking - See which posts are scheduled, which failed
• 🔗 Direct links - Get Typefully URLs for each scheduled post
• ⚙️ Fully customizable - Configure columns, scheduling options, and more
• 🛡️ Safe re-runs - Won't duplicate already-scheduled posts

🚀 Setup (5 Minutes)

Step 1: Get Your Typefully API Key

1. Go to Typefully Settings → Integrations
2. Generate an API key
3. Copy it

Step 2: Install the Script

1. Open your Google Sheet
2. Click Extensions → Apps Script
3. Delete any existing code
4. Paste the script you received
5. At the top of the script, replace 'YOUR_API_KEY_HERE' with your actual API key
6. Click 💾 Save (name it something like "Typefully Scheduler")
7. Close the Apps Script tab

Step 3: First Run

1. Reload your Google Sheet (refresh the page)
2. You'll see a new 📱 Typefully menu at the top
3. Click 📱 Typefully → 📤 Schedule Posts
4. Grant permissions when prompted (first time only)
   • Click "Review permissions"
   • Select your Google account
   • Click "Allow"
5. Done! The script will now run

📝 How to Use

Basic Setup

1. Column A: Write your post content (one post per row)
2. Column B: Status (auto-filled by script)
3. Column C: Typefully URL (auto-filled by script)

Scheduling Posts

1. Add posts to Column A (starting from row 2)
2. Click 📱 Typefully → 📤 Schedule Posts
3. Watch the magic happen! ✨

Status Indicators

• ⏳ Processing... - Currently scheduling
• ✅ Scheduled - Successfully scheduled
• ❌ Error: [reason] - Failed (will retry on next run)

⚙️ Configuration Options

All settings are at the top of the script:

// Your API Key
var API_KEY = 'YOUR_TYPEFULLY_API_KEY_HERE';

// Customize columns (A, B, C, etc.)
var COLUMN_POST_CONTENT = 'A';
var COLUMN_STATUS = 'B';
var COLUMN_URL = 'C';

// Row range
var STARTING_ROW = 2;        // Skip header row
var ENDING_ROW = null;       // Process all rows (or set to 100, etc.)

// Publishing options
var PUBLISH_OPTIONS = {
  share: true,               // true = schedule, false = save as draft
  scheduleDate: 'next-free-slot', // or 'now' or '2024-12-25T10:00:00Z'
  autoRetweetEnabled: true,
  autoPlugEnabled: true,
  threadify: true           // Auto-split long posts
};

🔥 Pro Tips

• Test first: Set ENDING_ROW = 5 to test with just 5 posts
• Batch processing: Schedule 100 posts, then set STARTING_ROW = 101 for the next batch
• Retry errors: Just re-run the script – it automatically retries failed posts
• Draft mode: Set share: false to create drafts instead of scheduling
• Custom timing: Use scheduleDate: 'now' for immediate posting

❓ Frequently Asked Questions

Q: Which platforms does this support?
A: Whatever platforms you have connected in Typefully – Twitter/X, Threads, Mastodon, Bluesky, LinkedIn. Posts go to ALL connected platforms automatically.

Q: Will it reschedule posts if I run it again?
A: No. It only schedules new posts and retries failed ones. Successfully scheduled posts are always skipped.

Q: How many posts can I schedule at once?
A: Unlimited. The script processes your entire sheet (or your specified row range).

Q: What if I get a permission error?
A: Click "Review permissions", select your account, click "Advanced", then "Allow". This is normal for custom scripts.

Q: Can I change which columns are used?
A: Yes! Edit COLUMN_POST_CONTENT, COLUMN_STATUS, and COLUMN_URL at the top of the script.

Q: Does this work with Typefully's scheduling slots?
A: Yes! Set scheduleDate: 'next-free-slot' to use your Typefully posting schedule.

Q: What happens if my API key is invalid?
A: The script validates your key and shows a helpful error message with instructions.

Q: Can I schedule to only one platform?
A: No – this uses Typefully's API which posts to all connected platforms. But you can manage platforms in Typefully settings, by turning off accounts for new drafts.

Q: Is my data secure?
A: Yes. The script runs entirely in YOUR Google account. Your API key and posts never leave your environment.

🆘 Support

Having issues? Check these common solutions:

1. "API Key Missing" error: Add your Typefully API key at the top of the script
2. Permission denied: Re-run and carefully follow the permission prompts
3. Nothing happens: Refresh Google Sheets after installing the script
4. Posts not showing: Check your Typefully account – they're there!

🎯 Requirements

• Google account (free)
• Typefully account (free or paid)
• Typefully API key (get from Settings → Integrations)