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
23 reactions
keccers
@keccers.eth
6. To safely store your API key, go into your script settings and save it in the Script Properties. 7. Go back to your sheet and refresh. You should be greeted with a pop-up telling you that you have a Scheduler now. (You will have to authorize it once to start playing with it and it will look scary because you didn't go through the Google publish process. But it's fine. Personal software baby) 8. Customize it to your liking. Or don't use it at all (honestly, please don't) and have Claude one-shot you something new (because that is all this is, code Claude one-shot for me), but follow these instructions to set it up because you loosely know how to use AppsScript now. 9. Remember feedback here is not instant and be patient if you feel like it's not working. Do not keep jamming test casts in wondering if it worked. Maybe add better logging than I have. 10. It will work when the tab is closed.
0 reply
1 recast
2 reactions
Max Miner
@mxmnr
Very cool! Thanks for sharing this. Definitely going to give it a try later.
1 reply
0 recast
1 reaction
Vivacious 🎩💎
@vivacious
Wow, tysm! I didn't know that
0 reply
0 recast
1 reaction
