someone-build

Editorial cast calendar

What's the simplest way to set up an account that would do the following:

1. You put draft casts in a Google Sheet or Airtable column
2. A second column has a date / time for publishing
3. When time arrives, draft cast is sent out

I got nerdsniped and wasted a few hours figuring this out. I'm stuck on the Google Sheets part at the moment (WIP pictured, lol). 

I actually thought this was going to be the easiest part — I used to basically exclusively use GSheets as my database for personal code projects and have a fair bit of experience wrangling AppsScript. I think I'm getting predictably hoed on DateTime type issues. It might be the wrong approach to try and run this as a GSheet extension, as well. 

Regardless later tonight I'll publish the repl with the code example that shows you how you can can set up your own personal API route for writing to your own Warpcast account programmatically. 

You will be able to: 
- Fork Repl
- Add in your own Neynar Key and Neynar Signer (free tier is fine)
- Deploy
- You now have a way to publish to your own account in any vibecode experiment you want to run

The repl is ready! → https://replit.com/@katherinechampa/Write-to-Farcaster?v=1#README.md

HAVE FUN (I did)

The Farcaster formerly known as Kchamp. Books, beats, bodybuilding, bright ideas and beautiful things.

katherinechampagne.com