Bluesky client in Google Sheets

ATProto Google Sheet#

ATProto in a Google Sheet.

Usage#

Add the script#

  1. Make a new Google Sheet (i.e. by going to sheets.new)
  2. Open Google Apps Script (Extensions -> Apps Script)
  3. Paste the content of src/code.gs in

Setup the sheet#

  1. Make a button (Insert -> Drawing, draw a rectangle or something like that)
  2. Link the button (Hover over it, click the three dots, press "Assign Script", set it to postToBluesky)
  3. Put post content in A2
  4. Put an app password in A27, handle in B27, and PDS (without https://) in C27

You can then press the button made in steps 1 and 2 to post the content of A2

More usage#

Resolve handle to DID: =RESOLVEHANDLE(handle) Get post content: =GETPOST(did, post-rkey)

FAQ#

Why#

I have nothing better to do right now (I don't feel like getting out of bed to plug in my laptop to play games)