Current Events > Not sure where to ask - help with automating something

(+) Yeah! (+)

I run a fantasy football league, and we have a keeper spot. A keeper spot is where each team can keep a player from the previous season, provided they meet the rules criteria. I'll outline my current process:

1. In Google Sheets, I have a sheet with the teams and their final rosters from the previous season. I get these rosters from Yahoo Fantasy Football, where our league is hosted.
2. Each new season, I go in the Google sheet and enter last year's rosters manually.
3. I go to last season's draft results in Yahoo Fantasy Football, and enter the draft positions into the Google sheet.

These are the parts that take the longest, I'm wondering if there's any way to speed this up, either through a macro or whatever. I know nothing about programming. Yahoo doesn't seem to have any kind of export function, but I'm sure copy/paste could be utilized.

I did try searching a couple boards on Reddit to see if there was some community there, but wasn't sure what to search.

bluezero posted...

I know nothing about programming

what you're describing doesn't sound terribly difficult, but does require some programming knowledge. since you don't know how to code, I'm not sure what options you have, other than asking a programmer to do this for you.

edit: this may help you. if you can somehow export the Yahoo data, Google Sheets has various options to import it. this won't be quite as effortless as a fully automated process, but if you can one-click export and one-click import, that would save you the effort of manual data entry.

https://blog.coupler.io/how-to-import-data-into-google-sheets/

TC, do a search for "yahoo fantasy sports API"

I did a quick scan of that and it seems to be the track you want

In case you don't know, an API is an interface that lets you tap into to pull data. The free access is often limited, but for a small league, it's probably more than enough

Thanks! I'll look into both of these.