Hey! If there are any #EnergyTwitter denizens here who'd like to help make #EnergyMastodon a thing, I've set up a little google form & spreadsheet to accumulate handles for folks to follow. If you want to put your info in and circulate it on the bird site and help new folks get oriented that would be great! #energy #ClimateChange #RenewableEnergy #oott #NuclearEnergy #EnergyPolicy #EconTwitter

Form: https://forms.gle/UorSJKDaUKLBG4CC8

Responses: https://docs.google.com/spreadsheets/d/1GngE-upMxqWdZG_r1SOFTyIZQnyeTAWvZWC4thqeDms/edit?resourcekey=undefined#gid=655244727

Let's organize a Mastodon Energy Community

Let's make it easier for #EnergyTwitter to meet #EnergyMastodon! It seems like a great platform for bringing together people with shared niche interests, away from the sometimes frantic vibes of Twitter. If you'd like more background, Danielle Navarro wrote a great introduction to Mastodon. Enter your Twitter and Mastodon handles in the form below. They will both appear in a public spreadsheet. Put your Mastodon handle in your Twitter bio or display name. This lets us verify that it's really you (the owner of the Twitter account) who entered a Mastodon handle here. It will also make it easier for your Twitter followers to find you using tools like Debirdify. Complete your Mastodon profile and bio. You may want to start out with the same profile pic that you use on Twitter, so people can recognize you immediately. Having a bio and a profile pic also makes it much more likely that someone will follow you back as a new account. Put a link to your Twitter profile in your Mastodon profile (use the "profile metadata" section). This lets us verify that the Mastodon account is really controlled by the same person as the Twitter account. Make an introduction post on Mastodon using the #introduction and #EnergyTwitter hashtags. Feel free to add other hashtags so folks who share your interests can find you! e.g. #ClimateChange #EnergyTransition #RenewableEnergy #ClimateJustice #oott #NuclearEnergy (Note: CamelCase helps screen-readers parse multi-word hashtags correctly for the visually impaired.) Boost #introduction posts from folks you already know and love! We'll compile a list of new accounts every week and do an #EnergyTwitter #FollowFriday thread. Periodically import new follows (very optional): If following a bunch of people by hand becomes tedious, we've added 2 tabs to the response spreadsheet that contain lists of accounts ready for import into Mastodon as CSVs. One contains all the bidirectionally verified accounts (with the profile links mentioned above) and the other is just all of the accounts that have filled out the form. Make sure you use the "merge" and not "overwrite" option when you import!

Google Docs

@ZaneSelvans I was just about to ask if you could include formatting to import accounts here. But you already did it!

Are you checking the T<-->M links by hand? Seems possible to automate with the APIs. Probably will also take more time though...

https://xkcd.com/1319/

Automation

xkcd
@gschivley I've been validating them by hand, but yeah I was thinking all we'd have to do to soft-automate it is load both profiles, and grep for the URL. What's the easiest way to hook that logic up to a Google Sheet?
@ZaneSelvans The google API to read/update the cell values? Have a Python script run every 15 min, read each row, determine true/false, then update the row.
@gschivley Last time I tried messing around with Sheets in Python / with Pandas it seemed janky. But it was a while ago. What's the best intro you know of?

@ZaneSelvans oops, forgot to include this link. Not sure it's even worth trying to work in pandas.

https://developers.google.com/sheets/api/guides/values

Reading & Writing Cell Values  |  Sheets API  |  Google Developers

Google Developers
@gschivley Yeah probs not a pandas thing. That was just my previous experience and probably a lot of why it felt janky!
@ZaneSelvans @gschivley I wonder if Apps Script can do this (JavaScript embedded in a Google sheet)
@ThatcherUlrich @gschivley I'm poking around at the Python API and would love to learn how to do this kind of thing anyway. But I have a utility data release to get out this week 🙃
@ThatcherUlrich @gschivley But it does seem like there might end up being enough people on the list that it'd be worthwhile to automate!