✴.·´¯`·.·★  🎀𝓗𝓞𝓦 𝓣𝓞 𝓜𝓐𝓚𝓔 𝓐 𝓒𝓐𝓢𝓣 𝓢𝓒𝓗𝓔𝓓𝓤𝓛𝓔𝓡 𝓤𝓢𝓘𝓝𝓖 𝓖𝓞𝓞𝓖𝓛𝓔 𝓢𝓗𝓔𝓔𝓣𝓢🎀  ★·.·`¯´·.✴

Create a cast scheduler in GSheets! Post while you sleep! 

1. Fork and dump your own keys into this Repl to get your own personal post API 
https://replit.com/@katherinechampa/Write-to-Farcaster?v=1

2. Make a new Google Sheet. Give column A the header "Cast" and column B the header "Post Time". Name the sheet 'Scheduler'. Format the Post Time column for Date/Time. 

3. In the Google Sheets menu, go to Extensions>Apps Script. (pic 1)

4. This will take you to the AppsScript Menu and allow you to create a container bound script for that spreadsheet. You'll see something that looks like an IDE. (pic 2)

5. Take the code in this Gist. Fill out the configuration details. Dump it in to AppsScript and save it. 
https://gist.github.com/keccers/fdb80916c9697079d0626723a2b22e2b

CONTINUED IN REPLY

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

katherinechampagne.com

Very cool! Thanks for sharing this. Definitely going to give it a try later.

FID 1580 | Husband + dad (x2). Building @ SkillsEngine. Product, design, code, art, philosophy, systems.

Have fun and please do tell us what you get up to!!! There honestly is so much cool stuff a personal posting route enables. Gsheets just the start!