#itsallaboutkey

like i said in the post, i used these items for the first row: title, character, status, reader's gender, published on ao3, published on tumblr, AU1, AU2, publish date, length, word count, fluff, smut, angst, other themes. so add those or whichever ones you need (i originally had two for "group" and "member" just in case i decided to write for different groups, but since i haven't i haven't had the need to use them, i suppose smth like this can be useful if you write for several fandoms):

once you have them there, select the items and click on this button and "create new filter view", this will help out later if you want to see only specific things:

once you have that, you can start filling in your second row with your info:

now, this step i did bc it makes it easier for me to find stuff, i fixed the position of the very first row and the columns from "title" to "character". this way when you scroll you can always see those items. so first, select the entire first row (you can do so by clicking on the "1" on the left), right click, click on "view more row actions" and then "freeze up to row 1":

then do the same for the columns you want. if you want to freeze a set of letters (in my case, i want letter A to letter D to be fixed), go to the last letter in the group, click on it so it selects the entire column, go to "view more column actions" and then "freeze up to column D" (this letter will depend on the one you need of course, it won't always be D):

once you have that is just a matter of filling everything in :)

i realised yesterday i can also link directly to google docs in the spreadsheet, so i have been adding those links in the "title" column for easy access !

(to add a link you just select the cell you want, right click, "insert link"):

and then you can either add a link to the web (like an AO3 link) or you can search your google doc: