keccers
@keccers.eth
โด.ยทยดยฏ`ยท.ยทโ ย ๐๐๐๐ฆ ๐ฃ๐ ๐๐๐๐ ๐ ๐๐๐ข๐ฃ ๐ข๐๐๐๐๐ค๐๐๐ก ๐ค๐ข๐๐๐ ๐๐๐๐๐๐ ๐ข๐๐๐๐ฃ๐ข๐ ย โ ยท.ยท`ยฏยดยท.โด 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
3 replies
8 recasts
22 reactions
Vivacious ๐ฉ๐
@vivacious
Wow, tysm! I didn't know that
0 reply
0 recast
1 reaction
