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

I am woman, hear me roar. This cast was automated from Google Sheets.

Holy fuck nevermind my code works HAHAHAHAHAH

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

katherinechampagne.com

LMAO you can even SEE IN MY SCREENSHOT it worked and I was like whyyyyy is not workinngggggg when I came to post. SMH

Holy fuck nevermind my code works HAHAHAHAHAH 
https://warpcast.com/keccers.eth/0x4027251a

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

HAVE FUN (I did)

🐑🐑FX trader /My Channel→/handmade
Mom son👦15yo daughter👧13yo
/from Japan🇯🇵